Preparing MySQL

The next step is to prepare your MySQL server by enabling the binary log. To do this, add the following parameters to the [mysqld] section of your MySQL server’s configuration file (i.e., my.cnf or my.ini, depending on your system):

server-id = 888888
log_bin = /file_path/mysql-bin.log  
expire_logs_days = 30
max_binlog_size = 1G
binlog_format = ROW
net_read_timeout = 3600
net_write_timeout = 3600
wait_timeout = 86400
replicate-wild-do-table = yourdb.%
log-slave-updates = TRUE

The value of log_bin should be the path and name of the binary log file. For the server-id, provide a unique number to identify it among databases that are replicated. It’s necessary to enable log-slave-updates if the database server is a slave of another database.

Depending on your MySQL Server version, you may also need to add the following parameters.

log-bin-use-v1-row-events = TRUE    
# MySQL Server 5.1.56-ndb-7-0-27, 5.1.56-ndb-7.1.16 or above
show_compatibility_56 = ON
#MySQL Server 5.7.1 or above

When you’re finished editing the MySQL configuration file, restart the MySQL daemon for the changes to take effect.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk