Wordpress integration with Query Pilot

Readyset Query Pilot is fully compatible with Wordpress and capable of taking a significant amount of load off your database by utilizing Readyset query cache.

Prerequisites

In order to run Readyset cloud, you must have following already configured.

• Wordpress installation
• Access to your wordpress admin console
• Access to your wordpress config file (wp-config. php)
• MySQL credentials
• MySQL database should be accessible by Readyset via public access or VPC sharing

Steps

1. Install the Readyset plugin

Readyset is working out of the box with Wordpress without any configuration changes. However, in order to optimize the query caching performance, we have written a wordpress plugin. This plugin would rewrite some deprecated SQL queries. (Ex: https://dev.mysql.com/worklog/task/?id=12615 (opens in a new tab))

Follow these steps to install the plugin.

1. Download wordpress-readyset-plugin.zip to your computer.

2. Login to your wordpress administrator account.

3. Navigate to the Plugin section.

4. Click on Add Plugin, then the Upload Plugin button and select the downloaded zip file.

5. Clicking on Install Now would start the installation process. Once the plugin is installed, Activate the plugin by clicking on the Activate Plugin button.

2. Configure Readyset Query Pilot cloud

You can configure Readyset Query Pilot cloud version through the cloud creation wizard in Readyset cloud.

First, login to your Readyset cloud account and create a new cluster. Select QueryPilot as the cluster type.

Select the AWS region of your RDS database. If your RDS is in a private VPC network, you can follow these instructions to set up the VPC peering connection between QueryPilot and your database: https://readyset.io/docs/cloud/vpc-peering (opens in a new tab)

Enter your MySQL credentials.

We recommend increasing the number of queries in Query Pilot settings to 30 for wordpress installations.

Enable Full Materialization and Mixed Comparisons under advance dataflow options.

3. Point your wordpress installation to use the Readyset cloud

Once the Readyset cloud is finished deploying, you will see a new database host in the Readyset URL.

Change your wp-config.php to use the Readyset URL for DB_HOST.

define( 'DB_HOST', 'your-readyset-host' );

Final step - Resume your application traffic

Your wordpress installation is now pointing to Readyset Query Pilot, and queries should automatically cache and improve your performance.