List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:May 12 2004 9:48pm
Subject:Re: --read-only startup
View as plain text  
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/
Thread
--read-only startupGabriel Tucker12 May
RE: --read-only startupGabriel Tucker12 May
  • Re: --read-only startupJeremy Zawodny12 May