iptables --append INPUT --protocol tcp \ --source 192.168.126.129 --jump ACCEPT iptables --apend INPUT --protocol tcp \ --source 192.168.126.130 --jump ACCEPT iptables --append INPUT --protocol tcp \ --source 192.168.126.131 --jump ACCEPT iptables-save> /etc/sysconfig/iptables-config
grant usage on *.* to sst@'%' identified by 'ssTT-488';flush privileges;修改后
[mysqld]binlog_format = ROW#bind-address = 192.168.126.129default_storage_engine = innodbinnodb_autoinc_lock_mode = 2innodb_flush_log_at_trx_commit = 0innodb_buffer_pool_size = 122Mwsrep_provider=/usr/lib64/galera/libgalera_smm.sowsrep_provider_options ="gcache.size = 300M; gcache.page_size = 300M"wsrep_cluster_name ="MyCluster"wsrep_cluster_address="gcomm://192.168.126.129"wsrep_sst_method = rsyncwsrep_node_name = Node11wsrep_node_address ="192.168.126.129"wsrep_sst_auth=sst:ssTT-488 #节点N的数据库账户和密码--创建账号密码wsrep_on=ON
[mysql_safe]log-error = /var/log/mysqld.logpid-file = /var/run/mysqld/mysqld.pidswapon --summaryfallocate -l 512M /swapfiledd if=/dev/zero of=/swapfile bs=1M count=512chmod 600 /swapfilels -a / | grep swapfilemkswap /swapfileswapon /swapfilevi /etc/fstab/swapfile none swap defaults 0 0 swapon --summarygalera_new_clustershow variables like 'character%';set character_set_server = utf8;set character_set_database = utf8;cp /usr/share/mysql/wsrep.cnf /etc/my.cnf.d/vi /etc/my.cnf.d/wsrep.cnfgarbd -a gcomm://192.168.126.129 -g MyCluster -djournalctl -xe
转载于:https://www.cnblogs.com/leolzi/p/11103774.html
