O'Reilly MySQL High Availability Tools for Building Robust Data Centers
by Charles Bell, Mats Kindahl, and Lars Thalmann
This book is for MySQL professionals. We expect you to have a basic background in SQL, administering MySQL, and the operating system you are running. We will try to fill in background information about replication, disaster recovery, system monitoring, and other key topics of high availability. See Chapter 1 for other books that offer useful background.
Organization of This Book
This book is written in three parts. Part I encompasses MySQL replication, including high availability and scale-out. Part II examines monitoring and performance concerns for building robust data centers. Part III examines some additional areas of MySQL, including cloud computing and MySQL clusters.
Part I, Replication
1, Introduction, explains how this book can help you and gives you a context for reading it.
2, MySQL Replication Fundamentals, discusses both manual and automated procedures for setting up basic replication.
3, The Binary Log, explains the critical file that ties together replication and helps in disaster recovery, troubleshooting, and other administrative tasks.
4, Replication for High Availability, shows a number of ways to recover from server failure, including the use of automated scripts.
5, MySQL Replication for Scale-Out, shows a number of techniques and topologies for improving response time and handling large data sets.
6, Advanced Replication, addresses a number of topics, such as secure data transfer and row-based replication.
Part II, Monitoring and Disaster Recovery
7, Getting Started with Monitoring, presents the main operating system parameters you have to be aware of, and tools for monitoring them.
8, Monitoring MySQL, presents several tools for monitoring database activity and performance.
9, Storage Engine Monitoring, explains some of the parameters you need to monitor on a more detailed level, focusing on issues specific to MyISAM or InnoDB.
10, Replication Monitoring, offers details about how to keep track of what masters and slaves are doing.
11, Replication Troubleshooting, shows how to deal with failures and restarts, corruption, and other incidents.
12, Protecting Your Investment, explains the use of backups and disaster recovery techniques.
13, MySQL Enterprise, introduces a suite of tools that simplifies many of the tasks presented in earlier chapters.
Part III, High Availability Environments
14, Cloud Computing Solutions, introduces the most popular cloud computing service, the Amazon.com AWS, and offers techniques for using MySQL in such virtualized environments.
15, MySQL Cluster, shows how to use this tool to achieve high availability.
The Appendix, Replication Tips and Tricks, offers a grab bag of procedures that are useful in certain situations.
O'Reilly MySQL High Availability Tools for Building Robust Data Centers Download:
mysql-high-availability-tools-for-building-robust-data-centers.rar (5.10 MB)