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 ...
Get MariaDB High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
