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
problems?
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
Africa
Office: 0861 RDC RDC (0861 732 732)
Mobile: +27 72 238 6008
Fax: 0861 RDC FAX (0861 732 329)
E-Mail: machi...@rdc.co.za
