lefred's blog


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

MySQL Challenge

The MySQL team is constantly improving and innovating the product… this time, after having put particular attention to DBAs and operators with Group Replication & InnoDB Cluster,  let’s have a look to what we can also bring to developers. Let’s start with the following challenge: Add 5 books from scratch with all their metadata (authors, isbn, edition, year, …) in … Read More


lefred.be is part of the TOP 10 MySQL Blogs

Wooohoooo ! After less than one year of dedicating my blog to MySQL, lefred.be is part of the top 10 MySQL blogs ! I’m well surrounded in the ranking by my colleagues Dave and Øystein. Thank you to all followers 😉


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


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories