Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created March 18, 2013 10:58
Show Gist options
  • Save yoku0825/5186427 to your computer and use it in GitHub Desktop.
Save yoku0825/5186427 to your computer and use it in GitHub Desktop.
[mysqld_multi]
user = mysqld_multi
password = ***
log = /home/yoku0825/mysqld_multi.log
[mysqld]
loose-wsrep_provider = /home/yoku0825/xc/lib/libgalera_smm.so
#loose-wsrep_cluster_address = gcomm://192.168.xxx.xxx
loose-wsrep_cluster_address = gcomm://
loose-wsrep_slave_threads = 2
loose-wsrep_sst_method = rsync
loose-wsrep_cluster_name = xtra
loose-wsrep_node_name = mysqlHA04
loose-innodb-autoinc-lock-mode = 2
log-error = error.log
log-warnings = 2
log-bin = bin
sync-binlog = 1
relay-log = relay
loose-binlog-format = mixed
loose-skip-general-log
loose-general-log-file = general.log
loose-slow-query-log
loose-slow-query-log-file = slow.log
long-query-time = 1
loose-log-output = FILE
server-id = 4
character-set-server = utf8
max_connect_errors = 999999999
socket = /var/lib/mysql/mysql.sock
port = 3306
skip-slave-start
loose-rpl_semi_sync_master_enabled = 1
innodb-buffer-pool-size = 1G
innodb-log-file-size = 128M
innodb-file-per-table = 1
[client]
user = root
socket = /var/lib/mysql/mysql.sock
port = 3306
[mysql]
no-auto-rehash
[mysqldump]
single-transaction
triggers
routines
events
[mysqld1]
basedir = /home/yoku0825/5.5
mysqladmin = /home/yoku0825/5.5/bin/mysqladmin
mysqld = /home/yoku0825/5.5/bin/mysqld_safe
pid-file = /home/yoku0825/5.5/data/mysql.pid
datadir = /home/yoku0825/5.5/data
[mysqld2]
basedir = /home/yoku0825/percona
mysqladmin = /home/yoku0825/percona/bin/mysqladmin
mysqld = /home/yoku0825/percona/bin/mysqld_safe
pid-file = /home/yoku0825/percona/data/mysql.pid
datadir = /home/yoku0825/percona/data
[mysqld3]
basedir = /home/yoku0825/maria
mysqladmin = /home/yoku0825/maria/bin/mysqladmin
mysqld = /home/yoku0825/maria/bin/mysqld_safe
pid-file = /home/yoku0825/maria/data/mysql.pid
datadir = /home/yoku0825/maria/data
[mysqld4]
basedir = /home/yoku0825/xc
mysqld = /home/yoku0825/xc/bin/mysqld_safe
mysqladmin = /home/yoku0825/xc/bin/mysqladmin
pid-file = /home/yoku0825/xc/data/mysql.pid
datadir = /home/yoku0825/xc/data
binlog-format = ROW
[mysqld5]
basedir = /home/yoku0825/5.6
mysqld = /home/yoku0825/5.6/bin/mysqld_safe
mysqladmin = /home/yoku0825/5.6/bin/mysqladmin
pid-file = /home/yoku0825/5.6/data/mysql.pid
datadir = /home/yoku0825/5.6/data
[mysqld6]
basedir = /home/yoku0825/galera
mysqld = /home/yoku0825/galera/bin/mysqld_safe
mysqladmin = /home/yoku0825/galera/bin/mysqladmin
pid-file = /home/yoku0825/galera/data/mysql.pid
datadir = /home/yoku0825/galera/data
binlog-format = ROW
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment