Re: Database design for online - offline mode working
Posted by:
Rick James
Date: February 03, 2012 02:52AM
Do you have one Master in the Home Office, and several Slaves, one per branch?
And you are asking about the Master being down or disconnected from the network?
If you _write_ to the tables on a Slave, the syncing process is too painful to discuss. Reading is no problem, except that data is stale.
Look into MySQL's NDB Cluster -- it has a way to make all instances be writable masters. Conflict resolution is handled via user-specified rules.
Galera might be a possibility.
Subject
Written By
Posted
February 01, 2012 05:24PM
Re: Database design for online - offline mode working
February 03, 2012 02:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.