Share

Question

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?

Accepted Answer

hansen July 19, 2017

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?

Reply

Amrutha July 19, 2017

Hi @hansen : Your understanding is correct.

According to the above link if we create a new database and tables in the slave, how could those details be displayed in the master?
- hansen July 19, 2017
  
  @Amrutha
  
  You couldn't - not with Master-Slave. Unless something has changed with MySQL, the replication is one-way for the entire server, even though it's manually defined which databases are replicated.
  
  If you want replication in every direction, then you should be looking at Master-Master replication, or maybe something like Galera if you want to expand to more than two database servers:
  https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-10-1-on-ubuntu-16-04-servers
  
  How To Configure a Galera Cluster with MariaDB 10.1 on Ubuntu 16.04 Servers
  Clustering adds high availability to your database at the hardware level by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue serving...

Answer 2

Amrutha July 19, 2017

Hi @hansen : Your understanding is correct.

According to the above link if we create a new database and tables in the slave, how could those details be displayed in the master?
- hansen July 19, 2017
  
  @Amrutha
  
  You couldn't - not with Master-Slave. Unless something has changed with MySQL, the replication is one-way for the entire server, even though it's manually defined which databases are replicated.
  
  If you want replication in every direction, then you should be looking at Master-Master replication, or maybe something like Galera if you want to expand to more than two database servers:
  https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-10-1-on-ubuntu-16-04-servers
  
  How To Configure a Galera Cluster with MariaDB 10.1 on Ubuntu 16.04 Servers
  Clustering adds high availability to your database at the hardware level by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue serving...

Accepted Answer

Amrutha July 19, 2017

@hansen

Thanks a lot for the info. This did help.

Reply

Accepted Answer

Amrutha July 20, 2017

@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?

Reply

hansen July 20, 2017
@Amrutha
Can you post your configuration from both servers. And run this SQL query on both servers:

SHOW MASTER STATUS;

There's a tutorial about Master-Master setup, but it's old, but I still think you can skim through it and see if you've missed anything in your setup:
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication
How To Set Up MySQL Master-Master Replication
by Jason Kurtz
This second installment of "Scaling Web Applications" will list out the steps necessary for scaling a mysql deployment over two VPS.

Answer 5

hansen July 20, 2017
@Amrutha
Can you post your configuration from both servers. And run this SQL query on both servers:

SHOW MASTER STATUS;

There's a tutorial about Master-Master setup, but it's old, but I still think you can skim through it and see if you've missed anything in your setup:
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication
How To Set Up MySQL Master-Master Replication
by Jason Kurtz
This second installment of "Scaling Web Applications" will list out the steps necessary for scaling a mysql deployment over two VPS.

How to display client data into master in mysql

Leave a Comment

Share

Share your Question

How to display client data into master in mysql

Leave a Comment

Related Questions

Almost there!

Report a Bug