{"id":5370,"date":"2015-10-18T11:26:15","date_gmt":"2015-10-18T03:26:15","guid":{"rendered":"http:\/\/rmohan.com\/?p=5370"},"modified":"2015-10-18T22:27:16","modified_gmt":"2015-10-18T14:27:16","slug":"multi-master-mariadb-galera-cluster","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=5370","title":{"rendered":"multi-master MariaDB Galera Cluster"},"content":{"rendered":"

CentOS 6.7 Linux compilation configure a multi-master MariaDB Galera Cluster for HA.<\/h1>\n

Multi-master MariaDB Galera Cluster<\/strong><\/p>\n

Summary
\nGalera is essentially a wsrep provider (provider), relies on the wsrep API interface. Wsrep API defines a set of applications and replication callback call library to implement transaction database synchronization write set (writeset) replication, and similar applications. The purpose is to achieve the abstract, isolated copied from the application details. While the main objective of the interface is based on the certification of multi-master replication, but the same applies to asynchronous and synchronous master-slave replication.
\nPersonal feeling MariaDB Galera across the room to do a multi-master is still very convenient, than direct shots from good use MySQL. Like with other clusters, in order to avoid node split brain and destroy data, we recommend a minimum Galera Cluster add three nodes. Galera Cluster in the case of high concurrency, may occur when multiple simultaneous write transaction main conflict, this time only one transaction request will be successful, all others failed. You can write \/ update fails, the automatic retry, and then returns the result. Node status of each node is equal, there is no primary and secondary, to read any one node effect is the same. Can actually fit VIP \/ LVS or HA uses to achieve high availability. If all the machines in the cluster restart, such as room off, the first start of the server must be started with an empty address.
\nGalera Cluster is a set of synchronous multi-master MySQL replication cluster solution, easy to use, there is no single point of failure, high availability, can be very good at all times to ensure the safety and the expansion of our data when business is growing.
\nFirst, compile and install MariaDB Galera Here to talk about multi-master cluster<\/p>\n

cluster1.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.60\u00a0\u00a0\u00a0 MariaDB
\ncluster2.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.62\u00a0\u00a0\u00a0 MariaDB
\ncluster3.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.63\u00a0\u00a0\u00a0 MariaDB<\/p>\n

Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node<\/p>\n

1, install ntpdate to set timing on node cluster1 cluster2 cluster3 each other synchronization and ssh<\/p>\n

yum install -y ntpdate
\nyum install openssh-askpass -y
\nyum -y install openssh-client<\/p>\n

echo “*\/5 * * * * \/usr\/sbin\/ntpdate pool.ntp.org >\/dev\/null 2>&1″ >> \/var\/spool\/cron\/root<\/p>\n

\/usr\/sbin\/ntpdate pool.ntp.org<\/p>\n

cat >>\/etc\/hosts<< EOF
\n192.168.1.60\u00a0 cluster1.rmohan.com\u00a0 cluster1
\n192.168.1.62\u00a0 cluster2.rmohan.com\u00a0 cluster2
\n192.168.1.63\u00a0 cluster3.rmohan.com\u00a0 cluster3
\nEOF<\/p>\n

Here is the production of a key ###<\/p>\n

ssh-keygen\u00a0 -t rsa -f ~\/.ssh\/id_rsa\u00a0 -P ”
\n### The following are performed on each node, so that the public key of the machine onto the other nodes
\nawk ‘{if ($0!~\/'”$(hostname)”‘|localhost\/)print $NF}’ \/etc\/hosts |xargs -i ssh-copy-id -i ~\/.ssh\/id_rsa.pub root@{}<\/p>\n

2, installed base build environment<\/p>\n

Add EPEL Repository which is provided from Fedora project.
\nyum -y install epel-release
\n# set [priority=5]<\/p>\n

sed -i -e “s\/\\]$\/\\]\\npriority=5\/g” \/etc\/yum.repos.d\/epel.repo
\n# for another way, change to [enabled=0] and use it only when needed
\nsed -i -e “s\/enabled=1\/enabled=0\/g” \/etc\/yum.repos.d\/epel.repo
\n# if [enabled=0], input a command to use the repository
\nyum –enablerepo=epel install [Package]<\/p>\n

Add RPMforge Repository which provides many useful packages.<\/p>\n

yum -y install http:\/\/pkgs.repoforge.org\/rpmforge-release\/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
\n# set [priority=10]
\nsed -i -e “s\/\\]$\/\\]\\npriority=10\/g” \/etc\/yum.repos.d\/rpmforge.repo
\n# for another way, change to [enabled=0] and use it only when needed
\nsed -i -e “s\/enabled = 1\/enabled = 0\/g” \/etc\/yum.repos.d\/rpmforge.repo
\n# if [enabled=0], input a command to use the repository
\nyum –enablerepo=rpmforge install [Package]<\/p>\n

