[horde] adding backup servers to mysql db driver
Chuck Hagenbuch
chuck at horde.org
Thu Jan 4 21:19:15 PST 2007
Quoting "Joseph W. Breu" <breu at cfu.net>:
> In our environment, we have 2 r/w database servers using redundancy
> to store session and user pref data. We also have 2 r/o servers
> for our mail exchangers to query.
>
> I started looking at the process for adding backup database servers
> to Horde. The SessionHandler was pretty easy (changes to
> Horde/SessionHandler/mysql.php attached). The basic idea is to try
> the second server if the first fails and only provide the db connect
> error if the second try fails.
>
> However, I was looking at modifying the rest of the Horde mysql db
> backend. Has this already been worked on?
No. There's a config setting in the latest code to split reads and
writes to different servers, but not to do failover.
I'm kind of of the opinion that this sort of thing (failover) belongs
on the database server, not in the app.
-chuck
--
"we are plastered to the windshield of the bus that is time." - Chris
More information about the horde
mailing list