MariaDB - Revision history

Torben: /* Centos/RHEL */

2018-02-25T14:43:19Z

Centos/RHEL

← Older revision		Revision as of 14:43, 25 February 2018
Line 107:		Line 107:

	https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html		https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html

			"Due to a bug in socat on CentOS 7, the xtrabackup-v2 method does not work. This can be solved by installing an older version of socat or by using the rsync method for wsrep_sst_method"

	remember		remember
	* so

	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?

2018-02-25T14:41:57Z

Centos/RHEL

← Older revision		Revision as of 14:41, 25 February 2018
Line 109:		Line 109:

	remember		remember
	* ~~yum install socat nc~~		* so

	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* If using xtrabackup transfer		* If using xtrabackup transfer
			** socat in centos 7/rehl 7 doesn't work with SST - so install anothter one
	** to set <code>wsrep_sst_method=xtrabackup-v2</code>		** to set <code>wsrep_sst_method=xtrabackup-v2</code>
	** and set wsrep_sst_auth="user:secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]		** and set wsrep_sst_auth="user:secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]

2018-02-25T14:19:39Z

Centos/RHEL

← Older revision		Revision as of 14:19, 25 February 2018
Line 109:		Line 109:

	remember		remember
			* yum install socat nc
	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* If using xtrabackup transfer		* If using xtrabackup transfer
Line 117:		Line 118:
	*** mysql@percona1> GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO 'sstuser'@'localhost';		*** mysql@percona1> GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO 'sstuser'@'localhost';
	*** mysql@percona1> FLUSH PRIVILEGES;		*** mysql@percona1> FLUSH PRIVILEGES;
	* install socat !!!
	* disable selinux !!!!		* disable selinux !!!!
	* disable host firewall totally		* disable host firewall totally
	** systemctl stop firewalld		** systemctl stop firewalld
	** systemctl disable firewalld		** systemctl disable firewalld

2018-02-25T14:10:36Z

Centos/RHEL

← Older revision		Revision as of 14:10, 25 February 2018
Line 110:		Line 110:
	remember		remember
	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* to set <code>wsrep_sst_method=xtrabackup-v2</code>		* If using xtrabackup transfer
			** to set <code>wsrep_sst_method=xtrabackup-v2</code>
	** and set wsrep_sst_auth="user:secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]		** and set wsrep_sst_auth="user:secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]
			** and create the user
			*** mysql@percona1> CREATE USER 'sstuser'@'localhost' IDENTIFIED BY 's3cret';
			*** mysql@percona1> GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO 'sstuser'@'localhost';
			*** mysql@percona1> FLUSH PRIVILEGES;
	* install socat !!!		* install socat !!!
	* disable selinux !!!!		* disable selinux !!!!

2018-02-25T14:04:16Z

Centos/RHEL

← Older revision		Revision as of 14:04, 25 February 2018
Line 111:		Line 111:
	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* to set <code>wsrep_sst_method=xtrabackup-v2</code>		* to set <code>wsrep_sst_method=xtrabackup-v2</code>
	** and set wsrep_sst_auth="secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]		** and set wsrep_sst_auth="user:secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]
	* install socat !!!		* install socat !!!
	* disable selinux !!!!		* disable selinux !!!!

2018-02-25T14:03:58Z

Centos/RHEL

← Older revision		Revision as of 14:03, 25 February 2018
Line 111:		Line 111:
	* (define your cluster as a set of hostnames and NOT as a list of IP's) ?		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* to set <code>wsrep_sst_method=xtrabackup-v2</code>		* to set <code>wsrep_sst_method=xtrabackup-v2</code>
			** and set wsrep_sst_auth="secret" [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/centos_howto.html]
	* install socat !!!		* install socat !!!
	* disable selinux !!!!		* disable selinux !!!!

2018-02-25T14:00:30Z

Centos/RHEL

← Older revision		Revision as of 14:00, 25 February 2018
Line 109:		Line 109:

	remember		remember
	* to set <code>wsrep_sst_method=xtrabackup-v2</code>		* (define your cluster as a set of hostnames and NOT as a list of IP's) ?
	* install socat !!!		* to set <code>wsrep_sst_method=xtrabackup-v2</code>
			* install socat !!!
	disable host firewall totally		* disable selinux !!!!
	systemctl stop firewalld		* disable host firewall totally
	systemctl disable firewalld		** systemctl stop firewalld
			** systemctl disable firewalld

2018-02-25T13:43:47Z

Centos/RHEL

← Older revision		Revision as of 13:43, 25 February 2018
Line 108:		Line 108:
	https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html		https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html

	remember to set		remember
	wsrep_sst_method=xtrabackup-v2		* to set <code>wsrep_sst_method=xtrabackup-v2</code>
			* install socat !!!

	disable host firewall totally		disable host firewall totally
	systemctl stop firewalld		systemctl stop firewalld
	systemctl disable firewalld		systemctl disable firewalld

2018-02-25T13:36:20Z

Centos/RHEL

← Older revision		Revision as of 13:36, 25 February 2018
Line 107:		Line 107:

	https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html		https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html

			remember to set
			wsrep_sst_method=xtrabackup-v2

			disable host firewall totally
			systemctl stop firewalld
			systemctl disable firewalld

2018-02-25T13:28:45Z

Centos/RHEL

← Older revision		Revision as of 13:28, 25 February 2018
Line 105:		Line 105:
	==Centos/RHEL==		==Centos/RHEL==
	https://github.com/Tunts/bakery/wiki/Setting-up-MariaDB-10.1---Galera-Cluster-on-Centos-7		https://github.com/Tunts/bakery/wiki/Setting-up-MariaDB-10.1---Galera-Cluster-on-Centos-7

			https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/yum_repo.html