rpm -ivh http:\/\/mirrors.aliyun.com\/epel\/epel-release-latest-6.noarch.rpm
\nrpm –import http:\/\/mirrors.dwhd.org\/epel\/RPM-GPG-KEY-EPEL-6
\nrpm -ivh http:\/\/pkgs.repoforge.org\/rpmforge-release\/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
\nrpm –import http:\/\/mirrors.dwhd.org\/repoforge\/RPM-GPG-KEY.dag.txt<\/p>\n

yum clean all && yum makecache
\nyum groupinstall “Development tools” “Server Platform Development” -y
\nyum install libxml2-devel lz4 lz4-devel libpcap nmap lsof socat -y<\/p>\n

3, Node1 compile install MariaDB Galera<\/p>\n

### Download Source Package cmake
\n[root@cluster1 ~]# wget http:\/\/cmake.org\/files\/v3.4\/cmake-3.4.0-rc1.tar.gz
\n### Download mariadb-galera source package
\n[root@cluster1 ~]#\u00a0 wget http:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/source\/mariadb-galera-10.0.21.tar.gz
\n### Download Source Package kytea
\n[root@cluster1 ~]# wget http:\/\/www.phontron.com\/kytea\/download\/kytea-0.4.7.tar.gz
\n### Will cmake, mariadb-galera, kytea Source Package spread to other nodes<\/p>\n

[root@cluster1 ~]#\u00a0 awk ‘{if ($0!~\/'”$(hostname)”‘|localhost\/)print $NF}’ \/etc\/hosts |xargs -i scp cmake-3.4.0-rc1.tar.gz mariadb-galera-10.0.21.tar.gz kytea-0.4.7.tar.gz root@{}:\/root<\/p>\n

3, Cluster1 compile install MariaDB Galera<\/p>\n

### Compile and install cmake
\n[root@cluster1 ~]# tar xf cmake-3.4.0-rc1.tar.gz
\n[Root @ cluster1 ~] # cd cmake-3.4.0-rc1
\n[root@cluster1 cmake-3.4.0-rc1]# .\/bootstrap
\n[root@cluster1 cmake-3.4.0-rc1]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..\/
\n### Compiler installation kytea
\n[root@cluster1 ~]# tar xf kytea-0.4.7.tar.gz
\n[root@cluster1 ~]# cd kytea-0.4.7\/
\n[root@cluster1 ~\/kytea-0.4.7]# .\/configure && make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n### Installation Galera
\n[root@cluster1 ~]# rpm –import https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\n[root@cluster1 ~]# rpm -ivh http:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\nhttp:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\n### Compile and install MariaDB Galera
\n[root@cluster1 ~]# mkdir -p \/data\/mariadb-galera-10.0.21
\n[root@cluster1 ~]# chown -R mysql.mysql \/data\/mariadb-galera-10.0.21
\n[root@cluster1 ~]# tar -xvf mariadb-galera-10.0.21.tar.gz
\n[root@cluster1 ~]# cd mariadb-10.0.21\/
\n[root@cluster1 ~\/mariadb-10.0.21]# cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mariadb \\
\n-DMYSQL_DATADIR=\/data\/mariadb-galera-10.0.21 \\
\n-DWITH_SSL=system -DWITH_INNOBASE_STORAGE_ENGINE=1 \\
\n-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\
\n-DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 \\
\n-DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 \\
\n-DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 \\
\n-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \\
\n-DWITH_EMBEDDED_SERVER=1 -DWITH_READLINE=1 -DWITH_ZLIB=system \\
\n-DWITH_LIBWRAP=0 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 \\
\n-DMYSQL_UNIX_ADDR=\/tmp\/mysql.sock -DDEFAULT_CHARSET=utf8 \\
\n-DDEFAULT_COLLATION=utf8_general_ci \\
\n-DWITH_WSREP=1 -DWITH_INNODB_DISALLOW_WRITES=1
\n[root@cluster1 ~\/mariadb-10.0.21]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n[root@cluster1 ~]#<\/p>\n

