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
