Combining Galera and asynchronous replication in the same MariaDB
setup, aka Hybrid Replication, can be useful - e.g. as a live
backup node in a remote datacenter or reporting/analytics server.
We already blogged about this setup for Codership/Galera or Percona XtraDB
Cluster users, but master failover did not work for MariaDB
because of its different GTID approach. In this post, we will
show you how to deploy an asynchronous replication slave to
MariaDB Galera Cluster 10.x (with master failover!), using GTID
with ClusterControl v1.2.10.
Preparing the Master
First and foremost, you must ensure that the master and slave
nodes are running on MariaDB Galera 10.0.2 or later. MariaDB
replication slave requires at least a master with GTID among the
Galera nodes. However, we would recommend users to configure …
[Read more]