4, cluster2 compile install MariaDB Galera
\n### Compile and install cmake
\n[root@cluster2 ~]# tar xf cmake-3.4.0-rc1.tar.gz
\n[Root @ cluster2 ~] # cd cmake-3.4.0-rc1
\n[root@cluster2 cmake-3.4.0-rc1]# .\/bootstrap
\n[root@cluster2 cmake-3.4.0-rc1]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..\/
\n### Compiler installation kytea
\n[root@cluster2 ~]# tar xf kytea-0.4.7.tar.gz
\n[root@cluster2 ~]# cd kytea-0.4.7\/
\n[root@cluster2 ~\/kytea-0.4.7]# .\/configure && make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n### Installation Galera
\n[root@cluster2 ~]# rpm –import https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\n[root@cluster2 ~]# rpm -ivh http:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\nhttp:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\n### Compile and install MariaDB Galera
\n[root@cluster2 ~]# mkdir -p \/data\/mariadb-galera-10.0.21
\n[root@cluster2 ~]# chown -R mysql.mysql \/data\/mariadb-galera-10.0.21
\n[root@cluster2 ~]# tar -xvf mariadb-galera-10.0.21.tar.gz
\n[root@cluster2 ~]# cd mariadb-10.0.21\/
\n[root@cluster2 ~\/mariadb-10.0.21]# cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mariadb \\
\n-DMYSQL_DATADIR=\/data\/mariadb-galera-10.0.21 \\
\n-DWITH_SSL=system -DWITH_INNOBASE_STORAGE_ENGINE=1 \\
\n-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\
\n-DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 \\
\n-DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 \\
\n-DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 \\
\n-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \\
\n-DWITH_EMBEDDED_SERVER=1 -DWITH_READLINE=1 -DWITH_ZLIB=system \\
\n-DWITH_LIBWRAP=0 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 \\
\n-DMYSQL_UNIX_ADDR=\/tmp\/mysql.sock -DDEFAULT_CHARSET=utf8 \\
\n-DDEFAULT_COLLATION=utf8_general_ci \\
\n-DWITH_WSREP=1 -DWITH_INNODB_DISALLOW_WRITES=1
\n[root@cluster2 ~\/mariadb-10.0.21]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n[root@cluster2 ~]#<\/p>\n

5, Cluster3 compile install MariaDB Galera<\/p>\n

### Compile and install cmake
\n[root@cluster3 ~]# tar xf cmake-3.4.0-rc1.tar.gz
\n[Root @ cluster3 ~] # cd cmake-3.4.0-rc1
\n[root@cluster3 cmake-3.4.0-rc1]# .\/bootstrap
\n[root@cluster3 cmake-3.4.0-rc1]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..\/
\n### Compiler installation kytea
\n[root@cluster3 ~]# tar xf kytea-0.4.7.tar.gz
\n[root@cluster3 ~]# cd kytea-0.4.7\/
\n[root@cluster3 ~\/kytea-0.4.7]# .\/configure && make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n### Installation Galera
\n[root@cluster3 ~]# rpm –import https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\n[root@cluster3 ~]# rpm -ivh http:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\nhttp:\/\/mirrors.dwhd.org\/SQL\/MariaDB\/mariadb-galera-10.0.21\/galera-25.3.9\/rpm\/galera-25.3.9-1.rhel6.el6.x86_64.rpm
\n### Compile and install MariaDB Galera
\n[root@cluster3 ~]# mkdir -p \/data\/mariadb-galera-10.0.21
\n[root@cluster3 ~]# chown -R mysql.mysql \/data\/mariadb-galera-10.0.21
\n[root@cluster3 ~]# tar -xvf mariadb-galera-10.0.21.tar.gz
\n[root@cluster3 ~]# cd mariadb-10.0.21\/
\n[root@cluster3 ~\/mariadb-10.0.21]# cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mariadb \\
\n-DMYSQL_DATADIR=\/data\/mariadb-galera-10.0.21 \\
\n-DWITH_SSL=system -DWITH_INNOBASE_STORAGE_ENGINE=1 \\
\n-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\
\n-DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 \\
\n-DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 \\
\n-DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 \\
\n-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \\
\n-DWITH_EMBEDDED_SERVER=1 -DWITH_READLINE=1 -DWITH_ZLIB=system \\
\n-DWITH_LIBWRAP=0 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 \\
\n-DMYSQL_UNIX_ADDR=\/tmp\/mysql.sock -DDEFAULT_CHARSET=utf8 \\
\n-DDEFAULT_COLLATION=utf8_general_ci \\
\n-DWITH_WSREP=1 -DWITH_INNODB_DISALLOW_WRITES=1
\n[root@cluster3 ~\/mariadb-10.0.21]# make -j $(awk ‘\/processor\/{i++}END{print i}’ \/proc\/cpuinfo) && make install && cd ..
\n[root@cluster3 ~]#<\/p>\n

