[root@pxc01 pxc-5.6.15]# rpm -qa|grep -i percona Percona-XtraDB-Cluster-client-56-5.6.15-25.4.731.rhel6.x86_64 percona-xtrabackup-debuginfo-2.1.7-721.rhel6.x86_64 Percona-XtraDB-Cluster-galera-3-debuginfo-3.3-1.207.rhel6.x86_64 percona-xtrabackup-2.1.7-721.rhel6.x86_64 Percona-XtraDB-Cluster-devel-56-5.6.15-25.4.731.rhel6.x86_64 Percona-XtraDB-Cluster-galera-3-3.3-1.207.rhel6.x86_64 Percona-XtraDB-Cluster-server-56-5.6.15-25.4.731.rhel6.x86_64 Percona-XtraDB-Cluster-56-debuginfo-5.6.15-25.4.731.rhel6.x86_64 Percona-XtraDB-Cluster-56-5.6.15-25.4.731.rhel6.x86_64 Percona-XtraDB-Cluster-shared-56-5.6.15-25.4.731.rhel6.x86_64 Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64
[root@pxc01 pxc-5.6.15]# cat /etc/my.cnf [client] port = 3306 socket = /var/lib/mysql/mysqld.sock user = root password = root
[mysqld] datadir = /var/lib/mysql port = 3306 socket = /var/lib/mysql/mysqld.sock pid-file = /var/lib/mysql/mysqld.pid skip-external-locking key_buffer_size = 32M max_allowed_packet = 128M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 0 query_cache_type = 0 query_cache_min_res_unit= 1536 skip-slave-start expire_logs_days = 15
slow-query-log = 1 long_query_time = 2 #log-bin=mysql-bin server-id = 10 log-slave-updates = 1 binlog_format = ROW
innodb_log_buffer_size = 8M innodb_buffer_pool_size = 512M innodb_log_file_size = 256M innodb-file-per-table innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2
log-error = /var/lib/mysql/mysqld.log slow_query_log_file = /var/lib/mysql/mysqld-slow.log
skip-name-resolve
wsrep_provider = /usr/lib64/libgalera_smm.so wsrep_slave_threads = 2 wsrep_cluster_name = pxc wsrep_sst_method = xtrabackup wsrep_node_name = pxc01 wsrep_node_address = 192.168.56.42 wsrep_cluster_address = gcomm://
[mysqldump] quick max_allowed_packet = 128M
[mysql] no-auto-rehash
[root@pxc01 pxc-5.6.15]# rpm -qa|grep -i percona XtraDB- Cluster- client- 56-5.6. 15-25.4. 731.rhel6. x86_64 xtrabackup- debuginfo- 2.1.7-721. rhel6.x86_ 64 XtraDB- Cluster- galera- 3-debuginfo- 3.3-1.207. rhel6.x86_ 64 xtrabackup- 2.1.7-721. rhel6.x86_ 64 XtraDB- Cluster- devel-56- 5.6.15- 25.4.731. rhel6.x86_ 64 XtraDB- Cluster- galera- 3-3.3-1. 207.rhel6. x86_64 XtraDB- Cluster- server- 56-5.6. 15-25.4. 731.rhel6. x86_64 XtraDB- Cluster- 56-debuginfo- 5.6.15- 25.4.731. rhel6.x86_ 64 XtraDB- Cluster- 56-5.6. 15-25.4. 731.rhel6. x86_64 XtraDB- Cluster- shared- 56-5.6. 15-25.4. 731.rhel6. x86_64 Server- shared- compat- 5.5.35- rel33.0. 611.rhel6. x86_64
Percona-
percona-
Percona-
percona-
Percona-
Percona-
Percona-
Percona-
Percona-
Percona-
Percona-
[root@pxc01 pxc-5.6.15]# cat /etc/my.cnf mysql/mysqld. sock
[client]
port = 3306
socket = /var/lib/
user = root
password = root
[mysqld] mysql/mysqld. sock mysql/mysqld. pid locking buffer_ size = 8M sort_buffer_ size = 64M min_res_ unit= 1536
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/
pid-file = /var/lib/
skip-external-
key_buffer_size = 32M
max_allowed_packet = 128M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_
myisam_
thread_cache_size = 8
query_cache_size = 0
query_cache_type = 0
query_cache_
skip-slave-start
expire_logs_days = 15
slow-query-log = 1
long_query_time = 2
#log-bin=mysql-bin
server-id = 10
log-slave-updates = 1
binlog_format = ROW
innodb_ log_buffer_ size = 8M buffer_ pool_size = 512M log_file_ size = 256M file-per- table locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2
innodb_
innodb_
innodb-
innodb_
innodb_
log-error = /var/lib/ mysql/mysqld. log mysql/mysqld- slow.log
slow_query_log_file = /var/lib/
skip-name-resolve
wsrep_provider = /usr/lib64/ libgalera_ smm.so address = gcomm://
wsrep_slave_threads = 2
wsrep_cluster_name = pxc
wsrep_sst_method = xtrabackup
wsrep_node_name = pxc01
wsrep_node_address = 192.168.56.42
wsrep_cluster_
[mysqldump]
quick
max_allowed_packet = 128M
[mysql]
no-auto-rehash