MySQL Shell Plugins: check (part 3)
What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more. The…
Category MySQL
MySQL Shell Plugins: check (part 2)
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…
MySQL Shell Plugins: check
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…
MySQL: Check who’s trying to access data they should not
To illustrate how easy it’s to see who’s trying to access data they have not been granted for, we will first create a schema with two tables: mysql> create database mydata; mysql> use mydata mysql> create table table1 (id int…
Using MySQL Community Repository with OL 8/RHEL 8/CentOS 8
MySQL 8.0 is now part of RedHat Enterprise 8 and other distros based on it like CentOS and Oracle Linux.. This is a very good thing ! However if for any reason you want to use the latest version of…
