Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- datadir=/var/lib/mysql
- user=mysql
- log_error=error.log
- # Path to Galera library
- wsrep_provider=/usr/lib64/libgalera_smm.so
- innodb_doublewrite=0
- # Cluster connection URL contains the IPs of node#1, node#2 and node#3
- wsrep_cluster_address=gcomm://192.168.1.202,192.168.1.203,192.168.1.204
- # In order for Galera to work correctly binlog format should be ROW
- binlog_format=ROW
- # MyISAM storage engine has only experimental support
- default_storage_engine=InnoDB
- # This is a recommended tuning variable for performance
- innodb_locks_unsafe_for_binlog=1
- innodb_buffer_pool_size=3G
- # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
- innodb_autoinc_lock_mode=2
- # Node #1 address
- wsrep_node_address=192.168.1.202
- # SST method
- wsrep_sst_method=rsync
- # Cluster name
- wsrep_cluster_name=my_centos_cluster
- # Authentication for SST method
- wsrep_sst_auth="sstuser:s3cret"
- slow_query_log=1
- slow_query_log_file=/var/lib/mysql/slow.log
- long_query_time=10
- #log_slow_rate_limit = 1000
- log_slow_verbosity=query_plan
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement