We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got 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?