Mirroring a DB
Posted: Thu Jul 15, 2004 2:57 am
Morning peeps,
Here thes the situation. Our company has an Intranet running on our local network.
Abviously it is bulit using PHP and MySQL.
One part of the intranet has information that needs to be mirrored in another MySQL DB offsite with one of our web hosts.
I'm not sure the best way to do this. When performing my queries (inserting and updating data), should i just perform them on each DB.
This method seems a long winded way of doing it.
Or once i have done the queries on the local DB, i could syncronize the DBs, but this would involve upload a lot of unchanged data and would probably take too long to be unoticeable.
Anyone else got ideas of how i should go about such a task?
Thanks
Mark
Here thes the situation. Our company has an Intranet running on our local network.
Abviously it is bulit using PHP and MySQL.
One part of the intranet has information that needs to be mirrored in another MySQL DB offsite with one of our web hosts.
I'm not sure the best way to do this. When performing my queries (inserting and updating data), should i just perform them on each DB.
This method seems a long winded way of doing it.
Or once i have done the queries on the local DB, i could syncronize the DBs, but this would involve upload a lot of unchanged data and would probably take too long to be unoticeable.
Anyone else got ideas of how i should go about such a task?
Thanks
Mark