How to display client data into master in mysql

July 19, 2017 1.5k views
MySQL Ubuntu 16.04

I have master-client replication system set up and the master data is being displayed in the client. Is there a way to sync the client details into mater?

3 Answers

Hi @Amrutha

I'm guessing you're talking about MySQL Master-Slave Replication.
In that case, you should never write (INSERT or UPDATE) to your slave's replicated database. You might end up breaking your replication.

Or did I misunderstand what you're asking for?


Thanks a lot for the info. This did help.


I have set up the master - master replication. So now when i create a table in master1 its getting displayed in master2, but when i create a table in master 2 it does not show up in master 1.

According to this master-master replication the data should travel both ways right?

Have another answer? Share your knowledge.