Verify split database
NOTE
This feature is available for Adobe Commerce instances only.
IMPORTANT
The split database feature was deprecated in version 2.4.2 of Adobe Commerce. See Revert from a split database to a single database.
After configuration, the master databases are configured as follows:
- Main Commerce database: 369 tables
- Commerce quote database: 11 tables
- Commerce sales database: 55 tables
To verify that 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.WARNING
You must back up the two additional database instances manually. Commerce backs up only the main database instance. The
magento setup:backup --db command and Admin options do not back up the additional tables.recommendation-more-help
386822bd-e32c-40a8-81c2-ed90ad1e198c