summaryrefslogtreecommitdiffstats
path: root/mysqld
diff options
context:
space:
mode:
authorGeorg2021-07-21 13:21:08 +0200
committerGeorg2021-07-21 13:21:08 +0200
commit475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5 (patch)
treeafbc51c721faa4bae66d9ef1fa4ab0cea444e518 /mysqld
parent570ed2aed2c1e5465767019b1de52fbd8028fad4 (diff)
downloadsystem-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.tar.gz
system-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.tar.bz2
system-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.zip
Initial MySQLd Run
Signed-off-by: Georg <georg@lysergic.dev>
Diffstat (limited to 'mysqld')
-rw-r--r--mysqld/my_oracle_standalone.cnf7
-rw-r--r--mysqld/my_percona_node01.cnf18
-rw-r--r--mysqld/my_percona_node02.cnf30
-rw-r--r--mysqld/my_percona_node03.cnf17
4 files changed, 72 insertions, 0 deletions
diff --git a/mysqld/my_oracle_standalone.cnf b/mysqld/my_oracle_standalone.cnf
new file mode 100644
index 0000000..a65d2cd
--- /dev/null
+++ b/mysqld/my_oracle_standalone.cnf
@@ -0,0 +1,7 @@
+[client]
+socket=/run/mysql-standalone/mysql.sock
+port=3407
+[mysqld]
+log-error=/var/log/mysql-standalone/mysqld.log
+port=3407
+bind-address = 127.0.0.2,192.168.0.110
diff --git a/mysqld/my_percona_node01.cnf b/mysqld/my_percona_node01.cnf
new file mode 100644
index 0000000..711edca
--- /dev/null
+++ b/mysqld/my_percona_node01.cnf
@@ -0,0 +1,18 @@
+[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://
+wsrep_cluster_address=gcomm://172.16.100.1,172.16.100.2,172.16.100.3
+wsrep_node_name=theia
+wsrep_node_address=172.16.100.1
+pxc_strict_mode=ENFORCING
+binlog_format=ROW
+wsrep_slave_threads=4
+wsrep_log_conflicts
+innodb_autoinc_lock_mode=2
+wsrep_sst_method=xtrabackup-v2
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
diff --git a/mysqld/my_percona_node03.cnf b/mysqld/my_percona_node03.cnf
new file mode 100644
index 0000000..d4c4e5f
--- /dev/null
+++ b/mysqld/my_percona_node03.cnf
@@ -0,0 +1,17 @@
+[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=selene
+wsrep_node_address=172.16.100.3
+pxc_strict_mode=ENFORCING
+binlog_format=ROW
+wsrep_slave_threads=4
+wsrep_log_conflicts
+innodb_autoinc_lock_mode=2
+wsrep_sst_method=xtrabackup-v2