🐦 Early Bird BFCM Sale is here! Save Up to 50% · Lifetime Deals from $79 Ends in 00d00h00m00s Grab My Deal ➜

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 logo ArchiveMaster logo

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. 1

    Create an empty database and a user with read and write access on the target MySQL server.

  2. 2

    In ArchiveMaster, open Settings > Storage and choose the database option.

  3. 3

    Enter the host, port, database name, user and password, then test the connection.

  4. 4

    Point an archive rule at the database and run it.

What data moves

DataDirection
Archived ordersWooCommerce to the target database
ExportsJSON, 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?

No. ArchiveMaster creates the tables it needs in the target database on first use.

Can I archive to the same server as WordPress?

Yes. A second database on the same MySQL server works with the Pro custom MySQL option, and it still keeps the archived rows out of the WordPress tables.

Can I move an archive back to local storage later?

Restore the orders to WooCommerce, change the storage target and archive again. ArchiveMaster does not copy between storage targets directly.

Connect MySQL & Amazon RDS with ArchiveMaster

Start with the free plugin from WordPress.org, then upgrade when you need more.

×