Magento 2 DB Split (Master - Slaves architecture)

CodeFarm_SplitDB

Magento 2 CE Split Database to Master and Slave

Compatible with Magento Open Source 2.3.x & 2.4.x

Features

This module provides the ability to route query from Frontend to specific MySql instance (write to master and select to slave). The module currently provides the following advantage:

Increasing performance of Frontend Store
Prevent MySql server from deadlock (SQLSTATE[40001]: Serialization failure: 1213 Deadlock)

Example Config

You need to change your enviroment config file - env.php.

Old config:

New Config:

To quick disable split database and route all query to master: bin/magento db:mode:set default
To quick enable split database and route all query to master: bin/magento db:mode:set split

If you not config, default connection will be used.

Requirements

Magento Open Source version 2.3.x or 2.4.x

Installation

Please install this module via Composer. This module is hosted on Packagist.

composer config repositories.nosense '{"type": "composer","url": "https://repo.nosense.lol"}'
composer require cdfrm/magento2-splitdb
bin/magento module:enable CodeFarm_SplitDb
bin/magento setup:upgrade

Testing

You can add log to check at: \CodeFarm\SplitDb\Adapter\Pdo\Mysql::query

Update:

use for all frontend and admin. All query after Write Query will be route to Write instance. (This will prevent latancy of Master-Slave architechture (Some performance traded here :D))

cdfrm/magento2-splitdb