The slides of my talk on best practices to monitor large scale MySQL deployments, are now available for download. This slide was presented during Percona Live 2016. Monitoring MySQL at scale [//www.slideshare.net/ovaistariq/monitoring-mysql-at-scale] from Ovais Tariq [https:
MySQL
A collection of 31 posts
Extend MySQL Master HA (MHA) capabilities with MHA Helper
I have used many tools starting with MMM to be able to manage MySQL replication clusters. Some of the tools need more tools and complex HA solutions such as Pacemaker and Corosync, or Zookeeper. While other tools do not do
Beware of MySQL BLOB Corruption in Older Versions
Does your dataset consist of InnoDB tables with large BLOB data such that the data is stored in external BLOB pages? Was the dataset created in MySQL version 5.1 and below and without using the InnoDB plugin, or with
Nasty MySQL Replication Bugs that Affect Upgrade to 5.6
There were two nasty MySQL replication bugs in two different 5.6 releases that would make it difficult to upgrade slaves to MySQL 5.6 while still connected to MySQL 5.5 master. The first of those bugs is MySQL
Percona XtraDB Cluster - A Drop-in-place Clustering Solution for MySQL
Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to
InnoDB scalability issues due to tables without primary keys
Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability issues. Hence there was another one I wanted to highlight: Scalability issues due to tables without primary keys. This scalability
Implications of Metadata Locking Changes in MySQL 5.5
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes
Join Optimizations in MySQL 5.6 and MariaDB 5.5
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced
Subscribe to ovais.tariq - tech and leadership
Subscribe today and get access to a private newsletter and new content every week!