Book description
There’s more than one way to achieve high availability for MySQL and this Cookbook covers a range of techniques and tools in over 60 practical recipes. The only book of its kind, you’ll be learning the natural, engaging way.
- Analyze and learn different high availability options, including clustering and replication solutions within MySQL
- Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL
- Tune your MySQL database for optimal performance.
- The only complete, practical, book of MySQL high availability techniques and tools on the market
- Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible
In Detail
High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.
MySQL, 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 MySQL 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 MySQL, but most are both poorly understood and documented.
This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL 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 MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3.
The book starts by introducing MySQL 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 MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster.
We also have a look at achieving high availability for MySQL databases with the techniques of MySQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD.
Finally, you will learn the principles of Performance tuning and tune MySQL database for optimal performance.
A cookbook containing recipes for all the common high availability techniques for database administrators to tackle real-world challenges to achieve high availability using MySQL
Table of contents
-
High Availability MySQL Cookbook
- Table of Contents
- High Availability MySQL Cookbook
- Credits
- About the Author
- About the Reviewers
- Preface
-
1. High Availability with MySQL Cluster
- Introduction
- Designing a MySQL Cluster
- Creating an initial cluster configuration file—config.ini
- Installing a management node
- Starting a management node
- Installing and starting storage nodes
- Installing and starting SQL nodes
- Creating a MySQL Cluster table
- Restarting a MySQL Cluster without downtime
- Recovering from a cluster shutdown
- 2. MySQL Cluster Backup and Recovery
- 3. MySQL Cluster Management
- 4. MySQL Cluster Troubleshooting
-
5. High Availability with MySQL Replication
- Introduction
- Designing a replication setup
- Configuring a replication master
- Configuring a replication slave without syncing data
- Configuring a replication slave, migrating data with a simple SQL dump
- Using LVM to reduce downtime on a master when bringing a slave online
- Replication safety tricks
- Multi Master Replication Manager (MMM): initial installation
- Multi Master Replication Manager (MMM): installing the MySQL nodes
- Multi Master Replication Manager (MMM): installing monitoring node
- Managing and using Multi Master Replication Manager (MMM)
- 6. High Availability with MySQL and Shared Storage
- 7. High Availability with Block Level Replication
- 8. Performance Tuning
- A. Base Installation
- B. LVM and MySQL
- C. Highly Available Architectures
- Index
Product information
- Title: High Availability MySQL Cookbook
- Author(s):
- Release date: April 2010
- Publisher(s): Packt Publishing
- ISBN: 9781847199942
You might also like
book
PostgreSQL 12 High Availability Cookbook
A comprehensive guide to understanding key techniques for architecture and hardware planning, monitoring, replication, backups, and …
book
MySQL 8 Cookbook
Design and administer enterprise-grade MySQL 8 solutions About This Book Store, retrieve, and manipulate your data …
book
MySQL Cookbook
While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. …
book
MySQL High Availability, 2nd Edition
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t …