List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:February 16 2011 9:23am
Subject:Replicating to mysql5.1 from 5.0 master?
View as plain text  
Hi All

        as per my mail yesterday we are busy migrating and upgrading a
current MySQL database this weekend.

        All tests on the new system has been done,etc... 

        However, in order to minimize downtime, it was decided to setup
the new "master" server (Mysql 5.1) to be a slave to the current
production master server (Mysql 5.0).

         Due to differences within the 2 versions, we had to exclude the
mysql database from the backup and restore.

            However I am now not 100% sure about the following:

                    When setting up the replication, should we still
exclude the mysql database from the replication and manually do any
changes if required or can we replicate all databases without any

            We are switching over to the new system on Friday and I do
not want to break something now that will compromise the go-live.

          Any suggestions would be greatly appreciated. (My feeling is
to exclude the mysql database from replication but not too sure). 

Machiel Richards
Relational Database Consulting (Pty) Ltd 

MYSQL / POSTGRES specialist
20 Stirrup Lane, Woodmead Office Park, Van Reenens Road, Woodmead, South
Office: 0861 RDC RDC (0861 732 732)
Mobile: +27 72 238 6008 
Fax: 0861 RDC FAX (0861 732 329)
E-Mail: machielr@stripped 

Replicating to mysql5.1 from 5.0 master?Machiel Richards16 Feb
  • Re: Replicating to mysql5.1 from 5.0 master?Johan De Meersman16 Feb