Data sync between two local Mysql databases in different system in same netwrok

Posted on

Question :

I am using mysql as database for my application and for the purpose of fail over and I need to sync the data from one local mysql database in system one to other local database in system 2 connected through same network.So I want to know how to connect local database in other system and sync data automatically

Answer :

You need MySQL replication.

Here is the official documentation

I like to use step by step guides, so here’s a more simple explanation:

Those docs should work for MySQL 5.X and 8.X.

Leave a Reply

Your email address will not be published. Required fields are marked *