Hands on Maxscale and Galera Cluster Centos7

MariaDB MaxScale is a database proxy that extends the high availability, scalability, and security of MariaDB Server while at the same time simplifying application development by decoupling it from underlying database infrastructure. First Create 4 Nodes of Centminmod InstallationNode1:192.168.1.1 (CMM Installed) (MariaDB Cluster 1)Node2:192.168.1.2 (CMM Installed) (MariaDB Cluster 2)Node3:192.168.1.3 (CMM Installed) (MariaDB Cluster 3)Node4:192.168.1.4 (CMM Installed) (Maxscale) Open These ports 4567,4568,4444,3306 under TCP in your firewall (CSF or IPTABLES) on All MariaDB Cluster nodes. On 192.168.1.1 (CMM Installed) (MariaDB Cluster 1) Edit my.cnf file and at the end add lines…

Read More