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 […]
This blog post will give a brief overview of Amazon RDS capabilities and limitations, and how Percona Support can help you succeed in your Amazon RDS deployments.
One of the common questions that we get from customers and prospective customers is about Percona Support with Amazon RDS. As many companies have shifted to the cloud, […]