6, configure all nodes startup scripts, environment variables on<\/p>\n

cd \/usr\/local\/mariadb\/
\ncp support-files\/mysql.server \/etc\/rc.d\/init.d\/mysqld
\nchmod +x \/etc\/rc.d\/init.d\/mysqld
\ncp \/usr\/local\/mariadb\/support-files\/my-large.cnf \/etc\/my.cnf
\nsed -i ‘\/query_cache_size\/a datadir = \/data\/mariadb-galera-10.0.21’ \/etc\/my.cnf
\necho “export PATH=\/usr\/local\/mariadb\/bin:\\$PATH” > \/etc\/profile.d\/mariadb_galera.sh
\nsource \/etc\/profile.d\/mariadb_galera.sh
\nsed -i “$(awk ‘$1==”MANPATH”{i=NR}END{print i}’ \/etc\/man.config)a \\MANPATH\\tMANPATH \/usr\/local\/mariadb\/man” \/etc\/man.config<\/p>\n

7, Configuration node Cluster1
\n[root@cluster1 profile.d]# cd \/usr\/local\/mariadb
\n[root@cluster1 mariadb]# \/usr\/local\/mariadb\/scripts\/mysql_install_db –user=mysql –datadir=\/data\/mariadb-galera-10.0.21\/
\n[root@cluster1 mariadb]# cd && service mysqld start
\nStarting MySQL.. SUCCESS!
\n[root@cluster1 ~]# ss -tnl | grep :3306
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*
\n[root@cluster1\u00a0 ~]# mysql -uroot -p <<< “USE mysql;
\nupdate user set password=PASSWORD(‘test123′) WHERE USER=’root’;
\nDELETE FROM user WHERE User=”;
\nGRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;
\nSELECT USER,PASSWORD,HOST FROM user;”
\nEnter password: #### Note that the password is blank, just press Enter enough
\nUSER\u00a0\u00a0\u00a0 PASSWORD\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HOST
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cluster1.rmohan.com
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1
\ncluster *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 %
\n[root@cluster1 ~]#<\/p>\n

[root@cluster1~]# service mysqld stop
\nShutting down MySQL… SUCCESS!
\n[root@cluster1~]# chkconfig mysqld on
\n[root@cluster1 ~]# sed -i ‘\/binlog_format\/d’ \/etc\/my.cnf
\n[root@cluster1 ~]# sed -i ‘\/log_bin\/d’ \/etc\/my.cnf
\n[root@cluster1 ~]# sed -i ‘\/^datadir = \/a \\\\n\\nquery_cache_size = 0\\nlog_bin = mysql-bin\\nbinlog_format = ROW\\nexpire_logs_days = 30\\
\ndefault_storage_engine = InnoDB\\ninnodb_autoinc_lock_mode = 2\\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so\\
\nwsrep_cluster_address = “gcomm:\/\/”\\nwsrep_cluster_name = LegionMariadbGaleraCluster1\\nwsrep_node_address = node1\\
\nwsrep_sst_method = rsync\\nwsrep_sst_auth = cluster:test123’ \/etc\/my.cnf
\n[root@cluster1 ~]# service\u00a0 mysqld start
\nStarting MySQL.. SUCCESS!
\n[root@cluster1 ~]# ss -tnl | grep -E ‘:(3306|4567)’
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:4567\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:*<\/p>\n

