lefred's blog


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

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


MySQL Document Store: creating generated columns like a boss ;)

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. This is the full presentation: Introduction to MySQL Document Store from Frederic Descamps Then somebody came with a nice question. … Read More


Howto make MySQL point-in-time recovery faster ?

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 until an event that you would like that has never happened). For example, a user did a mistake and you … Read More


MySQL Group Replication and logical backup

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 all the tables on the member you are taking the dump. Indeed, a single transaction can’t be used as savepoints … Read More


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


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories