<\/span><\/h4>\nTo configure a master to use binary log file based replication, Configure binary logging first and include a unique server ID. Once done these steps restart MySQL server. Binary logging is enabled by default (log_bin variable is set to ON). It’s always a best practice to create binary log files with a non-default base name to avoid confusion as your database infrastructure grows. To configure binary logging, first shutdown the MySQL and edit my.cnf or my.ini<\/p>\n
[mysqld]\r\nserver-id=1\r\nbind-address=192.168.56.11\r\nlog-bin=mysql-bin\r\nbinlog-do-db=sakila\r\n<\/pre>\nTo guarantee the ultimate transaction durability and consistency in the replication setup please confirm innodb_flush_log_at_trx_commit=1 and sync_binlog=1 in the master my.cnf file. You must also confirm skip-networking option is not enabled on your replication master.<\/p>\n