From d66638c46e03e13b43bf44667e0c9dd50357ef60 Mon Sep 17 00:00:00 2001 From: Georg Date: Wed, 21 Jul 2021 13:21:08 +0200 Subject: Initial MySQLd Run Signed-off-by: Georg --- mysqld/my_percona_node02.cnf | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 mysqld/my_percona_node02.cnf (limited to 'mysqld/my_percona_node02.cnf') 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 -- cgit v1.2.3