Set up additional master databases

Create checkout and OMS master databases as follows:

  1. Log in to your database server as any user.

  2. Enter the following command to get to a MySQL command prompt:

    mysql -u root -p
    
  3. Enter the MySQL root user’s password when prompted.

  4. Enter the following commands in the order shown to create database instances named magento_quote and magento_sales with the same usernames and passwords:

    create database magento_quote;
    
    GRANT ALL ON magento_quote.* TO magento_quote@localhost IDENTIFIED BY 'magento_quote';
    
    create database magento_sales;
    
    GRANT ALL ON magento_sales.* TO magento_sales@localhost IDENTIFIED BY 'magento_sales';
    
  5. Enter exit to quit the command prompt.

  6. Verify the databases, one at a time:

    Checkout database:

    mysql -u magento_quote -p
    
    exit
    

    Order management system database:

    mysql -u magento_sales -p
    
    exit
    

    If the MySQL monitor displays, you created the database properly. If an error displays, repeat the preceding commands.

Configure Commerce to use the master databases

After setting up a total of three master databases, use the command line to configure Commerce to use them. (The command sets up database connections and distributes tables among the master databases.)

First steps

See Running commands to log in and run CLI commands.

Configure the checkout database

Command syntax:

bin/magento setup:db-schema:split-quote --host="<checkout db host or ip>" --dbname="<name>" --username="<checkout db username>" --password="<password>"

For example,

bin/magento setup:db-schema:split-quote --host="localhost" --dbname="magento_quote" --username="magento_quote" --password="magento_quote"

The following message displays to confirm a successful setup:

Migration has been finished successfully!

Configure the OMS database

Command syntax:

bin/magento setup:db-schema:split-sales --host="<checkout db host or ip>" --dbname="<name>" --username="<checkout db username>" --password="<password>"

For example,

bin/magento setup:db-schema:split-sales --host="localhost" --dbname="magento_sales" --username="magento_sales" --password="magento_sales"
bin/magento setup:upgrade

The following message displays to confirm a successful setup:

Migration has been finished successfully!
Previous pageSplit database overview
Next pageManual configuration

Commerce