Buy Now

Magento 2 Marketplace Split Database

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

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

Please Note – This module is an add-on of Magento 2 Marketplace Module. To use this module you must have installed Webkul Magento 2 Marketplace Module first.

Features

  • 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

Installation

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 – 

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 https://webkul.uvdesk.com

Current Product Version - 2.0.0

Supported Framework Version - 2.0.x, 2.1.x. 2.2.x

. . .

Comment

Add Your Comment

Be the first to comment.

css.php

Index