by Santhinesh Nagendran | May 29, 2023 | 8.0, Innodb, MySQL
What is the clone Plugin ?Enable the Clone PluginDefining the Donor nodesWhat privileges do you need for cloning ?How to monitor Cloning process ?Start the cloning processClone Progress and status monitoringRe-establishing the replication with the donor nodeLimitation...
by Santhinesh Nagendran | May 8, 2023 | KnowledgeBase, MySQL
What is MySQL ReplicaSet ?Environment OverviewMandatory Configuration Needed for ReplicaSetMySQLShell Pre-checksConfigure both the nodes using dba.configureReplicaSetInstance()Ways of Setting up ReplicaSetReplicaSet From ScratchAdopting an existing GTID based...
by Santhinesh Nagendran | May 5, 2023 | General, KnowledgeBase, MySQL
What is Primary Key ?Issues due to tables without primary keyHow do we end up creating tables without primary key by mistake ?Performance issues caused by tables missing primary key ?How can we find the tables without primary key ?How can we restrict creation of...
by Santhinesh Nagendran | May 3, 2023 | AWS RDS, Case Study, MySQL
Is Scaling/Autoscaling a blessing or curse ? There might be situations where we might have over provision resources ahead of time while capacity planning or resource planning in the initial stages of any application where we really can’t anticipate how much...
by Santhinesh Nagendran | Apr 28, 2023 | MySQL
We have come across several incidents where update stats have influenced a different choices of indexes causing the change in the execution plan which indeed degrades the query performance. Some of the most frequently asked questions about stats during those incident...