The split database feature was deprecated in version 2.4.2 of Adobe Commerce. See Revert from a split database to a single database.
PHP 7.3 reached end of support in December 2021 and Adobe Commerce 2.3.x reaches end of support in September 2022. You may want to consider planning your upgrade now to Adobe Commerce 2.4.x and PHP 7.4.x to help maintain PCI compliance.
Adobe Commerce only. Learn more.

Verify split databases

After configuration, the master databases are configured as follows:

  • Main magento database: 369 tables
  • Magento quote database: 11 tables
  • Magento sales database: 55 tables

To verify your split databases are working properly, perform the following tasks and verify that data is added to the database tables using a database tool like phpmyadmin:

What to verify How to verify
quote database is working Add items to a cart. Verify that rows have been added to your quote database's quote, quote_address, and quote_item tables.
sales database is working Complete an order (any payment method, including check/money order). Verify that rows have been added to your sales database's sales_order_address, sales_order_item, and sales_order_payment tables.

You must back up the two additional database instances manually. Magento backs up only the main database instance. The magento setup:backup --db command and Admin options do not back up the additional tables.

Related topics

Set up optional database replication