We don’t know why AWS RDS auto-restarts every seven days, maybe for maintenance, or just to help add some $$ to the AWS coffers. AWS recently added their nag modal to help remind AWS customers that even if they stop RDS, in seven days it is going to restart. Most of us in our busy… Continue reading [Solved!] How to prevent RDS auto-restart.
Category: MySQL
Solved! How to Enable Magento 2 Database Logging
Sometimes you just need Magento’s database to tell all, and a very easy way to accomplish this is with the following: Note: We know this works on Magento 2.3.0 Open-Source running on an aMiSTACX deployment, but we are not sure how far back it will work for Magento 2 Open-Source. From CLI: Enable cd /var/www/magento… Continue reading Solved! How to Enable Magento 2 Database Logging
AWS RDS Read Replicas for Magento and WordPress
S3Sonic Overview As part of our S3 Titanium High Availablity Series for Magento Open-Source, we introduced 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. RDS read replicas… Continue reading AWS RDS Read Replicas for Magento and WordPress
How to connect to local or AWS RDS database
This article applies to aMiSTACX deployments, and is not meant to replace our admin guide that is provided with the stack. There are several possibilities on db connections for administration purposes. In this article, we will outline GUI phpMyAdmin usage for both LAMP/LEMP and LAP/LEP [RDS Deployments] Depending on the version of your stack and… Continue reading How to connect to local or AWS RDS database
How to locate the aMiSTACX Stack Guide?
If somehow you just deployed our aMiSTACX stack for Magento or WordPress, and you come to the database part and looking for an answer to what the user/password is… Well, it’s not here. Note! You must wait on between 15 ~ 30 minutes for a CFT deployment to complete. If you are getting a prompt… Continue reading How to locate the aMiSTACX Stack Guide?
Magento 2 Crashing due to MySQL / Cron Jobs
We have come across a few instances now where a module that was not written correctly, and that made use of the Magento Cron framework caused MySQL to stop responding. When MySQL stops responding then it basically crashes Magento. Tell tale signs in various logs point to the end effect, but not the root cause.… Continue reading Magento 2 Crashing due to MySQL / Cron Jobs
AWS Debian Password Reset
How to reset the Debian Maintenance password. Reset Instructions Before you begin, copy the existing password in the file, and make a full AMI image backup. Step 1. It is easiest to proceed from SSH CLI. Step 2. Assuming you have not changed your MySQL Root Password or changed EC2 IDs please login with root mysql… Continue reading AWS Debian Password Reset