lefred's blog


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

Reduce human interaction when using an asynchronous slave to a MySQL InnoDB Cluster

A MySQL replication topology can be very complex (never underestimate a DBA’s creativity). But it’s very frequent to use an asynchronous slave from your primary database to run reporting or logical backup… or any kind of read workload you need. It can also be used as delay slave for data restore purpose. Once you decided to provide HA to your … Read More


MySQL Team speaking at Percona Live Dublin 2017

From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of … Read More


MySQL Group Replication: read your own write across the group

Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ? The usual (and easier) answer to this particular question is to read on … Read More


ProxySQL and MySQL 8.0.2 (la suite)

Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr This blog post was related to the change we implemented in the Group Replication’s monitoring (performance_schema tables) and how sys schema should be changed to modify the view used by ProxySQL according. However, I used my labs machines that I was using for different purposes too … Read More


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


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories