Magento 2.x CE Master-Slave MySQL

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

Re: Magento 2.x CE Master-Slave MySQL

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.

Manish Mittal
https://www.manishmittal.com/

View solution in original post

Re: Magento 2.x CE Master-Slave MySQL