Great, thanks, Dave
On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote:
> >
> > I have two identical primarily readonly databases that I want to be
> > able to upgrade on the fly. What I want to be able to do is take one
> > down and have all my connections redirected to the second database
> > automatically. I would also like the same auto failover when a
> > database crashes, because of cpu, disk, etc. In oracle I can setup
> > tnsnames failover. Is there a similar mechanism in MYSQL to redirect
> > failed connections to a secondary database?
>
> There is not mechanism built into MySQL currently. You might look at
> the Linux Virtual Server (LVS) for a solution. I believe it'll give
> you just what you're looking for...
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 3 days, processed 44,686,278 queries (146/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
