Tests and issues
Galera Cluster is a great and powerful solution. However, issues could happen and we're going to see here how to resolve them.
First of all, and as always, look at the logs (syslog by default); important information is written there and most of the time the problem will be explicit!
Paused replication
Sometimes, during a very high load write demand, the Cluster may stop replicating during this phase. Generally, this is not a good situation and you should avoid this kind of query as much as possible.
One solution can be to use an intermediate software layer to avoid it, for example, a Advanced Message Queuing Protocol (AMQP) software such as RabbitMQ or ZeroMQ. The setup of this kind of tool is out of the scope of this book.
To detect ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access