lefred's blog


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

MySQL Group Replication: Videocast #1

Hi ! I’m starting a small series of videocast related to MySQL Group Replication. As I blogged earlier this year about Single-Primary or Multi-Primary Group Replication cluster, one of the limitation of using a cluster in Multi-Primary mode is the risk linked to concurrent DDLs (as ALTER STATEMENTS). In Group Replication, DDLs are not isolating the full cluster and write … Read More


MySQL Group Replication, Single-Primary or Multi-Primary, how to make the right decision ?

Today’s blog post is related again to MySQL Group Replication. By default MySQL Group Replication runs in Single-Primary mode. And it’s the best option and the option you should use. But sometimes it might happen that in very specific cases you would like to run you MGR Cluster in Multi-Primary mode: writing simultaneously on all the nodes member of the … Read More


MySQL Group Replication and table design

Today’s article is about the first two restrictions in the requirements page of the manual: InnoDB Storage Engine: data must be stored in the InnoDB transactional storage engine. Primary Keys: every table that is to be replicated by the group must have an explicit primary key defined. So the first requirement is easy to check by a simple query that … Read More


How to migrate from Galera Cluster to MySQL Group Replication

In this article, I will show you how it’s possible to perform an online migration from a 3 members Galera cluster setup (in this case I’m using PXC 5.7.14) to a 3 members MySQL Group Replication cluster setup (MySQL Community 5.7.17). Don’t forget that before adopting Group Replication as database backend, you should validate that your application do match GR … Read More


MySQL datamasking using ProxySQL

Percona Live Amsterdam is just finished… there was an entire room full day about MySQL 8.0 which is wonderful but there was also another product that everybody was talking about: ProxySQL (great job René). Ronald Bradford and the MySQL engineering team were discussing about what tool was missing in the MySQL ecosystem and Mark Leith highlighted that a datamasking utility … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories