Hello,
Right now we are running a mysql-max db with InnoDb for transaction tracking. This is a older version of mysql running
mysql-3.23 build 50. We are planning on upgrading to mysql 4.0 latest in a couple of weeks (hopefully).
Anyways in order to do proper backups with InnoDB I am going to use the following method:
1. Make current mysql server master
2. Setup secondary mysql server as a slave so nightly I can bring down the slave to do binary backups. The slave server will be on a backup box and is only for backup purposes. It will not be uses by any production system.
The question for the list is ... can I use the latest version of mysql on the slave server so when we upgrade the master in a few weeks / month the master and slave will be at the same version ? Or does the slave have to be version 3.23 build 50 ?
4.0 slave can replicate 3.23 master, but you might run in a couple of glitches. If you are using LOAD LOCAL DATA INFILE, for example, there would be a problem. But the same problem would exist even if you used 3.23 to 3.23. You may also hit a couple of bugs, as this kind of replication has not been as well field-tested as 3.23 to 3.23 or 4.0 to 4.0.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
