On Wed, May 12, 2004 at 04:11:41PM -0400, Tucker, Gabriel wrote:
> Sorry for the second post, I realized that my first post might not be clear...
>
> I want the failover and the switch from "read-only" to "non
> read-only" to be dynamic, no downtime.
You can't do that. The read-only setting cannot be changed on the fly
(yet?).
You could do it via GRANT changes, but that's a clumsy hack if you ask
me. :-(
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/