Duplicate two databases on different Servers

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dv_evan
Forum Commoner
Posts: 42
Joined: Wed Apr 09, 2008 8:23 am

Duplicate two databases on different Servers

Post by dv_evan »

Hello Everyone,

I need advice on this scenario:

I have two webhosting servers (A & B)with running PHP/MYSQL.
I have a MYSQL database name DBone on server A. I would like this DBone to be copy/duplicate on server B. Importantly also, I would like when Server A Bdone is updated these changes are duplicated over to server A. Therefore at any one time DBone databases on both Servers (A&B) are synchronize.

Any idea how to go about doing this?

Cheers!
Dave Evan
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Duplicate two databases on different Servers

Post by Christopher »

Use MySQL's replication functionality. See the manual.
(#10850)
Post Reply