[horde] adding backup servers to mysql db driver

[Chuck Hagenbuch]

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