lefred's blog


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

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


MySQL Group Replication: who is the primary master ??

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 member of the group is the Primary-Master ? Of course you could check which one is not in read_only: mysql2 … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories