Verify split database
Last update: May 16, 2023
- Topics:
- Configuration
CREATED FOR:
- Experienced
- Admin
- Developer
This feature is available for Adobe Commerce instances only.
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. |
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.Previous pageManual configuration
Next pageDatabase replication
Commerce
- Overview
- General setup
- Deployment
- Cache
- Command Line
- Command-line tool
- Common commands
- Enable logging
- Manage the cache
- Manage indexers
- Configure cron jobs
- Compile code
- Operation mode
- Start message queue consumers
- URN highlighter
- Dependency reports
- Localization
- Configuration management
- Static view
- Create symlinks
- Run unit tests
- Convert layout files
- Generate data for performance testing
- Run support utilities (Commerce only)
- Configuration files
- Configuration paths
- Cron Jobs
- Logs
- Message Queues
- Multiple sites
- Search Engine
- Security
- Storage
- Return to Operational Guides