Clustring magento 2 community, for scalability

[sadegh_ebadollahi]

Hi guys,

I know the clustering for DB is built-in only on the Magento 2 commerce, but I want to know could I build this feature on the Magento 2 community?

[Manthan Dave]

Hi @sadegh_ebadollahi

Yes - you are correct , this feature is only available in commerce edition (Enterprise edition).

Because in enterprise edition magento has developed module for this functionality called split:db

so if you wanted to achieve this in open source edition , then you must need to create a custom module for that.

[sadegh_ebadollahi]

Nobody except Magento team has developed this module (split:db)?

[Manthan Dave]

Hi @sadegh_ebadollahi

Well based around my experience and the research  i have done so far , i am not able to find any third - party extension which does the  same functionality which magento EE split database module do . in-fact i am not able to found any module for that .

so my answer is yes - as of now there is no open source module to achieve that for magento 2.

might be you will find for Magento 1 but magento2  there is no module.

hope it helps ! if its helps you please click on kudos and accept as solution

[MagenX]

you can use mysqlrouter as a simple solution, just to test your mysql/pxc cluster working,

or you can use more advanced:

http://www.proxysql.com/compare

configuring proper pxc cluster is up to you.