Re: Questions about replicating different versions

Mark,

Replication between an older master (4.1.x series) and a newer slave (5.0.xseries) will indeed work. The other way around will not. This can happen
because the 4.1.x series does not 'understand' the dialect spoken by the 5.0.x series (but the newer version does). As with Mark Callaghan, I've also used this very same replication setup (I was using it to migrate with minimum pain/downtime from 4.1.x to the 5.0.x series).

However, take care of two issues:

1. new reserved words from series 4.1.x to 5.0.x like 'call': it's a reserved word in 5.0.x - check for table names and/or columns using such words (escaping them with ` in the application is usually a solution good enough)
2. the syntax of LEFT JOIN (check http://dev.mysql.com/doc/refman/5.0/en/join.html if you use LEFT JOINs). That's a precedence and eventual adding some parenthesis)

Both this items may break replication (but are easily fixable), since the statement will run OK on the master but will fail to execute on the slave usually because of a syntax error (in these cases, adding escape characters or parenthesis on the joins can fix the situation).

Regarding triggers - yes - they will fire and work properly on a 5.0.x slave of a 4.1.x master (already tested that also).

-- 
Augusto Bott


On 10/5/07, Mark McCray  wrote:

>
> Hello,
> I have a mysql database that is a slightly modified version of 4.1
> from a vendor. They have no plans of moving to version 5.
>
> So we were interested in being able to replicate this 4.1 database
> into a 5 database.
> The reason why is because we'd like to be able to take advantage of
> stored procedures in 5.
>
> We're basically looking to make a search index on top of the data that
> works in a certain way, but which is built up by stored procedures.
>
> My question is two-fold:
> 1. Is it possible to replicate a v4.1 server to v5.0 and above?
> 2. and if so, is it possible that when the replications happens, say
> an insert is performed in a certain table and that replicates across,
> that triggers in the v5 database can kick off stored procedures? (Is
> it even possible to make stored procedures and triggers on a
> replicated database in 5?)
>
> Am I crazy? hehe
> thanks,
> mark
>
>
>
>
> This e-mail is intended only for the named person or entity to which it is
> addressed and contains valuable
> business information that is proprietary, privileged, confidential and/or
> otherwise protected from disclosure.
>
> If you received this e-mail in error, any review, use, dissemination,
> distribution or copying of this e-mail
> is strictly prohibited. Please notify us immediately of the error via
> e-mail to disclaimer@tbwachiat.com and
> please delete the e-mail from your system, retaining no copies in any
> media. We appreciate your cooperation.
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=augusto.bott@gmail.com
>
>