Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. To protect your system from outages, MySQL provides several features that work well whether you're running directly on the hardware, on virtual machines, or in the cloud. But to use features such as replication, clusters, and monitoring tools effectively, you need to understand how they work together, and which combination of features will give you the most reliable system for a price you can afford.
Written by the people who designed these features, MySQL High Availability covers all aspects of reliability and high availability in MySQL from a practical point of view. You'll learn skills essential to any organization that depends on a MySQL database.
Topics include:
- Replication architecture
- Tools for replication management
- Failover strategies
- Disaster recovery strategies
- Leveraging the cloud
- Using the binary log for recovery and troubleshooting
- Writing replication-friendly SQL
- Improving response time with memcached
- Monitoring the server
- Load balancing
- Automating common replication tasks
- MySQL Cluster
- Diagnostic tools
- Backup and recovery
- MySQL and third party backup solutions
- MySQL Enterprise
Comments