High Availability MySQL Cookbook review
High Availability MySQL Cookbook (Alex Davies, Packt Publishing) presents different approaches to achieve high availability with MySQL.
The bulk of the book is dedicated to MySQL Cluster, with shorter sections on:
- MySQL replication
- shared storage
- block level replication
- performance tuning
The recipes are clear and well explained, based on a CentOS distribution, and it seems any technically skilled person could follow them without issues.
What’s lacking are some design aspects. Based on this material, one probably wouldn’t be able to decide what the best high availability architecture is for a given problem. Actually, one may even be tempted to think MySQL Cluster is the best fit for most scenarios, given the percentage of the book dedicated to it. Nevertheless, there’s a section about Cluster limitations and potential problems, so the cautious reader won’t be tempted to choose this solution for every new project.
I also found that some important considerations regarding replication are missing.
The reader is instructed to rely on Seconds_Behind_Master alone to monitor replication, and there’s no mention to the situations that can cause as slave to go out of sync, nor of a process to fix this problem.
However, this book is a useful addition to any MySQL practitioner’s library, provided you don’t expect to rely only on it to design and deploy your MySQL based highly available services.
Related posts:
- MySQL Certification self study I’m taking the MySQL Certification exams soon, and while I’d...
- Using MySQL sandbox for testing MySQL Sandbox is a great tool for quickly deploying test...
- Indexing text columns in MySQL This time, I’m talking about indexes for string typed columns....
- Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each request,...
- Updated mysql-proxy benchmarking script (for proxy 0.7) My previous post contained a lua script for MySQL proxy...
Related posts brought to you by Yet Another Related Posts Plugin.
Comments are closed.