Mysql Distributed Databases

Bryan Sant bryan.sant at gmail.com
Mon Feb 7 21:54:03 MST 2005


On Sat, 05 Feb 2005 02:12:21 -0700, Kimball Larsen
<kimball at kimballlarsen.com> wrote:
> Suggestions?  Can MySQL even do this?

Consider placing this type of functionality in your client code.  Use
"shadow tables" or some other local caching of updates if the master
table is unavailable.  Apply the updates recorded in your shadow
tables to the master table when it becomes availible again.  If there
are pending updates in your local shadow tables, then that data source
becomes authoritative until the master db is back online and all
pending updates have been committed to the master table.

Leveraging this functionallity in your client code will also keep it
database agnostic.

-Bryan



More information about the PLUG mailing list