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
Duplicate two databases on different Servers
Moderator: General Moderators
- 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
Use MySQL's replication functionality. See the manual.
(#10850)