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…
The MySQL Community team will be supporting the following events during the summer and we will be present at some of them ! Please come to visit us ! Northeast PHP August 9-11, 2017, Charlottetown, PEI Canada We are happy…
Last Thursday, I was introducing MySQL Document Store in Ghent, BE at Percona University. I was explaining how great is this technology and how MySQL can replace your NoSQL database but still provides you all the benefits from a RDBMS.…
Before explaining how you can improve the speed for performing point-in-time recovery, let’s recall what is Point-In-Time Recovery and how it’s usually performed. Point-in-Time Recovery, PTR Point-In-Time recovery is a technique of restoring your data until a certain point (usually…
MySQL InnoDB Cluster (or only Group Replication) becomes more and more popular. This solution doesn’t attract only experts anymore. On social medias, forums and other discussions, people are asking me what it the best way to migrate a running environment…
Today I presented MySQL InnoDB Cluster at the Helsinki MySQL User Group. To demonstrate how easy it’s to deploy a cluster with MySQL Shell and used the prompt that will be part of a future release just because it’s…
Taking a logical backup of a member of a Group Replication Cluster is not something very easy. Currently (5.7.17, 5.7.18 or 8.0.0) if you want to use mysqldump to take a logical backup of your dataset, you need to lock…
Time is running out to submit a talk for OpenWorld 2017 that will table place on October 1–5, 2017 in San Francisco, CA. If you are looking for inspiration on what talk to submit, we encourage you to submit a…
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…
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…
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…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.