Replication of MySQL Server
For Master to Slave Replication do following steps: 1. vi /etc/my.cnf and add following linesFor ServerA server-id = 5 replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 1 relay-log = /var/lib/mysql/serverA-relay-bin relay-log-index = /var/lib/mysql/serverA-relay-bin.index log-error = /var/log/mysql/mysql.err master-info-file = /var/lib/mysql/mysql-master.info relay-log-info-file = /var/lib/mysql/serverA-relay-log.info log-bin = /var/lib/mysql/ServerA-bin For ServerB server-id = 6 replicate-same-server-id = 0 auto-increment-increment … Read more