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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]