|
GRANT ALL PRIVILEGES ON *.* TO 'wsrep'@'%' IDENTIFIED BY 'wsrep' ;flush privileges;
---3.2 安装galera
--3.2.1 安装galera所依赖的软件
yum install boost-devel
yum install check-devel
wget http://cznic.dl.sourceforge.net/project/scons/scons/2.3.4/scons-2.3.4.tar.gz
tar zxvf scons-2.3.4.tar.gz
cd scons-2.3.4
python setup.py install
--3.2.2 安装galera
#rpm -ql | grep galera
#cd /soft
#rpm -ivh galera-25.3.5-1.rhel6.x86_64.rpm
# ls /usr/lib64/galera
libgalera_smm.so
---3.2.3
#tar xf socat-2.0.0-b7.tar.gz
#cd socat
#./configure
#make & make install
---3.2.4 修改mysql的配置文件
mkdir /etc/my.cnf.d
cd /soft/mariadb-10.0.19/support-files
cp wsrep.cnf /etc/my.cnf.d/
#vi /etc/my.cnf.d/wsrep.cnf
#notde01
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://" #修改
wsrep_node_address='192.168.50.10,192.168.50.20,192.168.50.30' #修改
wsrep_node_name='db01' #修改
wsrep_slave_threads=4
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=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump #可以修改#rsync,xtrabackup,mysqldump
wsrep_sst_auth=root:pass01 #修改
#notde02
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://192.168.50.10,192.168.50.20,192.168.50.30" #修改
wsrep_node_address='192.168.50.20' #修改
wsrep_node_name='db02' #修改
wsrep_slave_threads=4
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=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump #可以修改#rsync,xtrabackup,mysqldump,xtrabackup-v2
wsrep_sst_auth=root:pass01 #修改
#notde03
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://192.168.50.10,192.168.50.20,192.168.50.30" #修改
wsrep_node_address='192.168.50.30' #修改
wsrep_node_name='db03' #修改
wsrep_slave_threads=4
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=0
wsr |