Reading list Switch to dark mode

    Magento 2 Multi Vendor Split Database

    With the help of the Magento 2 Multi Vendor Split Database module, the store owner can split the Magento master database into two parts. One for the Magento and the second for the marketplace.

    Two master databases will be created for better scalability and performance advantage.

    Please Note –

    1. This module is an add-on to Magento 2 Marketplace Module. To use this module you must have installed Webkul Magento 2 Marketplace Module first.

    2. The Module will split the database of Magento and Marketplace only, there will be no splitting of the database of Marketplace add-ons.

    Searching for an experienced
    Magento 2 Company ?
    Read More


    • Admin can configure a different database for marketplace tables
    •  All read-write operation will work between multiple databases
    • CLI command to split databases
    • Any module having direct SQL queries for the marketplace module tables will not work
    • Enhance the user experience and website performance


    Customers will get a zip folder and they have to extract the contents of this zip folder on their system. The extracted folder has an src folder, inside the src folder you have the app folder. You need to transfer this app folder into the Magento2 root directory on the server as shown below.


    After the successful installation, you have to run these commands in the Magento2 root directory.

    First Command – 

    php bin/magento setup:upgrade

    Second Command – 

    php bin/magento setup:di:compile

    Third Command – 

    php bin/magento setup:static-content:deploy

    After running the commands, you have to flush the cache from the Magento admin panel by navigating through “System->Cache Management” as shown below.


    Admin Configuration

    Note: Before doing any operation on a database, Take a complete backup of your Magento store database.

    Create New Database –

    After the installation, First, you need to create a new database for marketplace tables. As per the below image assumed magento2db is your default Magento 2 store database & magento2mpdb is created for marketplace tables.

    Run Table Split Command –

    After creating the different database, you need to run below Command to split the marketplace database tables –

    php bin/magento setup:db-schema:split-marketplace --host=HOST --dbname=DATABASE_NAME --username=DATABASE_USERNAME  --password=PASSWORD

    Split Database Tables –

    After running the above command the database tables will be split and transfer into the marketplace database as per the below image – webkul-magento2-marketplace-split-database-transfer-tables

    That’s all for Magento 2 Marketplace Split Database, still have any issue feel free to add a ticket and let us know your views to make the module better

    Current Product Version - 5.0.2

    Supported Framework Version - Magento 2.0.x, 2.1.x, 2.2.x,2.3.x, 2.4.x

    Blog Version - Magento 2.0.x, 2.1.x, 2.2.x,2.3.x, 2.4.x
    • Version 2.0.x, 2.1.x. 2.2.x
    • Version 2.0.x, 2.1.x. 2.2.x, 2.3.x, 2.4.x
    . . .
    Add a comment

    Leave a Comment

    Your email address will not be published. Required fields are marked*

    Be the first to comment.

    Back to Top
    Very helpful and super fast support from Abhishek. Much appreciated for your help. He is very helpful and keen to resolve the issue.
    Emma Nguyen
    Talk to Sales


    Live Chat

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home

    Table of Content