diff options
| author | Georg | 2021-07-21 13:21:08 +0200 |
|---|---|---|
| committer | Georg | 2021-07-21 13:21:08 +0200 |
| commit | 475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5 (patch) | |
| tree | afbc51c721faa4bae66d9ef1fa4ab0cea444e518 | |
| parent | 570ed2aed2c1e5465767019b1de52fbd8028fad4 (diff) | |
| download | system-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.tar.gz system-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.tar.bz2 system-475dd43e32720a3eb2cfac1c28dc54c20f3c0dd5.zip | |
Initial MySQLd Run
Signed-off-by: Georg <georg@lysergic.dev>
| -rw-r--r-- | mysqld/my_oracle_standalone.cnf | 7 | ||||
| -rw-r--r-- | mysqld/my_percona_node01.cnf | 18 | ||||
| -rw-r--r-- | mysqld/my_percona_node02.cnf | 30 | ||||
| -rw-r--r-- | mysqld/my_percona_node03.cnf | 17 |
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 |