Architecture: 2 EC2 Instance, App and DB, app is integrated with POS android application,  used in many branches and every order created in android app hit's odoo app concurrently.

Problem Statement: CPU utilizing in DB EC2 instance increasing, no separation of read write queries, Future plans of integrating Odoo with services like notification systems like WhatsApp api, we want to avoid either read or write queries affect the source DB.

Proposal:-

1-Will Migrating the DB to amazon aurora and enabling replica the best approach? 

2-what are the things that we need to work on to enable this feature?

3-We heared that Heimdall Proxy in AWS might be great solution but not sure of the scalibilty of it, if we understand it will utilize the Instance for frequently Accessed data, and we don't have such a use case.

Really appreciate your inputs and thanks in advance!!