Amrutha
By:
Amrutha

How to display client data into master in mysql

July 19, 2017 151 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.
https://dba.stackexchange.com/questions/9248/in-a-mysql-master-slave-replication-what-would-happen-if-i-write-to-the-slave

Or did I misunderstand what you're asking for?

@hansen

Thanks a lot for the info. This did help.

@hansen

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.