Clustered DB Replication

galera-mysqlnd_ms.md

php module mysqlnd_ms

mysqlnd_ms.enable = On
; mysqlnd_ms.config_file = /etc/mysqlnd_ms_plugin.ini
mysqlnd_ms.config_file = /etc/mysqlnd_ms_plugin.json
mysqlnd_ms.multi_master = On
mysqlnd_ms.collect_statistics = On
mysqlnd_ms.force_config_usage = On

/etc/mysqlnd_ms_plugin.json

{
	"localhost" : {
		"master" : {
			"master_1" : {
				"host" : "IP_NODE_1",
				"port" : "3306"
			},
			"master_2" : {
				"host" : "IP_NODE_2",
				"port" : "3306"
			}
		},
		"slave" : {
			
		},
		"filters" : {
			"roundrobin" : {
				
			}
		},
		"failover" : {
			"strategy" : "loop_before_master",
			"remember_failed" : true
		}
	}
}

• MySQL Load Balancing with HAProxy - Tutorial
• Galera Load Balancer
• Multicast replication in Percona XtraDB Cluster (PXC) and Galera
• MariaDB Enterprise – Getting Started Guide (Beta)
• Limitations Galera
• Avoiding Deadlocks in Galera
• Galera als Replikationsersatz
• Configurator for Galera Replication - version 2.7
• ClusterControl
• Moodle with clustered DB replication issues