As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is:
AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined maintenance window, provided you have one.
If you don’t have […]
In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency.
Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant […]
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of running pt-table-checksum to verify data consistency between a […]
Read more
Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily: When should I use Aurora and when RDS MySQL?
DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure and without installing software. But when trying to find out which […]
Join Percona Technical Account Manager Tim Sharp, Percona Senior MySQL DBA for Managed Services Dov Endress, and Lookout Director of Engineering Michael Fortson as they present Best Practices When Right-Sizing Your Aurora Footprint on Thursday, December 14, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8).
Level: Basic
Tags: DBA, MySQL, Cloud, AWS, Lookout, Percona […]
