Disable MySQL slave Configuration and Reset Mysql Slave
Wednesday, September 24, 2014
How do I completely disable MySQL replication ?
Reset Mysql Slave :-
following are steps to reset mysql slave :-
1. >login mysql
2. mysql>check slave status \G;
3. mysql> STOP SLAVE;
4. mysql> RESET SLAVE;
(Use RESET SLAVE ALL; for MySQL 5.5.16 and later)
5. mysql>exit
6. edit my.cnf file
vi /etc/my.cnf
7. comment below in my.cnf
#relay-log=mysqld-relay-bin
#replicate-do-db=
#replicate-do-db=
#server-id=2
Reset Mysql Slave :-
following are steps to reset mysql slave :-
1. >login mysql
2. mysql>check slave status \G;
3. mysql> STOP SLAVE;
4. mysql> RESET SLAVE;
(Use RESET SLAVE ALL; for MySQL 5.5.16 and later)
5. mysql>exit
6. edit my.cnf file
vi /etc/my.cnf
7. comment below in my.cnf
#relay-log=mysqld-relay-bin
#replicate-do-db=
#replicate-do-db=
#server-id=2
8. restart mysql
/etc/init.d/mysqld restart
0 comments:
Post a Comment