Servers syncronization Linux Centos

Question

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.

score 1 · Accepted Answer · answered Mar 27 '19 at 06:26

1

Depending on your requirements MySQL replication or MySQL clustering will likely be what you want.

answered Mar 27 '19 at 06:26

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

score 0 · Answer 2 · answered Apr 18 '19 at 20:55

0

Simply have the client in the other Location remotely access the MySQL server in the primary location.

answered Apr 18 '19 at 20:55

Rick James

2,463
1
6
13

Cannot do that because of security reasons :) – Bhuwan Bhandari Apr 24 '19 at 11:09
@BhuwanBhandari - Please elaborate on 'security'. You could connect using SSL. – Rick James Apr 24 '19 at 15:11
We cannot let our vendors use our database directly – Bhuwan Bhandari Apr 26 '19 at 05:32

Servers syncronization Linux Centos

2 Answers2