diff options
Diffstat (limited to 'mysqld/my_percona_node02.cnf')
| -rw-r--r-- | mysqld/my_percona_node02.cnf | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysqld/my_percona_node02.cnf b/mysqld/my_percona_node02.cnf new file mode 100644 index 0000000..7c88cfa --- /dev/null +++ b/mysqld/my_percona_node02.cnf @@ -0,0 +1,30 @@ +[client] +socket=/run/mysql/mysql.sock +[mysqld] +log-error=/var/log/mysql/mysqld.log +binlog_expire_logs_seconds=604800 +pxc-encrypt-cluster-traffic=OFF +wsrep_provider=/opt/mysql/lib/libgalera_smm.so +wsrep_cluster_name=pxc-cluster +wsrep_cluster_address=gcomm://172.16.100.1,172.16.100.2,172.16.100.3 +wsrep_node_name=orpheus +wsrep_node_address=172.16.100.2 +pxc_strict_mode=ENFORCING +binlog_format=ROW +wsrep_slave_threads=4 +wsrep_log_conflicts +innodb_autoinc_lock_mode=2 +wsrep_sst_method=xtrabackup-v2 + +[xtrabackup] +#target_dir = /opt/xtrabackup-storage/ +compress = lz4 +galera-info +host = localhost +parallel = 2 +password = $PASS +port = 3306 +rsync +tmpdir = /tmp/xtrabackup/ +user = backup +no-backup-locks |