Master replicating "Grant replication" statement to slave..?
Hi ,
I m using mysql 5.6.16 version with gtid based replication. In master i have created an account for slave as below
GRANT REPLICATION SLAVE ON *.* TO 'johny'@'192.168.1.101' IDENTIFIED BY 'johny';
and at slave server i have executed change master as below
change master to master_host='192.168.1.100',master_port=3306,master_user='johny',master_password='johny',master_autoo_position=1;
My doubt is when i start slave it read all event from master including "GRANT REPLICATION......." which i had executed at master. And slave executed same query at his server. means slave also has executed below statement
GRANT REPLICATION SLAVE ON *.* TO 'johny'@'192.168.1.101' IDENTIFIED BY 'johny';
will execution of this statement affect slave?and there is no use of replicating this statement to slave as it was used to create slave account
Edited 1 time(s). Last edit at 02/19/2014 06:37AM by shahid hussain.
Subject
Views
Written By
Posted
Master replicating "Grant replication" statement to slave..?
1690
February 19, 2014 06:35AM
823
February 24, 2014 05:03PM
718
February 26, 2014 05:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.