In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs. This part, is about what Performance_Schema and SYS can provide us about the queries hitting the MySQL database. Currently, 3 methods are available: getSlowerQuery() getQueryTempDisk() getFullTableScanQuery() The method’s name should be self explaining. This is an overview of the parameters … Read More
This blog was initially referring to the audit plugin, but I renamed it as check plugin to be more compatible with all the current and future methods included in it. As you may know, it’s now possible to create your own plugins for MySQL Shell. See the following posts: https://lefred.be/content/overview-on-mysql-shell-8-0-17-extensions-plugins-and-how-to-write-yours/ https://lefred.be/content/mysql-router-8-0-17s-rest-api-mysql-shell-extensions/ https://lefred.be/content/how-to-integrate-proxysql-in-mysql-innodb-cluster/ https://lefred.be/content/mysql-innodb-disk-space/ I’ve created several plugins that you can … Read More
This article is an update of a previous post explaining how to setup a second cluster on a second data center to be used as disaster recovery (or to run some off site queries, like long reports, etc..). This new article covers also the CLONE plugin. Before you ask, CLONE plugin and Replication Channel Based Filters are only available in … Read More
Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it. I commented with an old post explaining how to get some similar info only using SQL in case you don’t have filesystem access. And finally, my friend Bill Karwin, commented how this info is not always accurate. … Read More
MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL. The solution is composed of: MySQL Server MySQL Group Replication Plugin MySQL Clone Plugin MySQL Router MySQL Shell All those components are developed and tested together to provide the easiest and best experience to the MySQL users. As the MySQL Router is a TCP Level 4 … Read More
comments