vi \/etc\/my.cnf<\/p>\n

[client]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\n[mysqld]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\nskip-external-locking
\nkey_buffer_size = 256M
\nmax_allowed_packet = 1M
\ntable_open_cache = 256
\nsort_buffer_size = 1M
\nread_buffer_size = 1M
\nread_rnd_buffer_size = 4M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size= 16M
\ndatadir = \/data\/mariadb-galera-10.0.21\/
\nquery_cache_size = 0
\nlog_bin = mysql-bin
\nbinlog_format = ROW
\nexpire_logs_days = 30
\ndefault_storage_engine = InnoDB
\ninnodb_autoinc_lock_mode = 2
\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluster3”
\nwsrep_cluster_name = LegionMariadbGaleraCluster1
\nwsrep_node_address = 192.168.1.60
\nwsrep_sst_method = rsync
\nwsrep_sst_auth = cluster1:test123
\nquery_cache_size = 0
\nlog_bin = mysql-bin
\nbinlog_format = ROW
\nexpire_logs_days = 30
\ndefault_storage_engine = InnoDB
\ninnodb_autoinc_lock_mode = 2
\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluster3”
\nwsrep_cluster_name = LegionMariadbGaleraCluster1
\nwsrep_node_address=’192.168.1.60′
\nwsrep_node_name=’cluster1′
\nwsrep_sst_method=rsync
\nwsrep_sst_auth= cluster:lookback
\nthread_concurrency = 8
\nlog-bin=mysql-bin
\nserver-id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1
\ninnodb_log_file_size = 64M
\ninnodb_log_buffer_size = 8M
\ninnodb_flush_log_at_trx_commit = 1
\ninnodb_lock_wait_timeout = 50
\n[mysqldump]
\nquick
\nmax_allowed_packet = 16M
\n[mysql]
\nno-auto-rehash
\n[myisamchk]
\nkey_buffer_size = 128M
\nsort_buffer_size = 128M
\nread_buffer = 2M
\nwrite_buffer = 2M
\n[mysqlhotcopy]
\ninteractive-timeout<\/p>\n

### When I tested the rules, see the highlighted lines
\n[root@cluster1 ~]# iptables -t filter -A INPUT -s 192.168.1.60 -p tcp -m state –state NEW -m tcp –dport 3306 -j ACCEPT
\n[root@cluster1 ~]# iptables -t filter -A INPUT -s 192.168.1.60 -p tcp -m state –state NEW -m tcp –dport 4444 -j ACCEPT
\n[root@cluster1 ~]# iptables -t filter -A INPUT -s 192.168.1.60 -p tcp -m state –state NEW -m tcp –dport 4567 -j ACCEPT
\n[root@cluster1 ~]# iptables -t filter -A INPUT -s 192.168.1.60 -p udp -m udp –dport 4567 -j ACCEPT
\n[root@cluster1 ~]# service iptables save
\n[root@cluster1 ~]#iptables -t filter -L INPUT -n –line-numbers<\/p>\n

