10 Replies Latest reply: Sep 4, 2009 5:46 AM by Sven W. RSS

    how use the mysql and oracle in parallel

    639812
      Hi,

      Here using oracle 10g as backend and forms 6i front end,
      but that system has been changed to .net and mysql,
      but they want to store the data in mysql and oracle(both),

      Example

      One record inserted in mysql parallely they want to store the same record oracle1og also.

      Any possibility to made the data link between oracle and mysql.

      otherwise if possible to connect the mysql through the forms6i




      Thanks
      B.Prakash
        • 1. Re: how use the mysql and oracle in parallel
          Satyaki_De
          You can check this link ->

          [MySQL to Oracle|http://www.idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml]

          Regards.

          Satyaki De.
          • 2. Re: how use the mysql and oracle in parallel
            639812
            Hi,


            we are using windows xp,not linux


            Thanks and regards
            B.Prakash
            • 3. Re: how use the mysql and oracle in parallel
              Satyaki_De
              Hmm...

              [Try This|http://lists.mysql.com/mysql/189287]

              Regards.

              Satyaki De.
              • 4. Re: how use the mysql and oracle in parallel
                JustinCave
                You could create a database link from Oracle to MySQL using Heterogeneous Services and the ODBC Gateway. You could then connect to Oracle and insert data into the Oracle table and the MySQL table serially. You could also put a trigger on the Oracle table that would replicate the action to MySQL. This sort of architecture, however, should be strongly discouraged. If you want the two databases to be modified synchronously, your application will work only if both databases are up (and if the network connection between them is working) which is a huge hit on availability. There are also performance issues since all your transactions become distributed transactions with the attending overhead. And it's not obvious what real benefits you derive-- it seems exceptionally odd to want the same transactional data synchronously replicated between two different databases let alone to want those two databases to be running completely different stacks (Oracle vs. MySQL). And that only handles replicating data from Oracle to MySQL. If changes can be made in MySQL as well as Oracle, life is even more complicated.

                If you can handle some degree of lag between DML happening on one database and that DML being applied to the other, you may have a few more options. But heterogeneous data replication tends to be a pain, particularly if there is the potential for multiple DML to take place on both sides.

                Justin
                • 5. Re: how use the mysql and oracle in parallel
                  JustinCave
                  Note that this appears to discuss configuring the desupported Generic Connectivity option for creating the ODBC connection to MySQL. That should work, but Oracle no longer supports that. If you're setting something up today, you'd want to use the ODBC gateway.

                  Justin
                  • 6. Re: how use the mysql and oracle in parallel
                    Satyaki_De
                    True.

                    Regards.

                    Satyaki De.
                    • 7. Re: how use the mysql and oracle in parallel
                      Billy~Verreynne
                      PRAKASH B wrote:

                      Here using oracle 10g as backend and forms 6i front end,
                      but that system has been changed to .net and mysql,
                      but they want to store the data in mysql and oracle(both),

                      Example

                      One record inserted in mysql parallely they want to store the same record oracle1og also.
                      Let me be the first to say (in this thread) that this is just a plain stupid idea. Justin hinted to this fact calling it "+a pain+", but I believe a more blunt response is required to highlight this fact.

                      If you do need this very unusual architecture, then make use of replication (from Oracle to mySQL). Insert into Oracle and commit. Use background processes to replicate the committed data to mySQL.

                      Do not attempt distributed and heterogeneous transaction processing as is like experimenting just how high you can jump from an aeroplane without a parachute before killing yourself. You will only survive it with the plane on the tarmac.. but once airborne (system in production). It will hurt. A lot.
                      • 8. Re: how use the mysql and oracle in parallel
                        Satyaki_De
                        Do not attempt distributed and heterogeneous transaction processing as is like experimenting just how high you can jump from an aeroplane without a parachute before killing yourself. You will only survive it with the plane on the tarmac.. but once airborne (system in production). It will hurt. A lot.
                        He he he.....

                        What a brilliant way to convey the message. ;)

                        Regards.

                        Satyaki De.
                        • 9. Re: how use the mysql and oracle in parallel
                          94799
                          What a brilliant way to convey the message
                          Agree. Been there and the tarmac is hard and it doesn't taste good.
                          • 10. Re: how use the mysql and oracle in parallel
                            Sven W.
                            Simply stay with the oracle database (MySql belongs to oracle now anyway). Write the .Net code so that it accesses Oracle, e.g. by using some ODA.Net stuff.