MySQL High Availability

Tools for Building Robust Data Centers

Charles Bell, Mats Kindahl, Lars Thalmann (Autoren)

Buch | Softcover

762 Seiten

2014 | 2. Auflage
O'Reilly Media (Verlag)
978-1-4493-3958-6 (ISBN)

Artikel merken

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.

Learn replication fundamentals, including use of the binary log and MySQL Replicant Library
Handle failing components through redundancy
Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases
Store and replicate data on individual nodes with MySQL Cluster
Monitor database activity and performance, and major operating system parameters
Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents
Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

Dr. Charles A. Bell is a Senior Software Engineer at Oracle. He is currently the lead developer for backup and a member of the MySQL Backup and Replication team.He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005.

Dr. Mats Kindahl is a senior software developer working on the MySQL server. He is the main architect and implementor of MySQL's row-based replication and is responsible for strategic development of replication, reengineering, and the plugin architecture.

Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication.

Erscheint lt. Verlag	27.5.2014
Zusatzinfo	Illustrations
Verlagsort	Sebastopol
Sprache	englisch
Maße	178 x 233 mm
Gewicht	1211 g
Einbandart	kartoniert
Themenwelt	Informatik ► Datenbanken ► MySQL
ISBN-10	1-4493-3958-1 / 1449339581
ISBN-13	978-1-4493-3958-6 / 9781449339586
Zustand	Neuware