lefred's blog


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

MySQL Group Replication: understanding Flow Control

When using MySQL Group Replication, it’s possible that some members are lagging behind the group. Due to load, hardware limitation, etc… This lag can become problematic to keep good certification behavior regarding performance and keep the possible certification failure as low as possible. Bigger is the applying queue bigger is the risk to have conflicts with those not yet applied … Read More


MySQL InnoDB Cluster: Automated Installation with Puppet

We saw yesterday that the new MySQL Shell was out and how we could create a MySQL InnoDB Cluster manually using the Shell. Today, I would like to show you how easy it is to create recipes to automate all the process. I have created a Puppet module that can be used as Proof-of-concept (You might need more features to … 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 Limitations: savepoints

Today in our series of articles related to MySQL Group Replication’s limitations, let’s have a quick look at Savepoints. The manual is clear about this: Transaction savepoints are not supported. The first thing to check then is if the application that will use our MySQL Group Replication Cluster is currently using savepoints. We have two ways to find this, 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


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories