List:Replication« Previous MessageNext Message »
From:Database System Date:January 5 2012 1:56am
Subject:Re: master to master upgrade 5.0-> 5.1
View as plain text  
Do all the users databases have to be run through mysql_upgrade? 

Thanks,

Lisa

--- On Wed, 1/4/12, Johan De Meersman <vegivamp@stripped> wrote:

> From: Johan De Meersman <vegivamp@stripped>
> Subject: Re: master to master upgrade 5.0-> 5.1
> To: database100@stripped
> Cc: "Replication" <replication@stripped>
> Date: Wednesday, January 4, 2012, 6:14 AM
> ----- Original Message -----
> > From: "Database System" <database100@stripped>
> > 
> > We know when we upgrade replication servers from 5.0
> to 5.1, we need
> > to upgrade slave server first. But what about master
> to master
> > replication?
> 
> Strictly speaking, master-master is not supported, so
> you're on your own :-)
> 
> Given that the new slave speaks both formats (assuming
> there's a format change), it makes sense to stop the slave
> on the active master; then upgrade the passive master; then
> upgrade the active master and then re-enabling the slave on
> that node - that way the last slave to be upgraded will only
> start reading the new format logs after it has been
> upgraded, and everything should work.
> 
> You can, of course, switch operations to the passive node
> after it's been upgraded, if so desired.
> 
> -- 
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
> 
Thread
master to master upgrade 5.0-> 5.1Database System2 Jan
  • Re: master to master upgrade 5.0-> 5.1Johan De Meersman4 Jan
    • Re: master to master upgrade 5.0-> 5.1Database System5 Jan
      • Re: master to master upgrade 5.0-> 5.1Johan De Meersman5 Jan
        • Re: master to master upgrade 5.0-> 5.1Database System5 Jan