8, the configuration node Node2
\n[root@cluster2 \/usr\/local\/mariadb]# \/usr\/local\/mariadb\/scripts\/mysql_install_db –user=mysql –datadir=\/data\/mariadb-galera-10.0.21\/
\n[root@cluster2 \/usr\/local\/mariadb]# cd && service mysqld start
\nStarting MySQL.. SUCCESS!
\n[root@cluster2 ~]# mysql -uroot -p <<< “USE mysql;
\nupdate user set password=PASSWORD(‘test123′) WHERE USER=’root’;
\nDELETE FROM user WHERE User=”;
\nGRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;
\nSELECT USER,PASSWORD,HOST FROM user;”
\n[root@cluster2 ~]# service mysqld stop
\nShutting down MySQL.. SUCCESS!
\n[root@cluster2 ~]# chkconfig mysqld on
\n[root@cluster2 ~]# sed -i ‘\/binlog_format\/d’ \/etc\/my.cnf
\n[root@cluster2 ~]# sed -i ‘\/log.bin\/d’ \/etc\/my.cnf
\n[root@cluster2 ~]# sed -ri ‘s\/^(server-id).*\/\\1 = 2\/’ \/etc\/my.cnf
\n[root@cluster2 ~]# sed -i ‘\/^datadir = \/a \\\\n\\nquery_cache_size = 0\\nlog_bin = mysql-bin\\nbinlog_format = ROW\\nexpire_logs_days = 30\\
\ndefault_storage_engine = InnoDB\\ninnodb_autoinc_lock_mode = 2\\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so\\
\nwsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluser3″\\nwsrep_cluster_name = LegionMariadbGaleraCluster1\\n\\
\nwsrep_node_address = node2\\nwsrep_sst_method = rsync\\nwsrep_sst_auth = cluster:test123’ \/etc\/my.cnf
\n[root@cluster2 ~]# service mysqld start
\nStarting MySQL… SUCCESS!
\n[root@cluster2 ~]# ss -tnl | grep -E ‘:(3306|4567)’
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:4567\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:*
\n[root@cluster2 ~]#
\n[root@cluster2 ~]# grep -v ‘^$\\|^\\s*\\#’ \/etc\/my.cnf
\n[client]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\n[mysqld]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\nskip-external-locking
\nkey_buffer_size = 256M
\nmax_allowed_packet = 1M
\ntable_open_cache = 256
\nsort_buffer_size = 1M
\nread_buffer_size = 1M
\nread_rnd_buffer_size = 4M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size= 16M
\ndatadir = \/data\/mariadb-galera-10.0.21
\nquery_cache_size = 0
\nlog_bin = mysql-bin
\nbinlog_format = ROW
\nexpire_logs_days = 30
\ndefault_storage_engine = InnoDB
\ninnodb_autoinc_lock_mode = 2
\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluster3”
\nwsrep_cluster_name = LegionMariadbGaleraCluster1
\nwsrep_node_address = cluster2
\nwsrep_sst_method = rsync
\nwsrep_sst_auth = cluster2:test123
\nthread_concurrency = 8
\nserver-id = 2
\n[mysqldump]
\nquick
\nmax_allowed_packet = 16M
\n[mysql]
\nno-auto-rehash
\n[myisamchk]
\nkey_buffer_size = 128M
\nsort_buffer_size = 128M
\nread_buffer = 2M
\nwrite_buffer = 2M
\n[mysqlhotcopy]
\ninteractive-timeout<\/p>\n

9, the configuration node Node3<\/p>\n

[root@cluster3 \/usr\/local\/mariadb]# \/usr\/local\/mariadb\/scripts\/mysql_install_db –user=mysql –datadir=\/data\/mariadb-galera-10.0.21\/
\n[root@cluster3 \/usr\/local\/mariadb]# cd && service mysqld start
\nStarting MySQL.. SUCCESS!
\n[root@cluster3 ~]# mysql -uroot -p <<< “USE mysql; > update user set password=PASSWORD(‘test123′) WHERE USER=’root’;
\n> DELETE FROM user WHERE User=”;
\n> GRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\n> FLUSH PRIVILEGES;
\n> SELECT USER,PASSWORD,HOST FROM user;”
\nEnter password:
\nUSER\u00a0\u00a0\u00a0 PASSWORD\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HOST
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cluster3.ovh.net
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1
\nroot\u00a0\u00a0\u00a0 *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1
\ncluster *153CCFAEAA83407D8DBDBFAA3D17B1A95553E60C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 %
\n[root@cluster3 ~]# service mysqld stop
\nShutting down MySQL… SUCCESS!
\n[root@cluster3 ~]# chkconfig mysqld on
\n[root@cluster3 ~]# sed -i ‘\/binlog_format\/d’ \/etc\/my.cnf
\n[root@cluster3 ~]# sed -i ‘\/log.bin\/d’ \/etc\/my.cnf
\n[root@cluster3 ~]# sed -ri ‘s\/^(server-id).*\/\\1 = 3\/’ \/etc\/my.cnf
\n[root@cluster3 ~]# sed -i ‘\/^datadir = \/a \\\\n\\nquery_cache_size = 0\\nlog_bin = mysql-bin\\nbinlog_format = ROW\\nexpire_logs_days = 30\\
\n> default_storage_engine = InnoDB\\ninnodb_autoinc_lock_mode = 2\\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so\\
\n> wsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluster3″\\nwsrep_cluster_name = LegionMariadbGaleraCluster1\\n\\
\n> wsrep_node_address = node3\\nwsrep_sst_method = rsync\\nwsrep_sst_auth = cluster:test123’ \/etc\/my.cnf
\n[root@cluster3 ~]# service mysqld start
\nStarting MySQL..SST in progress, setting sleep higher.. SUCCESS!<\/p>\n

