How to display client data into master in mysql

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?

Answer 1

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 Report

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?
Reply Report
- 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
  by Melissa Anderson
  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...
  
  Reply Report

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?
Reply Report
- 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
  by Melissa Anderson
  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...
  
  Reply Report

Answer 3

Amrutha July 19, 2017

@hansen

Thanks a lot for the info. This did help.

Reply Report

Answer 4

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 Report

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.
Reply Report

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.
Reply Report

Related

Question

How to display client data into master in mysql

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

How to display client data into master in mysql

Leave a comment

Related

question

install mysql 3.24 on ubuntu 16.04

question

Automatically restart MySQL on Ubuntu 16.04.x - If statement may be wrong?

question

I am trying to configure MySQL, my.cnf to set-up the blind-address, server-id, log-bin etc... how I can resolve this Issue, Thanks

question

connecting databases with razorsql

Looking for something else?