Page 1 of 1

Duplicate two databases on different Servers

Posted: Mon Jul 27, 2009 10:00 pm
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

Re: Duplicate two databases on different Servers

Posted: Tue Jul 28, 2009 1:44 am
by Christopher
Use MySQL's replication functionality. See the manual.