MySQL: CPU information from SQL
Do you know that it’s possible to get information from the CPUs of your MySQL Server from SQL ? If you enable the status for the INNODB_METRICS table in INFORMATION_SCHEMA, you will be able to query CPU information.
Perl & MySQL 8.0
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…
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.…
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…
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…
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…
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…
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…
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.
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…
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…
