Re: Questions about replicating different versions

AWESOME!!!!! Thanks so much for responding. I will try it and let everyone know how it works.
Thanks,
Mark

On Oct 5, 2007, at 3:19 PM, Augusto Bott wrote:

> Mark,
>
> Replication between an older master (4.1.x series) and a newer slave
> (5.0.x series) 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:
>
> a) 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)
> b) 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 <mark.mccray@tbwachiat.com> 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
>
>
>
>

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. Received on Fri Oct 5 15:26:54 2007