[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: upgrade mysql server with least downtime

On Wed, Dec 18, 2002 at 01:29:03PM +0800, Patrick Hsieh wrote:
> Hello list,
> I am planing to upgrade a running mysql server on woody to fix the recent 
> security issue. Is there any trick to make the service have least downtime 
> when upgrading the mysql server?
> I was thinking if it is possible that I have two mysql daemons running on the 
> same machine(port 3306 and 3307) and share the same mysql data. When I 
> upgrade the 1st daemon, the iptables redirects the incoming tcp 3306 
> connection to tcp 3307, on which the secondary daemon is listening. When 
> finish upgrading, change the localhost iptables rules to dismiss the 
> redirection. Is it possible? Will I have locking problem with 2 daemons 
> sharing the same mysql data?

Ouchy.  I don't think that's a very good idea at all.  I'd just install
the package normally.  dpkg will only restart the daemon at the end of
the upgrade process, so you'll have on the order of seconds of downtime.


Attachment: pgpJqDoR9ZUPf.pgp
Description: PGP signature

Reply to: