IDS 7.3 and mySQL
Hello, I work for a small consulting company doing many of its backend programming. Recently I've been assigned with a task of designing a system that will synchronize an offline INFORMIX database with a remote online mySQL database. I am very new to Informix so I figured this could be a great place to seek advice and help. Thank you in advance. My first approach was to create update triggers on the INFORMIX database that will call UDRs. These UDRs will then perform updates on the mySQL database. However, this may not be an option. I'm working with Informix Dynamic Server Version 7.30.UC2. My understanding is UDR are available to version 9 and above. So only option I see at this point is to perform a scheduled update from Informix to mySQL. In this approach, update triggers on the INFORMIX database will perform post to a bulletin board (another set of tables, in Informix). Pushing the updates to the mySQL database will be performed via a daemon or cronjob. Disadvantages to this approach are 1) Updates to mySQL database will not be in real-time. 2) Unnecessary query are being performed. One main advantage of this approach is that it has greater fault-tolerance over the first approach. Given the version of Informix I am working with, are there any other approaches that I'm not seeing? If so, are they dependent on other plugins, products being installed. How ca I find out if these components have already been installed? Unfortunately, I am mostly on my own and do not have access to the person that setup the original environment. Thank you so much!
IDS 7.31 supports stored procedures (a sort of UDR, but not called such). Stored procedures support the SYSTEM statement (which will be slow). You might be able to leverage this to do the job. OTOH, it may not be feasible -- it will depend on a multitude of factors, such as required performance and size of tables. Writing a UDR that communicated with MySQL would require a new VP class, and still require careful code, even in IDS 9.x. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "ROB SUNG" | | | <robsung@bigchalu| | | pa.com> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 08/19/2003 11:36 | | | PM | | | | |---------+----------------------------> >------------------------------------------------------------------------------- --------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: IDS 7.3 and mySQL [1727] | | | >------------------------------------------------------------------------------- --------------------------------------------------------------| Hello, I work for a small consulting company doing many of its backend programming. Recently I've been assigned with a task of designing a system that will synchronize an offline INFORMIX database with a remote online mySQL database. I am very new to Informix so I figured this could be a great place to seek advice and help. Thank you in advance. My first approach was to create update triggers on the INFORMIX database that will call UDRs. These UDRs will then perform updates on the mySQL database. However, this may not be an option. I'm working with Informix Dynamic Server Version 7.30.UC2. My understanding is UDR are available to version 9 and above. So only option I see at this point is to perform a scheduled update from Informix to mySQL. In this approach, update triggers on the INFORMIX database will perform post to a bulletin board (another set of tables, in Informix). Pushing the updates to the mySQL database will be performed via a daemon or cronjob. Disadvantages to this approach are 1) Updates to mySQL database will not be in real-time. 2) Unnecessary query are being performed. One main advantage of this approach is that it has greater fault-tolerance over the first approach. Given the version of Informix I am working with, are there any other approaches that I'm not seeing? If so, are they dependent on other plugins, products being installed. How ca I find out if these components have already been installed? Unfortunately, I am mostly on my own and do not have access to the person that setup the original environment. Thank you so much!
Hi You can use Informix Enterprise Gateway Manager to map any ODBC source to informix synonym. Use triggers on informix table to insert and update these synonyms. http://www-3.ibm.com/software/data/informix/tools/egm/ Uri ROB SUNG wrote: >Hello, > >I work for a small consulting company doing many of >its backend programming. Recently I've been assigned with a >task of designing a system that will synchronize an >offline INFORMIX database with a remote online mySQL database. >I am very new to Informix so I figured this could be a great place >to seek advice and help. Thank you in advance. > >My first approach was to create update triggers on the INFORMIX >database that will call UDRs. These UDRs will then perform updates >on the mySQL database. > >However, this may not be an option. > >I'm working with Informix Dynamic Server Version 7.30.UC2. My understanding is >UDR are available to version 9 and above. > >So only option I see at this point is to perform a scheduled update >from Informix to mySQL. >In this approach, update triggers on the INFORMIX database will perform post >to a bulletin board (another set of tables, in Informix). Pushing the updates >to the mySQL database will be performed via a daemon or cronjob. > >Disadvantages to this approach are >1) Updates to mySQL database will not be in real-time. >2) Unnecessary query are being performed. > >One main advantage of this approach is that it has greater >fault-tolerance over the first approach. > > >Given the version of Informix I am working with, are there any other >approaches that I'm not seeing? If so, are they dependent on other >plugins, products being installed. How ca I find out if these components >have already been installed? Unfortunately, I am mostly on my own and do not >have access to the person that setup the original environment. > >Thank you so much! > > > > > > >