Performance_Schema is used most of the time to get metrics about queries and connections. But it can also provide other very useful information. So today, I will show you how you can see a list of users that didn’t connect to MySQL since we restarted it (since last reboot). SELECT DISTINCT mu.user FROM mysql.user mu LEFT JOIN performance_schema.users psu ON … Read More
After having explained how to achieve HA for MySQL Router for people who doesn’t want to install the MySQL Router on the application servers and after having illustrated how to use Pacemaker, this article explains how to setup HA for MySQL Router using keepalived. Keepalived is very popular, maybe because it’s also very easy to use. We can of course … Read More
This article will explain how to setup HA for MySQL Router as described in a previous article about where should the router stand. For this setup, I will use Pacemaker (part of RedHat High Availability Add-on and available on RHEL, CentOS, Oracle Linux, …). Of course we need a MySQL InnoDB Cluster but we won’t really use it for the … Read More
As you know, MySQL InnoDB Cluster is composed of 3 elements: a group replication cluster of at least 3 servers the MySQL Shell used to manage the cluster the MySQL Router that send the traffic from the application server(s) to the cluster When presenting the solution in conferences, one the main question is Where should I put the router ? … Read More
Recently during my several talks and trips to meet the MySQL Community and MySQL InnoDB Cluster, I realized that some important message was missing. I got a lot of questions about which version of Router or Shell people should use. There is some confusion about which version to use, it seems that people thinks they should use MySQL Shell 1.0.x … Read More
comments