FAQ
Hi,

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?

Thanks,
Lisa


--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe: http://lists.mysql.com/replication

Search Discussions

  • Johan De Meersman at Jan 4, 2012 at 12:14 pm

    ----- Original Message -----
    From: "Database System" <database100@yahoo.com>

    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

    --
    MySQL Replication Mailing List
    For list archives: http://lists.mysql.com/replication
    To unsubscribe: http://lists.mysql.com/replication
  • Database System at Jan 5, 2012 at 1:57 am
    Do all the users databases have to be run through mysql_upgrade?

    Thanks,

    Lisa

    --- On Wed, 1/4/12, Johan De Meersman wrote:
    From: Johan De Meersman <vegivamp@tuxera.be>
    Subject: Re: master to master upgrade 5.0-> 5.1
    To: database100@yahoo.com
    Cc: "Replication" <replication@lists.mysql.com>
    Date: Wednesday, January 4, 2012, 6:14 AM
    ----- Original Message -----
    From: "Database System" <database100@yahoo.com>

    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
    --
    MySQL Replication Mailing List
    For list archives: http://lists.mysql.com/replication
    To unsubscribe: http://lists.mysql.com/replication
  • Johan De Meersman at Jan 5, 2012 at 1:23 pm

    ----- Original Message -----
    From: "Database System" <database100@yahoo.com>

    Do all the users databases have to be run through mysql_upgrade?
    No. That script acts only on the mysql database. User databases usually don't need specific actions; but read the upgrade notices to be sure - sometimes you may want to do things like upgrade tables to a newer version of the InnoDB tablespace format, for instance.



    --
    Bier met grenadyn
    Is als mosterd by den wyn
    Sy die't drinkt, is eene kwezel
    Hy die't drinkt, is ras een ezel

    --
    MySQL Replication Mailing List
    For list archives: http://lists.mysql.com/replication
    To unsubscribe: http://lists.mysql.com/replication
  • Database System at Jan 5, 2012 at 4:32 pm
    Thank you very much.

    Lisa

    --- On Thu, 1/5/12, Johan De Meersman wrote:
    From: Johan De Meersman <vegivamp@tuxera.be>
    Subject: Re: master to master upgrade 5.0-> 5.1
    To: database100@yahoo.com
    Cc: "Replication" <replication@lists.mysql.com>
    Date: Thursday, January 5, 2012, 7:22 AM
    ----- Original Message -----
    From: "Database System" <database100@yahoo.com>

    Do all the users databases have to be run through
    mysql_upgrade?

    No. That script acts only on the mysql database. User
    databases usually don't need specific actions; but read the
    upgrade notices to be sure - sometimes you may want to do
    things like upgrade tables to a newer version of the InnoDB
    tablespace format, for instance.



    --
    Bier met grenadyn
    Is als mosterd by den wyn
    Sy die't drinkt, is eene kwezel
    Hy die't drinkt, is ras een ezel
    --
    MySQL Replication Mailing List
    For list archives: http://lists.mysql.com/replication
    To unsubscribe: http://lists.mysql.com/replication

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupreplication @
categoriesmysql
postedJan 2, '12 at 12:50p
activeJan 5, '12 at 4:32p
posts5
users2
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2022 Grokbase