Duplicate two databases on different Servers
Posted: Mon Jul 27, 2009 10:00 pm
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
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