Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies some changes in the way you have to configure the Galera nodes. Here are some of the most common misconceptions about Galera when using Percona XtraDB Cluster.
Q: Why should I enable binary logging as it is not needed by
Galera replication?
Unlike for regular asynchronous MySQL replication, it is true
that you don’t need to enable binary logging to use Galera
replication. However what if someone runs an accidental
DROP TABLE
?
In this case, the statement will be replicated immediately on all nodes. Then your main option to recover lost data is to use a backup. But if binary logging is not …
[Read more]