MySQL PXC集群部署

joozh

vim /etc/my.cnf

[client]

　　port=3306
　　socket = /tmp/mysql.sock

[mysqld]

　　server-id=1
　　datadir=/data/database/mysql
　　socket=/tmp/mysql.sock
　　log-error=/var/run/mysqld/mysqld.log
　　pid-file=/var/run/mysqld/mysqld.pid
　　user=mysql
　　# General
　　back_log=2000
　　connect_timeout=15
　　skip_name_resolve=ON
　　max_connections=5000
　　table_definition_cache=2000
　　table_open_cache=10000
　　metadata_locks_hash_instances=256
　　ssl=0
　　core_file
　　# Innodb
　　innodb_buffer_pool_size = 10240M
　　innodb_buffer_pool_instances=8
　　innodb_log_file_size = 1024M
　　innodb_log_buffer_size = 16M
　　innodb_lock_wait_timeout = 20
　　innodb_autoinc_lock_mode=2
　　innodb_read_io_threads = 5
　　innodb_write_io_threads = 5
　　innodb_thread_concurrency = 8
　　innodb_doublewrite=1
　　innodb_flush_log_at_trx_commit = 2
　　innodb_flush_method = 'O_DIRECT'
　　innodb-page-cleaners=8
　　innodb_purge_threads=4
　　innodb_lru_scan_depth=2048
　　innodb_io_capacity=8000
　　innodb_io_capacity_max=16000
　　innodb_adaptive_hash_index=OFF
　　innodb-change-buffering=none
　　innodb_flush_neighbors=0
　　innodb_max_dirty_pages_pct = 90
　　innodb_max_dirty_pages_pct_lwm = 10
　　# Binlog
　　relay-log=relay-1
　　binlog_format=ROW
　　enforce-gtid-consistency
　　gtid-mode=on
　　master-info-repository=TABLE
　　relay-log-info-repository=TABLE
　　binlog-checksum=NONE
　　log-bin
　　log_slave_updates
　　expire_logs_days=3
　　sync_binlog=1
　　# Monitoring
　　innodb_monitor_enable='%'
　　performance_schema=ON
　　performance_schema_instrument='%synch%=on'
　　# Galera
　　symbolic-links=0
　　explicit_defaults_for_timestamp=true
　　wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
　　wsrep_cluster_address=gcomm://30.0.0.196,30.0.0.198,30.0.0.199
　　default_storage_engine=InnoDB
　　wsrep_slave_threads= 20
　　wsrep_log_conflicts
　　wsrep_cluster_name=pxc-cluster
　　wsrep_node_name=pxc3
　　wsrep_node_address=30.0.0.196
　　pxc_strict_mode=ENFORCING
　　wsrep_sst_method=xtrabackup-v2
　　wsrep_sst_auth="sstuser:s3cret"