[root@cluster3 ~]# ss -tnl | grep -E ‘:(3306|4567)’
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*
\nLISTEN\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:4567\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *:*
\n[root@cluster3 ~]#
\n[root@cluster3 mariadb-galera-10.0.21]# grep -v ‘^$\\|^\\s*\\#’ \/etc\/my.cnf
\n[client]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\n[mysqld]
\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3306
\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/tmp\/mysql.sock
\nskip-external-locking
\nkey_buffer_size = 256M
\nmax_allowed_packet = 1M
\ntable_open_cache = 256
\nsort_buffer_size = 1M
\nread_buffer_size = 1M
\nread_rnd_buffer_size = 4M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size= 16M
\ndatadir = \/data\/mariadb-galera-10.0.21\/
\nquery_cache_size = 0
\nlog_bin = mysql-bin
\nbinlog_format = ROW
\nexpire_logs_days = 30
\ndefault_storage_engine = InnoDB
\ninnodb_autoinc_lock_mode = 2
\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address = “gcomm:\/\/cluster1,cluster2,cluster3”
\nwsrep_cluster_name = LegionMariadbGaleraCluster1
\nwsrep_node_address=’192.168.1.63′
\nwsrep_node_name = ‘cluster3’
\nwsrep_sst_method = rsync
\nwsrep_sst_auth = cluster3:test123
\nthread_concurrency = 8
\nserver-id = 3
\ninnodb_log_file_size = 64M
\ninnodb_log_buffer_size = 8M
\ninnodb_flush_log_at_trx_commit = 1
\ninnodb_lock_wait_timeout = 50
\n[mysqldump]
\nquick
\nmax_allowed_packet = 16M
\n[mysql]
\nno-auto-rehash
\n[myisamchk]
\nkey_buffer_size = 128M
\nsort_buffer_size = 128M
\nread_buffer = 2M
\nwrite_buffer = 2M
\n[mysqlhotcopy]
\ninteractive-timeout<\/p>\n

ISSUES<\/p>\n

Disable selinux
\nIptables off<\/p>\n

1018 16:36:28 [Warning] WSREP: (531d16f9, ‘tcp:\/\/0.0.0.0:4567’) address ‘tcp:\/\/192.168.1.60:4567’ points to own listening address, blacklisting
\n151018 16:36:31 [Warning] WSREP: no nodes coming from prim view, prim not possible
\n151018 16:36:31 [Note] WSREP: view(view_id(NON_PRIM,531d16f9,1) memb {
\n531d16f9,0
\n} joined {
\n} left {
\n} partitioned {
\n})
\n151018 16:36:31 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.5051S), skipping check
\n151018 16:37:01 [Note] WSREP: view((empty))
\n151018 16:37:01 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
\nat gcomm\/src\/pc.cpp:connect():161
\n151018 16:37:01 [ERROR] WSREP: gcs\/src\/gcs_core.cpp:long int gcs_core_open(gcs_core_t*, const char*, const char*, bool)():206: Failed to open backend connection: -110 (Connection timed out)
\n151018 16:37:01 [ERROR] WSREP: gcs\/src\/gcs.cpp:long int gcs_open(gcs_conn_t*, const char*, const char*, bool)():1379: Failed to open channel ‘LegionMariadbGaleraCluster1’ at ‘gcomm:\/\/192.168.1.60,192.168.1.62,192.168.1.63’: -110 (Connection timed out)
\n151018 16:37:01 [ERROR] WSREP: gcs connect failed: Connection timed out
\n151018 16:37:01 [ERROR] WSREP: wsrep::connect() failed: 7
\n151018 16:37:01 [ERROR] Aborting<\/p>\n

151018 16:37:01 [Note] WSREP: Service disconnected.
\n151018 16:37:02 [Note] WSREP: Some threads may fail to exit.
\n151018 16:37:02 [Note] \/usr\/local\/mariadb\/bin\/mysqld: Shutdown complete<\/p>\n

