Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
257 views
in Technique[技术] by (71.8m points)

Oracle to mysql database mirroring

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.

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...