by Alok Pathak | Jan 14, 2020 | Cloud, Insight for DBAs, MySQL
The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor... by Alok Pathak | Aug 2, 2018 | Cloud, Insight for DBAs, MySQL
Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the common questions that we get is “What is Multi-AZ and how it’s different from Read Replica, do I need... by Alok Pathak | Mar 8, 2018 | Cloud, MySQL, Percona Software
In this blog post, we’ll look at what is needed when migrating MySQL users to Amazon RDS. We’ll discuss how we can transform MySQL user grants and make them compatible with Amazon RDS. In order to deliver a managed service experience, Amazon RDS does... by Alok Pathak | Dec 16, 2015 | Insight for DBAs, MySQL
We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel Nieto about how we can recover structures from... by Alok Pathak | Jan 20, 2015 | Insight for DBAs, MySQL
As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary logs – and there are a number of reasons for doing that. In this post, I’ll explain how you can get the important information about your write workload using MySQL row-based binary...