summaryrefslogtreecommitdiffstats
path: root/mysqld/my_percona_node02.cnf
blob: 7c88cfa319e281bcf0614320249dd927718f34e2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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