MySQL 8.3: Purging data from your InnoDB Cluster
Maintaining a production dataset at a manageable size can present a considerable challenge during the administration of a MySQL InnoDB Cluster.

Old Days

Back in the day when we only had one main copy of our data (the source), and one read copy (the replica) that we used to look at current and old data f
https://lefred.be/content/mysql-8-3-purging-data-from-your-innodb-cluster/
#83 #GroupReplication #InnoDBCluster #MySQL #Replication

MySQL 8.3: Purging data from your InnoDB Cluster

Maintaining a production dataset at a manageable size can present a considerable challenge during the administration of a MySQL InnoDB Cluster. Old Days Back in the day when we only had one main co…

lefred blog: tribulations of a MySQL Evangelist

MySQL Shell AdminAPI: different ways to call the commands… same effect?
During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell.

He wanted to know why, in the manual and blogs, we always use separate commands instead o
https://lefred.be/content/mysql-shell-adminapi-different-ways-to-call-the-commands-same-effect/
#InnoDBCluster #MySQL #MySQLShell

MySQL Shell AdminAPI: different ways to call the commands… same effect?

During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell. He…

lefred blog: tribulations of a MySQL Evangelist
How to get client’s IP address when using MySQL Router ?
When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn't connect directly to the back-end server(s). The proxy usually understands the p
https://lefred.be/content/how-to-get-clients-ip-address-when-using-mysql-router/
#8.0 #HA #InnoDBCluster #InnoDBReplicaSet #MySQL #MySQL8.0 #Performance_Schema #Router
How to get client’s IP address when using MySQL Router ?

When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn’t connec…

lefred blog: tribulations of a MySQL Evangelist