Magento2 database EE Read/Write separation

[Vineethekm]

Hi All, We are in a situation like using AWS aurora database for the Magento2 build. While checking we could see split database options but couldn't find an option to use the Aurora Read replicas. Is there any way to use Writer node for Wirite operations and  Read Replica for reads with single database [Without split database feature]

Thanks

[Manthan Dave · Accepted solution]

Hi @Vineethekm 

AKAIK - We can not do splitting like read and write operations in database without using split functionality of Magento commerce (EE)

Because enterprise structure is developed on modular way ( Like running the command on will split those database tables) for ready/write operations so that we can use this functionality - if you want to use without that then you will require to do custom code for that.

Refer the following links for your reference (you might already referred that)  :

https://firebearstudio.com/blog/magento-2-split-database.html 

https://devdocs.magento.com/guides/v2.3/config-guide/multi-master/multi-master.html 

Hope it helps !