Oracle到mysql数据库镜像 [英] Oracle to mysql database mirroring

问题描述

我们正在使用将数据存储到ORACLE数据库的ERP应用程序，并且我们还有使用相同ERP数据库的Web应用程序.当ERP和另一个应用程序使用相同的数据库时，我们会遇到性能问题.

We are using ERP application that stores data to ORACLE database and also we have web applications that uses the same ERP database. We are getting the performance issues when ERP and another application use the same database.

我们计划将oracle数据库镜像到mysql数据库.因此，mysql db用于Web应用程序，而oracle db用于ERP.因此，我们可以说这些新数据库(mysql)是ERP数据库的镜像.

We are planning to do mirroring of oracle database into mysql database. So that mysql db is used for web applications and oracle db is used for ERP. So we could say these new database (mysql) are mirror of ERP database.

反映这种情况的最佳方法是什么?

What is the best way for mirroring this condition?

推荐答案

您可以将Golden Gate用于此类操作复制.请参见

You could use Golden Gate for this kind op replication. See GoldenGate for Oracle to MySQL A VERY smart alternative - and very price worthy - would be dbvisit replicate The Dedicated Dbvisit Server : Replicating Data from Oracle to MySQL and SQL Server

这篇关于Oracle到mysql数据库镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！