MySQL & Amazon RDS integration with ArchiveMaster
ArchiveMaster integrates with MySQL & Amazon RDS in the free version of ArchiveMaster, with more options on Pro.
ArchiveMaster can write archived WooCommerce orders to a MySQL database you choose instead of the WordPress database. That can be a second database on the same server or a remote one such as Amazon RDS. The free version supports a remote database you configure; Pro adds a custom MySQL target with its own credentials.
MySQL & Amazon RDS × ArchiveMaster
About MySQL & Amazon RDS
Visit the MySQL & Amazon RDS website
MySQL & Amazon RDS is a third-party product.
What you get with ArchiveMaster
Keeps old orders in a database of your choosing, with search and restore from the WordPress admin.
- Remote database archiving is available in the free version
- Pro adds a custom MySQL server, same host or external
- Archived orders can be exported as JSON, XML or CSV
How to set up MySQL & Amazon RDS with ArchiveMaster
Typical setup time: 10 minutes.
- 1
Create an empty database and a user with read and write access on the target MySQL server.
- 2
In ArchiveMaster, open Settings > Storage and choose the database option.
- 3
Enter the host, port, database name, user and password, then test the connection.
- 4
Point an archive rule at the database and run it.
What data moves
| Data | Direction |
|---|---|
| Archived orders | WooCommerce to the target database |
| Exports | JSON, XML, CSV on Pro |
Requirements
- A MySQL database reachable from the web server
- ArchiveMaster free for remote database archiving, Pro for a custom MySQL target
Use cases
Separate reporting database
An agency archives client orders to an RDS instance that their BI tool reads from, keeping heavy reports away from the live store.
Compliance retention
A store must keep orders for several years. Old orders live in a dedicated database with its own backups while the live store only holds the current years.
MySQL & Amazon RDS integration FAQ
Does the archive database need the WordPress schema?
Can I archive to the same server as WordPress?
Can I move an archive back to local storage later?
More ArchiveMaster integrations
All ArchiveMaster integrationsGoogle Drive
Adds Google Drive as a storage destination next to local storage and remote MySQL.
WooCommerce
Archives orders by date range or status to local storage, a remote MySQL database or Google Drive, and restores them when needed.
WooCommerce Subscriptions
Skips any order tied to an active subscription so renewals, cancellations and refunds keep working.
Connect MySQL & Amazon RDS with ArchiveMaster
Start with the free plugin from WordPress.org, then upgrade when you need more.