Galera Cluster Setup - Revision history

Michael.mast at 13:33, 4 August 2016

2016-08-04T13:33:07Z

Michael.mast: /* CentOS 7 */

2016-07-22T21:24:41Z

CentOS 7

Michael.mast at 21:16, 22 July 2016

2016-07-22T21:16:44Z

Michael.mast at 21:13, 22 July 2016

2016-07-22T21:13:10Z

Michael.mast at 20:36, 22 July 2016

2016-07-22T20:36:32Z

Michael.mast: Created page with "#https://mariadb.com/kb/en/mariadb/yum/#installing-mariadb-galera-cluster-with-yum #https://geekdudes.wordpress.com/2015/07/18/setting-up-failover-cluster-for-mariadb-on-cento..."

2016-07-22T20:28:22Z

Created page with "#https://mariadb.com/kb/en/mariadb/yum/#installing-mariadb-galera-cluster-with-yum #https://geekdudes.wordpress.com/2015/07/18/setting-up-failover-cluster-for-mariadb-on-cento..."

New page

#https://mariadb.com/kb/en/mariadb/yum/#installing-mariadb-galera-cluster-with-yum
#https://geekdudes.wordpress.com/2015/07/18/setting-up-failover-cluster-for-mariadb-on-centos-7/
#http://mrbriancollins.blogspot.com/2015/12/mariadb-101-galera-cluster-in-centos-7.html

@@ Line 30: / Line 30: @@
 </pre>
 [root@db1 ~]# systemctl stop mysql<br>
 [root@db1 ~]# nano /etc/my.cnf.d/server.cnf<br>
 <pre>

@@ Line 48: / Line 48: @@
 bind-address=0.0.0.0
 </pre>
-[root@db1 ~]#<br>
+[root@db1 ~]# galera_new_cluster<br>
-[root@db1 ~]#<br>
+*When running this bootstrap script mysql will be started automatically. If you restart mariadb/mysql the bootstrap will be lost and you will be stuck.
-[root@db1 ~]#<br>
+[root@db1 ~]# mysql -u root -ptest -e "show status like 'wsrep%'"
-[root@db1 ~]#<br>
+*The output should show a lot of information about wsrep modules. One of which should show the number of nodes as one. At this point we are now working in node 2.
-[root@db1 ~]#<br>
+*Node 2 is the same process with a few exceptions. you want to modify the wsrep_node_address= setting to reflect the address of node2. The other change is that we will not be running the bootstrap script, but instead start the mysql as usual.

@@ Line 7: / Line 7: @@
 <br>
 ==CentOS 7==
-First off, MariaDB now has Galera baked in so make sure to install the latest stable version.
+First off, MariaDB now has Galera baked in so make sure to install the latest stable version.<br>
-[root@db1 ~]# yum autoremove mariadb mariadb-server
+[root@db1 ~]# yum autoremove mariadb mariadb-server<br>
-[root@db1 ~]# nano /etc/yum.repos.d/mariadb.repo
+[root@db1 ~]# nano /etc/yum.repos.d/mariadb.repo<br>
 <pre>
 [mariadb]
@@ Line 17: / Line 17: @@
 gpgcheck=1
 </pre>
-[root@db1 ~]# yum install MariaDB-server MariaDB-client
+[root@db1 ~]# yum install MariaDB-server MariaDB-client<br>
-[root@db1 ~]# systemctl start mysql
+[root@db1 ~]# systemctl start mysql<br>
-[root@db1 ~]# mysql_secure_installation
+[root@db1 ~]# mysql_secure_installation<br>
-*Create a root password and accept all other defaults. Later we will create the user account that will allow replication.
+*Create a root password and accept all other defaults. Later we will create the user account that will allow replication.<br>
-[root@db1 ~]# mysql -uroot -p
+[root@db1 ~]# mysql -uroot -p<br>
 <pre>
 MariaDB [(none)]> grant all on *.* to 'root'@'%' identified by 'password';
@@ Line 28: / Line 28: @@
 MariaDB [(none)]> flush privileges;
 MariaDB [(none)]> exit
-[root@db1 ~]# systemctl stop mysql
+</pre>
-[root@db1 ~]# nano /etc/my.cnf.d/server.cnf
+[root@db1 ~]# systemctl stop mysql<br>
 <pre>
+#
@@ Line 37: / Line 38: @@
 wsrep_on=ON
 wsrep_provider=/usr/lib64/galera/libgalera_smm.so
