Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Questions about replicating different versions

From: Mark McCray <mark.mccray(at)tbwachiat.com>
Date: Fri Oct 05 2007 - 07:46:33 EDT


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=lists@pantek.com
Received on Fri Oct 5 07:46:44 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:14:26 EDT

Do you need help?X

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library