I have followed the instructions on the Web on how to set up master-slave mySQL replication and I have spent a day and half trying to get it to work.
The master is simply not getting new data at all. I looked at phpMyAdmin and I see "replication" enabled on both systems - slave/master. But nothing shows up. The DB structure is identical on both systems.
It has never generated any errors. The slave is able to connect to the master as shown in show slave status command. The PROCEESSLIST showed no errors. I used the replicate_do_db set on slave. If I unplug the ethernet cable, it will generate error. Plug it back in, and it just does nothing (except that the error went way). I changed the password and it generated error as expected but put it back to right password and it just went silent with no errors.
It's so aggravating as it doesn't tell me WHY it's not updating at all or why it's not pushing data to master. I am under the impression that any new data that's entered in slave DB should automatically be replicated to the master and the master should be showing data. Is this correct?
Is there any way that I can find what went wrong considering that the replication setup tells no errors whatsoever? How do I force the master to get data from the slave? Is there a way to do it?