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
You can definitely use the external DB for WP. You need to make sure that your RDS instance is accessible from Magento cloud (IP must be whitelisted). Once that is confirm you need to update the DB details in WP configuration (wp-config.php) file.
Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.