Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
6 years, 9 months ago
I am getting no errors yet replication is not working. I wonder where I am going wrong?
My master status is
My Slave Status is
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
1 row in set (0.00 sec)
24.4k 13 13 gold badges 51 51 silver badges 94 94 bronze badges
Aug 22, 2016 at 16:33
INSERT INTO site2.mytable ...;
will not be replicated. This is because the
USE controls replication, not the
If this does not provide the answer, please provide an example of the code that fails, plus mysqldumpbinlog against both the Master's binlog and the Slave's relay_log. This should show whether or not the query made it that far.
Aug 22, 2016 at 18:55
Rick James Rick James
74.8k 4 4 gold badges 44 44 silver badges 104 104 bronze badges
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only
Replicate_Do_DBand similar options do not work exactly the way most people assume. You need
BINLOG_FORMAT=ROWon the master if you want this configuration to be stable, or better, just replicate everything. Change that option in my.cnf on the master and restart it, then see what results you observe.