High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.My SQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a My SQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to ...
High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.My SQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a My SQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add ‘redundancy’ and ‘high availability’ to My SQL, but most are both poorly understood and documented.This book will provide you with recipes showing how to design, implement, and manage a My SQL Cluster and achieve high availability using My SQL replication, block level replication, shared storage, and the open source Global File System (GFS).This book covers all the major techniques available for increasing availability of your My SQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available My SQL setup using any one of several techniques, which are shown in different recipes. It is based on My SQL Cluster 7.0, My SQL (for non clustered recipes) 5.0.77, and Cent OS / Red Hat Enterprise Linux 5.3.The book starts by introducing My SQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the My SQL Cluster. By following the practical examples in this book, you will learn how to manage the My SQL Cluster. Further, we will discuss some troubleshooting aspects of the My SQL Cluster.We also have a look at achieving high availability for My SQL databases with the techniques of My SQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD.Finally, you will learn the principles of Performance tuning and tune My SQL database for optimal performance.
