lefred's blog


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

TOP 10 MySQL 8.0 features for developers

MySQL 8.0 RC2 has just been released with a lot of new features compared to MySQL 5.7. In this blog post, I will list the top 10 new features that should excite developers. These functionalities are presented in descending order of preference of our MySQL Community. TOP 10 MySQL Document Store Default to utf8mb4 JSON enhancements CTEs Window Functions Descending … Read More


MySQL Group Replication: who is the primary master – updated!

Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the visibility of Group Replication extending the performance_schema tables (see his article). Thanks to these improvements, it’s now very easy to … 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


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