lefred blog: tribulations of a MySQL Evangelist

8.0, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell

MySQL Group Replication: what are those UDFs ?

SELECT UDF_NAME FROM performance_schema.user_defined_functions WHERE UDF_NAME LIKE ‘group_repl%’; +————————————————-+ | UDF_NAME | +————————————————-+ | group_replication_get_communication_protocol | | group_replication_get_write_concurrency | | group_replication_set_as_primary | | group_replication_set_communication_protocol | | group_replication_set_write_concurrency | | group_replication_switch_to_multi_primary_mode | | group_replication_switch_to_single_primary_mode | +————————————————-+ Some of these UDFs can…

May 16, 2019

8.0, Conference, Document Store, General, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell, NoSQL, Replication

the MySQL Team in Austin, TX

If you registerd for our tutorial, please come with a laptop able to run 3 VirtualBox VMs that you can install from a USB stick. So please make free some disk space and install the latest Virtualbox on your system.…

May 10, 2019

8.0, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell, Performance_Schema

MySQL InnoDB Cluster : Recovery Process Monitoring with the MySQL Shell Reporting Framework

As explained in this previous post, it’s now (since 8.0.16) possible to use the MySQL Shell Reporting Framework to monitor MySQL InnoDB Cluster. Additionally, when a member of the MySQL InnoDB Cluster’s Group leaves the group for any reason, or…

May 7, 2019

8.0, General, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell, Performance_Schema, SYS

Using the new MySQL Shell Reporting Framework to monitor InnoDB Cluster

With MySQL Shell 8.0.16, a new very interesting feature was released: the Reporting Framework. Jesper already blogged about it and I recommend you to read his articles if you are interested in writing your own report: I this…

May 2, 2019
8 Comments

8.0, MySQL, MySQL 8.0, Performance_Schema

What configuration settings did I change on my MySQL Server ?

This post is just a reminder on how to find which settings have been set on MySQL Server. If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you…

April 30, 2019

8.0, Document Store, JSON, MySQL, MySQL 8.0

MySQL 8.0.16: how to validate JSON values in NoSQL with check constraint

As you may have noticed, MySQL 8.0.16 has been released today ! One of the major long expected feature is the support of CHECK contraints . My colleague, Dave Stokes, already posted an article explaining how this works. In this…

April 25, 2019

General, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell

MySQL InnoDB Cluster : avoid split-brain while forcing quorum

Disclaimer: it’s better to never change the value of group_replication_unreachable_majority_timeout This post provides you an overview of what could happen in the worse case but may lead in a very unstable setup We saw yesterday that when an issue (like…

April 11, 2019
16 Comments

5.7, 8.0, Group Replication, InnoDB Cluster, MySQL, MySQL 8.0, MySQL Shell

MySQL InnoDB Cluster – how to manage a split-brain situation

Everywhere I go to present MySQL InnoDB Cluster, during the demo of creating a cluster, many people doesn’t understand why when I’ve 2 members, my cluster is not yet tolerant to any failure.

April 10, 2019
21 Comments

MySQL, rpm

Ripple Binlog Server for MySQL

Today I started to check ripple the new MySQL binlog server. I don’t want to give yet any feedback neither I want to answer THE question: Is this the Binlog Server we were all waiting for ? But I had…

March 27, 2019
5 Comments

8.0, General, MySQL, MySQL 8.0, wordpress

Replace MariaDB 10.3 by MySQL 8.0

Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new…

March 26, 2019
20 Comments

5.7, 8.0, General, MySQL, MySQL 8.0, wordpress

Migrate from MariaDB to MySQL on CentOS

On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL. Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL…

March 26, 2019
24 Comments

8.0, General, Group Replication, HA, InnoDB Cluster, MySQL, MySQL 8.0

MySQL InnoDB Cluster – consistency levels

Consistency during reads have been a small concern from the adopters of MySQL InnoDB Cluster (see this post and this one). This is why MySQL supports now (since 8.0.14) a new consistency model to avoid such situation when needed. Nuno…

March 14, 2019
5 Comments

Cookie	Duration	Description
cookielawinfo-checbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.