3 ms·
I'd like to know answers on this. The main thing I like about MySQL-based solutions is the availability of Galera multi-master software, which for simple confi
by throw0101c 4y ago
I'd like to know answers on this.
The main thing I like about MySQL-based solutions is the availability of Galera multi-master software, which for simple configurations is very easy to get going. Drop a fairly cookie-cutter config on each host, and you're done:
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://First_Node_IP,Second_Node_IP,Third_Node_IP"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="This_Node_IP"
wsrep_node_name="This_Node_Name"
Combine with keepalived on each node which does a health check, and if one goes down/bad, the vIP is moved over to another host in the cluster with minimal fuss.
- jmartrican 4y agoIs that part of Galera free or licensed?
- throw0101c 4y agoGPL 2.0 * https://github.com/codership/galera https://github.com/codership/galera