CODEWITHSUNDEEP
phpmysql
Sk_
Sk_

Reputation: 1191

Database syncup

We have one web server and Mysql server is in US region. We are planning to move the website to India. But all admin operation will be in US region only. So what is the best way to do the database connect to the US region database. or Can we create one more mysql server in India and is there a way to sync the data to US Db server.

Thanks in advance

Upvotes: 0

Views: 111

Answers (1)

java seeker
java seeker

Reputation: 1266

1) you can use remote database server as mysql support to connect remote database.

2) if you want to keep US database and want to sync from india server then use mysql replication

make us database server as master database which do database write operation.

create 1 or more slave which actually database reading openration

more details on database replication http://dev.mysql.com/doc/refman/5.0/en/replication.html

Upvotes: 1

Related Questions