lefred's blog


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

MySQL Group Replication: who is the primary master – updated!

Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the visibility of Group Replication extending the performance_schema tables (see his article). Thanks to these improvements, it’s now very easy to … Read More


MySQL Group Replication is sweet… but can be sour if you misunderstand it ;-)

Recently, my friend Marco Tusa(MySQL Daddy or the Grinch) wrote his first impression on MySQL Group Replication (part of InnoDB Cluster). And his conclusion was not that positive. But when I analyze his setup, I understand that his assumptions were not so right. Let's try to explain what were the issues and why his test wasn't correct. Before commenting Marco's … Read More


MySQL 8.0.2 is out, some change is required to still use ProxySQL with GR

As you may know by now, MySQL 8.0.2 DMR is out ! \o/ Many features have been added (see Geir Høydalsvik‘s announcement) and of course the replication also brought new features and improvements (see this post from Luís Soares). But some improvements in the monitoring broke the added sys view used by ProxySQL to monitor the state of a member … Read More


BuzzConf is looking for technologists, innovators and entertainers!

MySQL is proud to announce that we are going to support and actively attend a very unique event BuzzConf in Australia. It’s hold on December 1-3, 2017 in Phoenix Park, AU. BuzzConf is a family-friendly technology festival with a really unique atmosphere – all participants and presenters spend the weekend together in country Victoria, learning and playing with tech during … Read More


MySQL Group Replication: understanding Flow Control

When using MySQL Group Replication, it’s possible that some members are lagging behind the group. Due to load, hardware limitation, etc… This lag can become problematic to keep good certification behavior regarding performance and keep the possible certification failure as low as possible. Bigger is the applying queue bigger is the risk to have conflicts with those not yet applied … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories