Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.

Written by engineers who designed many of the tools covered inside, "MySQL High Availability" (O'Reilly, ISBN: 9780596807306, 624 pages) reveals undocumented or hard-to-find aspects of MySQL reliability and high availability -- knowledge that's essential for any organization using this database system.

"There is a dichotomy between the skills of MySQL professionals and available literature explaining how to leverage MySQL in a high availability role," explains co-author Charles Bell. "This book fills that gap. Enterprises need to know how to do more with less as they grow their businesses under the demands of tighter budgets and growing IT needs."

With MySQL High Availability you will:

• Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
• Get techniques for improving response time and handling large data sets
• Monitor database activity and performance, as well as major operating system parameters
• Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
• Automate key tasks with code from an open source library written by the authors
• Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
• Use MySQL Cluster to achieve high availability

About the Authors

Dr. Charles Bell is a senior developer working on replication and backup. His interests include database theory, software engineering, and agile development practices.

Dr. Mats Kindahl is the lead developer for replication on the MySQL Replication and Backup team.

Dr. Lars Thalmann is the development manager and technical lead of the MySQL Replication and Backup team and has designed many replication and backup features.

More Information

more information about the book including sample content, full table of contents, author bio, and cover graphic [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter

Other articles in the MySQL section of Volume 149, Issue 2: MySQL Enterprise Monitor: Business Overview MySQL High Availability -- Tools for Building Robust Data Centers (this article) See all archived articles in the MySQL section.

Top 10 Most Popular Articles in Current Issue (Vol 167, Issue 4) Simplified Administration with ZFS Documentation for Common Sysadmin Tasks Solaris 10 OS and ZFS Cut Costs, Boost Uptime as Alternative to RAID Oracle Certified Associate (OCA), Oracle Solaris 11 System Administrator MySQL: An Introduction for Oracle DBAs illumos Meetup at FOSDEM Linux Adoption Trends 2012: A Survey of Enterprise End Users MySQL 5.0 and 5.1 available on Solaris 11 World Record x86 TPC-C Result Java Spotlight Episode 65: Deployment & Plugin Recent Blog Entries as of February 4, 2012, 11:50 am Oracle Enterprise Manager Enables Cerner Health Care to Cut Capital Expenditures by $9.5 Million Beefing Up Xeon Reliability, Availability, and Serviceability: Slide Set Java Spotlight Episode 54: Stuart Marks on the Coinification of JDK7 Getting PostgreSQL HA to Work in vFabric Data Director November 9th, Oracle Solaris 11 Launch, New York City The [System] Developer's Edge: 322 page pdf Oracle Global IT Upgrades to Sun Storage Products UNIX - Dead or alive? LibreOffice Adopts ODF 1.2 as an OASIS Standard The Growth Prospects for Tape vs. HDD and NAND as a Storage Devices Blog RSS Feed