Opened 18 years ago

Last modified 17 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


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 18 years ago by rjl

  • Severity changed from normal to enhancement

comment:2 Changed 17 years ago by dmorton

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