steps
step 1
on master
must enable binary logging
configure a unique server ID.
this can be done by setting follwing parameters in my.cnf file
[mysqld]
server-id=2
log-bin=mysql-bin
step 2
take backup of the databases or tables of which you want to set replication
step 3
create user
CREATE USER 'repl'@'%' IDENTIFIED BY 'slavepass';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
restart mysql
serice mysql restart
note the follwing
mysql>FLUSH TABLES WITH READ LOCK;
mysql>SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 333 | | |
+------------------+----------+--------------+------------------+
step4
on slave
[mysqld]
server-id=2
export the backup which you have taken on master
restart the mysql services
on mysql prompt run following command
mysql>CHANGE MASTER TO
MASTER_HOST='192.168.163.130', ##ip of master
MASTER_USER='repl',
MASTER_PASSWORD='slavepass',
MASTER_LOG_FILE='mysql-bin.000007',
MASTER_LOG_POS=333;
mysql>start slave
its done..:)
if u want to replicate a spesific table add following in the server my.cnf
replicate-do-table=mani.abc
No comments:
Post a Comment