[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Synchronizing distant databases
I'm currently working on a little project for a business. I would need to
synchronize a few tables (maybe even only a few fields in those tables) from
2 distant databases. One database will be at a web host, and the other one
will be local. For the databases, I was planning on using either postgreSQL
or mySQL, or maybe a mix of both. (Personally I'd rather use postgreSQL,
but most web host only advertise mySQL)
We taught we could mirror the entire database every so often. But that
would be a big waste of ressources since only certain fields of a few
records would need to be updated.
Does anyone have experience synchronizing databases (or parts of databases)?
Keep up with high-tech trends here at "Hook'd on Technology."