List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 5 2010 10:08pm
Subject:Re: Replication between MySQL 3.23.58 and MySQL 5.1.46
View as plain text  
HI Neil,
first I dont know if you can do it.

As a basic rule if not same version, Master version should always be older
than slave,
but I am afraid binary log format is too different from 3.23 to 5.1

If you have problems with direct replication In your case I would suggest a
couple of solutions.

   - upgrade 3.23 to 4.1 and then setup replication from 4.1 to 5.14)
   - setup a chain replication with intermediate versions like:
   3.23-->4.1-->5.1

Just a couple of ideas.
You should not have big problems in upgrading 3-->4, if you want some idea
on how to do it let me know.

Claudio


2010/5/5 Tompkins Neil <neil.tompkins@stripped>

> Hi,
>
> Does anyone know of any issues if we try to replicate data from MySQL
> database version 3.23.58 and MySQL 5.1.46 ?
>
> Cheers
> Neil
>



-- 
Claudio

Thread
Replication between MySQL 3.23.58 and MySQL 5.1.46Tompkins Neil5 May
  • Re: Replication between MySQL 3.23.58 and MySQL 5.1.46Claudio Nanni6 May
  • HOW TO INSTALL MYSQL ODBC ON AIX 5.3 ?sun.yan56 May