Re: Multi-Master replication
It depends on your application how you can implement this as well.
We have a master/master setup, our in house developed PHP applications we use a function to connec to the database. It first attempts a connection to the primary database, if that fails it falls back to the other master.
It then stores a value in memory to wait for 60 seconds, so all connections during that 60 seconds will go to the alternate master.
After 60 seconds it will try again, if it still fails will continue with the master that is up.
If we expect a long period of downtime, we can have the applications consider the master that is still up as the primary.
As long as both do not go down at the same time, we are golden.
Subject
Views
Written By
Posted
1627
February 26, 2015 02:04PM
958
February 27, 2015 12:09PM
Re: Multi-Master replication
917
April 21, 2015 08:07PM
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.