Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Template my.cnf for PXC
- # Edit to your requirements.
- [client]
- socket=/var/lib/mysql/mysql.sock
- [mysqld]
- server-id=1
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- log-bin
- log_slave_updates
- expire_logs_days=7
- wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
- wsrep_cluster_name=pxc-cluster
- wsrep_cluster_address=gcomm://192.168.3.31,192.168.3.32,192.168.3.33
- wsrep_node_name=pxc3
- wsrep_node_address=192.168.3.33
- wsrep_sst_method=xtrabackup-v2
- wsrep_sst_auth=sstuser:passw0rd
- pxc_strict_mode=ENFORCING
- binlog_format=ROW
- default_storage_engine=InnoDB
- innodb_autoinc_lock_mode=2
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement