1)Take a backup of Master server databases.
2)Enable the binlog in master server.
3)Give the different base and data directory location in slave(not same as Master).
4)Before install mysql in slave edit the slave my.cnf file to change the server id,port number and socket number.
Note: Default port number for mysql is 3306.
change it as by your wish in slave.
Eg: port = 3307
socket = /tmp/mysql_3307.sock
Server-id=2
5)Next install MySQL in slave.
No comments:
Post a Comment