I need to synchronize the data in MySQL Database from another server running same application in another Location. How to do the synchronization ? Thankyou in Advance.
Asked
Active
Viewed 55 times
2 Answers
1
Depending on your requirements MySQL replication or MySQL clustering will likely be what you want.
![](../../users/profiles/516230.webp)
J ramdom Bloke
- 26
- 1
-
How to do that , since i am new to these things i need details to do those things. If you have any link . Please Provide . – Bhuwan Bhandari Mar 27 '19 at 10:59
-
@BhuwanBhandari - There is a lot of documentation and discussion about replication. This forum is good for short answers, not for volumes of documentation. – Rick James Apr 26 '19 at 19:52
0
Simply have the client in the other Location remotely access the MySQL server in the primary location.
![](../../users/profiles/503422.webp)
Rick James
- 2,058
- 5
- 11
-
-
@BhuwanBhandari - Please elaborate on 'security'. You could connect using SSL. – Rick James Apr 24 '19 at 15:11
-