<\/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
root@DA:\/home\/shiv\/sakila# vi \/etc\/mysql\/my.cnf\r\n<\/pre>\n!includedir \/etc\/mysql\/conf.d\/\r\n\r\n!includedir \/etc\/mysql\/mysql.conf.d\/\r\n\r\n[mysqld]\r\n\r\nserver-id = 900\r\n\r\nlog-bin = mysql-bin\r\n\r\nbind-address = 192.168.56.13\r\n\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