Magento 2.0.18 is the final 2.0.x release. After March 2018, Magento 2.0.x will no longer receive security patches, quality fixes, or documentation updates.
To maintain your site's performance, security, and PCI compliance, upgrade to the latest version of Magento.
Magento Commerce only

Verify split databases

After configuration, the master databases are configured as follows:

  • Main magento database: 250 tables
  • Magento quote database: 10 tables
  • Magento sales 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
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 Magento Admin options do not back up the additional tables.

Next step (optional)

Set up optional database replication