MariaDB galera Cluster Dual-node deployment

Node 1:10.2.2.41

Node 2:10.2.2.42

Software: mariadb-galera-10.0.22-linux-x86_64.tar.gz

#galera相关参数: (Similar to two node profiles)

Wsrep_on=on
Binlog_format=row
Default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=10.2.2.41
wsrep_provider=/usr/local/mariadb-galera-10.0.22-linux-x86_64/lib/libgalera_smm.so
wsrep_cluster_name= "Cluster_stage2"
wsrep_cluster_address= "gcomm://10.2.2.41,10.2.2.42"
wsrep_slave_threads=64
wsrep_certify_nonpk=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_lock_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
Wsrep_causal_reads=1
wsrep_notify_cmd=
Wsrep_sst_method=xtrabackup-v2
Wsrep_sst_auth=sysn-user:sysnc-password

Wsrep_provider_options= "base_port=7654"

The first node starts:

/usr/local/mariadb-galera-10.0.22-linux-x86_64/bin/mysqld_safe--defaults-file=/etc/mysql/my3317.cnf \

--basedir=/usr/local/mariadb-galera-10.0.22-linux-x86_64 \

--ledir=/usr/local/mariadb-galera-10.0.22-linux-x86_64/bin \

--wsrep_cluster_address=gcomm://>/dev/null &

Start the node authorization synchronization account:

Other node launches:

/usr/local/mariadb-galera-10.0.22-linux-x86_64/bin/mysqld_safe--defaults-file=/etc/mysql/my3317.cnf \

--basedir=/usr/local/mariadb-galera-10.0.22-linux-x86_64 \

--ledir=/usr/local/mariadb-galera-10.0.22-linux-x86_64/bin/&

Note

Some pits installed on the ubuntu14.x:

1. Some packages that may be required:

Apt-get Install Socat PV

2, SSL related error: (on the CentOS link way a little different)

Ln-sv/usr/lib/x86_64-linux-gnu/libcrypto.so/usr/lib/x86_64-linux-gnu/libcrypto.so.6
Ln-sv/usr/lib/x86_64-linux-gnu/libssl.so/usr/lib/x86_64-linux-gnu/libssl.so.6

3, MySQL uses the non-default port 3306: (not all use of non-default port many will encounter this situation)

Encountered a problem starting when using Xtrabackup mode cannot pass,

Workaround: Sync with sync sync first, then kill MySQL and change to Xtrbakcup mode to start. The test solution is feasible. (for unspecified reasons)

MariaDB galera Cluster Dual-node deployment