Author: Archita Chauhan

Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to manage index visibility. MySQL 8.0 supports invisible indexes, that is, indexes not used by the optimizer. This feature applies to indexes other…

Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the INSERTs, UPDATEs, and DELETEs operations become. Indexes in MySQL—or for that matter, any database—are never static. Each time you modify…

Overview of ISSUE: This post is regarding a scenario where the pt-osc command breaks replication and how to prevent that. If you are running a pt-osc command on a primary instance and it has replicas under it with existing replication…

This month’s postcard comes to us from India. This is our first Pythia—aka one of the women of Pythian—spotlight of 2022. What better way to celebrate National Women’s History Month? Read on to learn more about database administrator Archita Chauhan….

Often it is necessary to convert an unencrypted RDS instance into an encrypted one. And it is usually expected that this process is done with minimum or no downtime. Unfortunately, one can only enable encryption when the instance is created. However,…