If I create a replicated database cluster as per http://www.objectdb.com/java/jpa/tool/replication what is the behaviour of the master database after a failure?
For example, say I have MasterDB and SlaveDB in the cluster. If MasterDB goes offline the application will automatically switch to SlaveDB. When MasterDB comes back online it will have missed any activity that occured during the downtime.
What is the best way to resolve this? Copying SlaveDB would be an option put presumably this would be a manual task and the application would need to be halted during the copy otherwise further updates would be missed.
Ideally the SlaveDB would become the new master when MasterDB goes offline and then MasterDB would become a slave when it comes back online. Or something similar...
Let me know if that doesnt make sense and I'll explain better. Also let me know if I've misunderstood anything and this functionality (or similar) is currently available.