After configuration, the master databases are configured as follows:
- Main magento database: 250 tables
- Magento checkout database: 10 tables
- Magento OMS database: 54 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 |
---|---|
Checkout database is working | Add items to a cart. Verify that rows have been added to your checkout database's quote , quote_address , and quote_item tables. |
OMS database is working | Complete an order (any payment method, including check/money order). Verify that rows have been added to your OMS database's sales_order_address , sales_order_item , and sales_order_payment tables. |
Find us on