Database Replication Master Slave
This post is about how to perform to Database Replication Slave to Master. I have used the Green Font to represent Master Server and Red Font to represent Slave Server. Step 1:CHANGING MySQL CONFIGURATION We need to add some extra configuration properties in the my.ini/my.cnf file. This step is must to perform replication.The following sub steps will describe in detail. Open my.ini file for windows or my.cnf file for Linux Search for [mysqld] Add the following properties under [mysqld] section server-id=1 log-bin=mysql-bin save the my.ini file and Restart the mysql services To check the result execute the following command in mysql console show binary logs; If it shows logs, Binary logging has been initiated and we can configure mirroring Perform the same steps on slave database. Step 2: CRATE USER AND GRANT RELICATION AND PREVILEGES Create user create user 'replication'@'%' identified by 'PASSWORD'; Grant r...