[imp] IMP/horde mysql failback ?

[Shifter]

One way you could do it is to add something like:
(Pseudo-code)

if ( !$result)
{

    $result = mysql_query($backup_db);

}

Use the MySQL replication to have the data on multiple servers.

Just brainstorming here... not even suggesting that you do this (c:


Regards,
Stephen

----- Original Message -----
From: "Rich Lafferty" <rich@horde.org>
To: <imp@lists.horde.org>
Sent: Thursday, January 18, 2001 7:45 AM
Subject: Re: [imp] IMP/horde mysql failback ?


> On Thu, Jan 18, 2001 at 03:14:41PM +0100, Remsnet Mail2News IMP mailing
liste (rnsimp@mail.remsnet.de) wrote:
> > hello ,
> >
> > short question :
> >
> > Are there any kind of code that support 2 mysql Db server ?
>
> Quite possibly, but it'd be entirely outside IMP. You'd just have to
> have every transaction (er, "\"transaction\"" :-) executed twice, plus
> the hardware to know that one's gone out of the way. I imagine it'd be
> more expensive than, say, buying Oracle. :-)
>
> > ( if the 1.st fails than the second should be used .. )
> > i have had 5 some mysql db failouts at the past 4 month with imp 2.2.X
>
> Might I suggest using a more reliable DBMS? We've had good luck with
> Postgres.
>
>   -Rich
>
> --
> ------------------------------ Rich Lafferty ---------------------------
>  Sysadmin/Programmer, Instructional and Information Technology Services
>    Concordia University, Montreal, QC                 (514) 848-7625
> ------------------------- rich@alcor.concordia.ca ----------------------
>
> --
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>