Tuesday, January 22, 2013

5 STEPS TO DO BEFORE MYSQL INSTALLATION FOR SLAVE SERVER

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