No image

AWS RDS Read Replicas for Magento

AWS MySQL / Aurora Read Replicas for Magento and WordPress

S3Sonic Overview

As part of our S3 Titanium Series for Magento OSE, and to compliment our S3R-Alpha S3 media module, we have our S3Sonic Module to offer easy on-the-fly RDS Read Replica provisioning for AWS RDS instances.

Our S3Sonic High-Availability module will allow the configuration and use of AWS Database Read Replicas from the Magento 2.2.5+ admin console.

Read Replicas allow offloading database queries from the master Database RDS instance, and then distribution among the AWS MySQL/Aurora RDS read replicas. Overall this type of configuration will increase throughput, performance, and add database redundancy.

Additionally, should the master database go offline for any reason, a read replica can simply be promoted to the new read/write Master in a few minutes, and all without data loss.

aMiSTACX Magento 2 AWS RDS Read Replicas S3Sonic

S3Sonic Configuration

Any S3 Titanium stack, and any designated Developer stack will allow the use of the S3Sonic module. Please reference your stack guide for more information, or contact support for assistance with Developer stacks and installation.

For Magento, prior to operation, make sure you have the latest version installed.

From CLI:

cd /var/www/magento

sudo composer update Amistacx/S3Sonic

sudo ./ #make the file “X” executable if required.

S3Sonic and SSL/TLS for RDS

A new feature for S3Sonic in 2020 is the ability to easily add encryption from the Magento EC2 to the AWS RDS instance. This extra piece of security helps thwart sniffing between the multiple endpoints. A must if you need to have your RDS set to “Public”.

S3Sonic SSL/TLS Configuration for Magento 2 and AWS RDS

Step 1. Set SSL to “YES”

Step 2. Upload your AWS RDS PEM file.

S3Sonic Versions

  • 2.1.0 : 2020-01-17
    Support for Firebear_ImportExport
  • 2.0.9 : 2020-01-14
    Possibility to enable/disable the module from admin dashboard
    Possibility to enable/disable logging from admin dashboard
    SSL Support
    Uploading SSL CA from admin dashboard.
    Extended SSL CA validation.
    Compatability with Magento 2.3.3
    Adminhtml area supporting .
  • 2.0.8 : 2019-12-12
    New license key (Support for G5).

S3Sonic & AWS Auto Scale

Used in conjunction with our S3R-Alpha module, and an AWS auto scale group, your Magento 2.2.x+ implementation will be bulletproof.  That’s why we call it our S3 Titanium series.


Weaponize your Business with aMiSTACX!