Skip to content

Instantly share code, notes, and snippets.

@azanium

azanium/master.cnf

Created September 5, 2019 01:13
Show Gist options
  • Save azanium/aa2b78767b53292008db2027364d875e to your computer and use it in GitHub Desktop.
Save azanium/aa2b78767b53292008db2027364d875e to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Replication Config
Raw
master.cnf
[mysqld]
bind-address = 192.168.56.9
server_id = 1
log_bin = /var/log/mysql/mysql-bin.log
log_bin_index = /var/log/mysql/mysql-bin.log.index
binlog_ignore_db = "mysql"
Raw
slave.cnf
[mysqld]
bind-address = 192.168.56.10
server_id = 2
log_bin = /var/log/mysql/mysql-bin.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment