We are planning to migrate from 1.9.x to Magento Commerce Cloud. We have wordpress separately for blog related modules. Currently we have it as a separate DB hosted in same AWS RDS.
When we move to magento cloud how do we keep database separately for Wordpress? Any suggestions and advice on the steps would be much appreciated.
You should be able to continue hosting your WordPress database with AWS RDS and just connect to it from Magento Commerce Cloud.
For the steps to achieve this, it will be best for you to get in touch with the Magento Commerce Cloud team directly: https://magento.com/contact-us