Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- symbolic-links=0
- bind-address=Master 1
- port=3306
- query_cache_size=16M
- query_cache_limit=4M
- tmp_table_size=64M
- max_heap_table_size=64M
- key_buffer_size=32M
- table_open_cache=32
- innodb_file_per_table=1
- max_connections=1000
- server_id=2
- binlog_format='MIXED'
- log-bin=/var/log/mariadb/mariadb-bin.log
- max_allowed_packet=1000M
- general_log=1
- auto_increment_increment=2
- auto_increment_offset=2
- [mysqld_safe]
- log-error=/var/log/mariadb/mariadb.log
- pid-file=/var/run/mariadb/mariadb.pid
- !includedir /etc/my.cnf.d
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- bind-address=Master2
- port=3306
- query_cache_size=16M
- query_cache_limit=4M
- tmp_table_size=64M
- max_heap_table_size=64M
- key_buffer_size=32M
- table_open_cache=32
- innodb_file_per_table=1
- #innodb_force_recovery=5
- max_connections=1000
- server_id=1
- binlog_format='MIXED'
- log-bin=/var/log/mariadb/mariadb-bin.log
- max_allowed_packet=1000M
- general_log=1
- auto_increment_increment=2
- auto_increment_offset=1
- [mysqld_safe]
- log-error=/var/log/mariadb/mariadb.log
- pid-file=/var/run/mariadb/mariadb.pid
- !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement