Alok Pathak, Author at Percona Database Performance Blog Fri, 02 Feb 2024 23:47:39 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png Alok Pathak, Author at Percona Database Performance Blog 32 32 76301791 Amazon RDS MySQL Minor Upgrades: Not So Fast! https://www.percona.com/blog/amazon-rds-mysql-minor-upgrades-not-so-fast/ Tue, 14 Jan 2020 13:56:47 +0000 https://www.percona.com/blog/?p=64527 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 upgrade” or modify the DB instance and schedule the upgrade to […]]]> 64527 Amazon RDS Multi-AZ Deployments and Read Replicas https://www.percona.com/blog/amazon-rds-multi-az-deployments-read-replicas/ https://www.percona.com/blog/amazon-rds-multi-az-deployments-read-replicas/#comments Thu, 02 Aug 2018 12:37:53 +0000 https://www.percona.com/blog/?p=51296 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 both?”.  I have tried to answer this question in this […]]]> https://www.percona.com/blog/amazon-rds-multi-az-deployments-read-replicas/feed/ 3 51296 Migrating MySQL Users to Amazon RDS https://www.percona.com/blog/migrating-mysql-users-to-amazon-rds/ https://www.percona.com/blog/migrating-mysql-users-to-amazon-rds/#comments Thu, 08 Mar 2018 19:49:20 +0000 https://www.percona.com/blog/?p=48338 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 not provide shell access to the underlying operating system. It also restricts […]]]> https://www.percona.com/blog/migrating-mysql-users-to-amazon-rds/feed/ 1 48338 Using dbsake to recover table structure from .frm files and process mysqldump output https://www.percona.com/blog/recovering-table-structure-from-frm-files-using-dbsake/ https://www.percona.com/blog/recovering-table-structure-from-frm-files-using-dbsake/#comments Wed, 16 Dec 2015 20:34:10 +0000 https://www.percona.com/blog/?p=32679 https://www.percona.com/blog/recovering-table-structure-from-frm-files-using-dbsake/feed/ 2 32679 Identifying Useful Info from MySQL Row-Based Binary Logs https://www.percona.com/blog/identifying-useful-information-mysql-row-based-binary-logs/ https://www.percona.com/blog/identifying-useful-information-mysql-row-based-binary-logs/#comments Tue, 20 Jan 2015 15:34:22 +0000 https://www.percona.com/blog/?p=28039 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 logs and a simple awk script.MySQL Row-Based Binary […]]]> https://www.percona.com/blog/identifying-useful-information-mysql-row-based-binary-logs/feed/ 13 28039