lefred's blog


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

From MySQL 5.6 partitioning to 5.7 and beyond

As you may already know,  since MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is completely removed in MySQL 8.0. So now, in MySQL 5.7, the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Currently, only the InnoDB and NDB storage engines do. MySQL 5.7 supports generic … 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


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


recent

Last Tweets Last Tweets

    Locations of visitors to this page
    categories