Percona XtraDB Cluster提供的特性有：
1.同步復制，事務要么在所有節點提交或不提交。
2.多主復制，可以在任意節點進行寫操作。
3.在從服務器上并行應用事件，真正意義上的并行復制。
4.節點自動配置。
5.數據一致性，不再是異步復制。
開始搭建：
?
三臺服務器：先設置hosts 10.0.0.231 node1 10.0.0.232 node2 10.0.0.233 node3
?
1：下載安裝文件
? ?官網：https://www.percona.com
? ?下載地址：https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/Percona-XtraDB-Cluster-5.7.18-29.20/binary/tarball/Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl100.tar.gz
2：解壓到指定目錄
tar -zxvf Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101.tar.gz -C /usr/localln -s Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101 mysql5.7
3：創建目錄
mkdir -p /usr/local/mysql5.7/data mkdir -p /usr/local/mysql5.7/tmp
4:創建用戶
useradd -d /usr/local/mysql5.7 -m mysql chown -R /usr/local/mysql5.7 chmod 600 /usr/local/mysql5.7
?
5:配制/etc/my.cnf
note1:
[mysqld]server_id=231 datadir=/usr/local/mysql5.7/data user=mysql basedir=/usr/local/mysql5.7default_storage_engine=Innodbinnodb_buffer_pool_size=1610612736 innodb_log_file_size=104857600wsrep_provider=/usr/local/mysql5.7/lib/libgalera_smm.so wsrep_cluster_address=gcomm://10.0.0.231,10.0.0.232,10.0.0.233 wsrep_node_name=node1 wsrep_node_address=10.0.0.231 wsrep_cluster_name=pxc_sampson wsrep_sst_auth=sst:sampson wsrep_sst_method=rsync wsrep_slave_threads=2 pxc_strict_mode=ENFORCING innodb_autoinc_lock_mode=2 wsrep_provider_options="debug=1;gcache.size=1G"
note2:
[mysqld] server_id=232 datadir=/usr/local/mysql5.7/data user=mysql basedir=/usr/local/mysql5.7default_storage_engine=Innodbinnodb_buffer_pool_size=1610612736 innodb_log_file_size=104857600wsrep_provider=/usr/local/mysql5.7/lib/libgalera_smm.so wsrep_cluster_address=gcomm://10.0.0.231,10.0.0.232,10.0.0.233 wsrep_node_name=node2 wsrep_node_address=10.0.0.232 wsrep_cluster_name=pxc_sampson wsrep_sst_auth=sst:sampson wsrep_sst_method=rsync wsrep_slave_threads=2 pxc_strict_mode=ENFORCING innodb_autoinc_lock_mode=2 wsrep_provider_options="debug=1;gcache.size=1G"
note3:
[mysqld]server_id=233 datadir=/usr/local/mysql5.7/data user=mysql basedir=/usr/local/mysql5.7 default_storage_engine=Innodbinnodb_buffer_pool_size=1610612736 innodb_log_file_size=104857600wsrep_provider=/usr/local/mysql5.7/lib/libgalera_smm.so wsrep_cluster_address=gcomm://10.0.0.231,10.0.0.232,10.0.0.233 wsrep_node_name=node3 wsrep_node_address=10.0.0.233 wsrep_cluster_name=pxc_sampson wsrep_sst_auth=sst:sampson wsrep_sst_method=rsync wsrep_slave_threads=2 pxc_strict_mode=ENFORCING innodb_autoinc_lock_mode=2 wsrep_provider_options="debug=1;gcache.size=1G"
?6:初始化mysql
? note1,note2,note3
/usr/local/mysql5.7/bin/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql5.7/ --datadir=/usr/local/mysql5.7/data/
7：啟動第一個節點
? node1:
/usr/local/mysql5.7/bin/mysqld_safe --ledir=/usr/local/mysql5.7/bin --wsrep-new-cluster &
完成后Ctrl+C
8：修改mysql密碼
查看初使密碼cat /root/.mysql_secret 假設初始密碼為abcde修改初始密碼先進入mysql命令行：mysql -u root -p輸入初始密碼abcde修改初始密碼：SET PASSWORD = PASSWORD('123456');
9：啟動第二，三個節點
? node2,node3
/usr/local/mysql5.7/bin/mysqld_safe --ledir=/usr/local/mysql5.7/bin &
10:查看
?登錄mysql
mysql>show global status like 'wsrep_cluster_size';mysql>show global status like 'wsrep%';
11:設置開機啟動
cp /usr/local/mysql5.7/support-files/mysql.server /etc/init.d/mysql …復制啟動文件 chmod 755 /etc/init.d/mysql …增加執行權限 chkconfig --add mysql …加入自動啟動項chkconfig --level 2345 mysql on …設置MySQL 在345 等級自動啟動
12：環境變量
export PATH=/usr/local/mysq5.7l/bin:$PATH ?
)
