diff options
author | Georg | 2021-07-21 13:21:08 +0200 |
---|---|---|
committer | Georg | 2021-07-21 13:21:08 +0200 |
commit | d66638c46e03e13b43bf44667e0c9dd50357ef60 (patch) | |
tree | afbc51c721faa4bae66d9ef1fa4ab0cea444e518 /mysqld/my_percona_node02.cnf | |
parent | eb04685ad152984c5903c94d5f33f5296cf6e277 (diff) | |
download | system-d66638c46e03e13b43bf44667e0c9dd50357ef60.tar.gz system-d66638c46e03e13b43bf44667e0c9dd50357ef60.tar.bz2 system-d66638c46e03e13b43bf44667e0c9dd50357ef60.zip |
Initial MySQLd Run
Signed-off-by: Georg <georg@lysergic.dev>
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 |