We are having an e-commerce application which is working in Mysql and java. We are expecting number of users increasing and our database is will be busy with our e-commerce request itself.
At the same time we are planing to implement a CRM tool to maintain our sales team which will again going to hit the same database and the database will again be more busy since we will have highly complex queries in our CRM tool.
The Mysql database we are having in an Amazon RDS server.
Is there any option for our CRM tool got the live data which read and write this data without affecting our original E-commerce database.
Let me know what all solutions we have in this case.