lefred's blog

There Are 10 Types of People in the World....

MySQL Group Replication: native support in ProxySQL

ProxySQL is the leader in proxy and load balancing solution for MySQL. It has great features like query caching, multiplexing, mirroring, read/write splitting, routing, etc… The latest enhancement in ProxySQL is the native support of MySQL Group Replication. No more need to use an external script within the scheduler like I explained in this previous post. This implementation supports Groups … Read More

MySQL Group Replication: who is the primary master ??

As you know, MySQL Group Replication runs by default in single primary mode. mysql2 mysql> show global variables like ‘group_replication_single_primary_mode’; +—————————————+——-+ | Variable_name | Value | +—————————————+——-+ | group_replication_single_primary_mode | ON | +—————————————+——-+ But how can we easily find which member of the group is the Primary-Master ? Of course you could check which one is not in read_only: mysql2 … Read More

Jeudis du Libre – Mons

Yesterday I was invited to speak at the “Jeudis du Libre” in Mons. The location was very special as it was in one auditorium of Polytech, the oldest university in the city of Mons. I presented in French two very hot topics in the MySQL ecosystem: MySQL InnoDB Cluster MySQL as Document Store with JSON datatype & X plugin Those … Read More

MySQL InnoDB Cluster: MySQL Shell starter guide

 Earlier this week,  MySQL Shell 1.08 has been released. This is the first Release Candidate of this major piece of MySQL InnoDB Cluster. Some commands have been changed and some new ones were added. For example the following useful commands were added: dba.checkInstanceConfiguration() cluster.checkInstanceState() dba.rebootClusterFromCompleteOutage() So let’s have a look on how to use the new MySQL Shell to create … Read More

MySQL Group Replication: about ack from majority

The documentation states that “For a transaction to commit, the majority of the group have to agree on the order of a given transaction in the global sequence of transactions.” This means that as soon as the majority of nodes member of the group ack the writeset reception, certification can start. So, as a picture is worth a 1000 words, … Read More


Last Tweets Last Tweets

Locations of visitors to this page