Re: Questions about replicating different versions

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?

Replicating from a 4.0.26 master to a 5.0.37 slave has worked great for me. According to MySQL docs, you should not try to do that in the other direction --
http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html. As an experiment, I tried to connect a 4.0.26 slave to a 5.0.37 master and the slave would disconnect immediately when the version mismatch was detected.

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=mcallaghan@google.com
>
>

-- 
Mark Callaghan
mcallaghan@google.com