Opened 13 years ago

Last modified 12 years ago

#32 new enhancement

Add better database failover mechanisms

Reported by: rjl Owned by: rjl
Priority: normal Milestone: 1.1.0
Component: PHP scripts Version: 1.0.0 RC5
Severity: normal Keywords: database mysql postgresql failover primary backup replication
Cc:

Description

For high-availability installations it's vital to be able to detect that a database server is down and switch to a backup database immediately. The amavisd-new code supports database failover in a limited sense, but Maia needs to implement something at least as effective.

One issue to resolve is whether to revert to a primary server after switching to a backup server. In that instance, the primary server that just came back online may not have as current a data set as the backup server (until replication restores what the primary missed), so it may be better to continue with the backup server until some signal is received to force the switch back to the primary.

Change History (2)

comment:1 Changed 13 years ago by rjl

  • Severity changed from normal to enhancement

comment:2 Changed 12 years ago by dmorton

  • Milestone changed from 1.0.0 to 1.1.0
Note: See TracTickets for help on using tickets.