151018 16:37:02 mysqld_safe mysqld from pid file \/data\/mariadb-galera-10.0.21\/\/cluster1.rmohan.com.pid ended<\/p>\n

[ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)<\/p>\n

When node1 starts MySQL, it tries to join an existing cluster. But because both nodes are currently down, there is no primary node available (see this page for a good and short explanation).<\/p>\n

So when a Galera Cluster must be started from “zero” again, the first node must be started with the “wsrep-new-cluster” command (exactly during the set up of a new cluster):<\/p>\n

service mysql start –wsrep-new-cluster
\n* Starting MariaDB database server mysqld\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [ OK ]
\n* Checking for corrupt, not cleanly closed and upgrade needing tables.<\/p>\n

10, modify the node configuration Cluster1<\/p>\n

[root@cluster1 ~]# sed -ri ‘s\/^(wsrep_cluster_address).*\/\\1 = “gcomm:\\\/\\\/cluster1,cluster2,cluster3″\/’ \/etc\/my.cnf
\n[root@cluster1 ~]# service mysqld restart
\nShutting down MySQL…. SUCCESS!
\nStarting MySQL… SUCCESS!
\n[root@cluster1 ~]#<\/p>\n

11, the test cluster multi-master synchronization
\n[root@cluster1 ~]# mysql -uroot -ptest123 <<< ‘USE mysql;
\nCREATE DATABASE LegionTestDataBase;
\nUSE LegionTestDataBase;
\nCREATE TABLE equipment ( id INT NOT NULL AUTO_INCREMENT, type VARCHAR(50), quant INT, color VARCHAR(25), PRIMARY KEY(id));
\nINSERT INTO equipment (type, quant, color) VALUES (“slide”, 2, “blue”);
\nFLUSH PRIVILEGES;
\nSELECT * FROM LegionTestDataBase.equipment;’
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n[root@cluster1 ~]#<\/p>\n

INSERT FROM Cluster2<\/p>\n

root@cluster2 ~]# mysql -uroot -ptest123 <<< “USE LegionTestDataBase;
\nSELECT * FROM LegionTestDataBase.equipment;”
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n[root@cluster2 ~]# mysql -uroot -ptest123 <<< “USE LegionTestDataBase;
\nINSERT INTO equipment (type, quant, color) VALUES (‘swing’, 10, ‘yellow’);
\nSELECT * FROM LegionTestDataBase.equipment;”
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 swing\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0 yellow
\n[root@cluster2 ~]#<\/p>\n

INSERT FROM CLUSTER3<\/p>\n

[root@cluster3 ~]# mysql -uroot -ptest123 <<< “USE LegionTestDataBase;
\nSELECT * FROM LegionTestDataBase.equipment;”
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 swing\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0 yellow
\n[root@cluster3 ~]# mysql -uroot -ptest123 <<< “USE LegionTestDataBase;
\nINSERT INTO equipment (type, quant, color) VALUES (‘Legion’, 20, ‘red’);
\nSELECT * FROM LegionTestDataBase.equipment;”
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 swing\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0 yellow
\n6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Legion\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0 red
\n[root@cluster3 ~]#<\/p>\n

[root@cluster1 ~]# mysql -uroot -ptest123 <<< “USE LegionTestDataBase; SELECT * FROM LegionTestDataBase.equipment;”
\nid\u00a0\u00a0\u00a0\u00a0\u00a0 type\u00a0\u00a0\u00a0 quant\u00a0\u00a0 color
\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 slide\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blue
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 swing\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0 yellow
\n6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Legion\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0 red
\n[root@cluster1 ~]#<\/p>\n

After the above round of testing, multi-node cluster-wide primary MariaDB is OK. .<\/p>\n","protected":false},"excerpt":{"rendered":"

CentOS 6.7 Linux compilation configure a multi-master MariaDB Galera Cluster for HA. <\/p>\n

Multi-master MariaDB Galera Cluster<\/p>\n

Summary Galera is essentially a wsrep provider (provider), relies on the wsrep API interface. Wsrep API defines a set of applications and replication callback call library to implement transaction database synchronization write set (writeset) replication, and similar applications. The […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,72,16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5370"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5370"}],"version-history":[{"count":3,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5370\/revisions"}],"predecessor-version":[{"id":5375,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5370\/revisions\/5375"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}