How can Mysql database sync between two databases

Question

We are running a Java PoS (Point of Sale) application at various shops, with a MySql backend. I want to keep the databases in the shops synchronised with a database on a host server.

When some changes happen in a shop, they should get updated on the host server. How do I achieve this?

Answer 1

Hii,

Some simple rules you will have to keep in mind:

1. Setup 1 server (master) for writing data.
2. Setup 1 or more servers (slaves) for reading data.

This way, you will avoid errors.

For example: If your script insert into the same tables on both master and slave, you will have duplicate primary key conflict.

You can view the "slave" as a "backup" server which hold the same information as the master but cannot add data directly, only follow what the master server instructions.

NOTE: Of course you can read from the master and you can write to the slave but make sure you don't write to the same tables .

I would recommend to monitor your servers to make sure everything is fine.

Hope this is helpful!

Thank You!!