Magento 2.x CE Master-Slave MySQL

[thedoole]

Hello,

Is it possible to have one master DB and one slave DB in Mag 2.X CE and to use master for write and slave for read?

Thanks

[Manish Mittal · Accepted solution]

hello @thedoole

According to the docs, it looks like it, yes. Built-in split database functionality (CQRS) is only supported in Magento 2 EE.

http://devdocs.magento.com/guides/v2.0/config-guide/multi-master/multi-master.html

"In Magento Community Edition (CE), only one master database is used."

Although it will not give you out of the box read/write segregation, you could work around some of the scalability issues with a single DB by using Galera cluster with master-master replication.

Magento 1.x allowed master/slave databases whereas Magento2 is single database with only the enterprise edition allowing replicated databases.

[miguel angel_pescador]

try this https://skynix.co/resources/magento-2-ce-database-replication