-wsrep_cluster_address=gcomm://10.200.3.2,10.200.3.3
+wsrep_cluster_address=gcomm://xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx #IPs of all nodes in cluster
 wsrep_cluster_name='mariadb_cluster'
-wsrep_node_address='10.200.3.2'
+wsrep_node_address='xxx.xxx.xxxx.xxx' #IP of node1
 wsrep_sst_method=rsync
-wsrep_sst_auth=cluseruser:test
+wsrep_sst_auth=cluster_user:password2
 binlog_format=row
 default_storage_engine=InnoDB
@@ Line 47: / Line 48: @@
 bind-address=0.0.0.0
 </pre>
-[root@db1 ~]#
+[root@db1 ~]#<br>
-[root@db1 ~]#
+[root@db1 ~]#<br>
-[root@db1 ~]#
+[root@db1 ~]#<br>
-[root@db1 ~]#
+[root@db1 ~]#<br>
-[root@db1 ~]#
+[root@db1 ~]#<br>

← Older revision		Revision as of 21:13, 22 July 2016
Line 3:		Line 3:
	#http://mrbriancollins.blogspot.com/2015/12/mariadb-101-galera-cluster-in-centos-7.html		#http://mrbriancollins.blogspot.com/2015/12/mariadb-101-galera-cluster-in-centos-7.html
	#https://groups.google.com/forum/#!msg/codership-team/a5S0aExW2oI/fY5yBGdSWUYJ		#https://groups.google.com/forum/#!msg/codership-team/a5S0aExW2oI/fY5yBGdSWUYJ
		+	<br>
		+	Wow, it took way too long to figure out how to configure this. But before I forget here are the steps I took.
		+	<br>
		+	==CentOS 7==
		+	First off, MariaDB now has Galera baked in so make sure to install the latest stable version.
		+	[root@db1 ~]# yum autoremove mariadb mariadb-server
		+	[root@db1 ~]# nano /etc/yum.repos.d/mariadb.repo
		+	<pre>
		+	[mariadb]
		+	name = MariaDB
		+	baseurl = http://yum.mariadb.org/10.1.16/centos7-amd64
		+	gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
		+	gpgcheck=1
		+	</pre>
		+	[root@db1 ~]# yum install MariaDB-server MariaDB-client
		+	[root@db1 ~]# systemctl start mysql
		+	[root@db1 ~]# mysql_secure_installation
		+	*Create a root password and accept all other defaults. Later we will create the user account that will allow replication.
		+	[root@db1 ~]# mysql -uroot -p
		+	<pre>
		+	MariaDB [(none)]> grant all on . to 'root'@'%' identified by 'password';
		+	MariaDB [(none)]> grant usage on . to 'cluster_user'@'%' identified by 'password2';
		+	MariaDB [(none)]> grant all privileges on . to 'cluster_user'@'%';
		+	MariaDB [(none)]> flush privileges;
		+	MariaDB [(none)]> exit
		+	[root@db1 ~]# systemctl stop mysql
		+	[root@db1 ~]# nano /etc/my.cnf.d/server.cnf
		+	<pre>
		+	#
		+	# * Galera-related settings
		+	#
		+	[galera]
		+	wsrep_on=ON
		+	wsrep_provider=/usr/lib64/galera/libgalera_smm.so
		+	wsrep_cluster_address=gcomm://10.200.3.2,10.200.3.3
		+	wsrep_cluster_name='mariadb_cluster'
		+	wsrep_node_address='10.200.3.2'
		+	wsrep_sst_method=rsync
		+	wsrep_sst_auth=cluseruser:test
		+	binlog_format=row
		+	default_storage_engine=InnoDB
		+	innodb_autoinc_lock_mode=2
		+	bind-address=0.0.0.0
		+	</pre>
		+	[root@db1 ~]#
		+	[root@db1 ~]#
		+	[root@db1 ~]#
		+	[root@db1 ~]#
		+	[root@db1 ~]#

← Older revision		Revision as of 20:36, 22 July 2016
Line 2:		Line 2:
	#https://geekdudes.wordpress.com/2015/07/18/setting-up-failover-cluster-for-mariadb-on-centos-7/		#https://geekdudes.wordpress.com/2015/07/18/setting-up-failover-cluster-for-mariadb-on-centos-7/
	#http://mrbriancollins.blogspot.com/2015/12/mariadb-101-galera-cluster-in-centos-7.html		#http://mrbriancollins.blogspot.com/2015/12/mariadb-101-galera-cluster-in-centos-7.html
		+	#https://groups.google.com/forum/#!msg/codership-team/a5S0aExW2oI/fY5yBGdSWUYJ