group | title | ee_only | functional_areas | redirect_to | status | |||
---|---|---|---|---|---|---|---|---|
configuration-guide |
Verify split databases |
true |
|
migrated |
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]({{ page.baseurl }}/install-gde/prereq/optional.html#install-optional-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. |
{:.bs-callout-warning}
You must back up the two additional database instances manually. Magento backs up only the main database instance. The [magento setup:backup --db
]({{ page.baseurl }}/install-gde/install/cli/install-cli-backup.html) command and Admin options do not back up the additional tables.
{:.ref-header} Related topics
[Set up optional database replication]({{ page.baseurl }}/config-guide/multi-master/multi-master_slavedb.html)