MySQL 8.0.17 and Drupal 8.7
From Drupal’s website, we can see that now the support of MySQL 8 is ready. I just tested it and it works great ! The only restriction is related to PHP and the support for the new authentication method in…
From Drupal’s website, we can see that now the support of MySQL 8 is ready. I just tested it and it works great ! The only restriction is related to PHP and the support for the new authentication method in…
I have already posted some time ago a post related to the same topic (see here). Today, I want to explain the easiest way to create an asynchronous replica from an existing MySQL instance, that this time has already data…
With MySQL Shell 8.0.17, a super cool new feature was released: the MySQL Shell Extensions & Plugins ! You will be able to write your own extensions for the MySQL Shell. You may already saw that I’ve written some modules…
Since MySQL 8.0.16, the Router as the possibility to launch an internal webserver (see Jan’s blog post). Even if this webserver could serve static files, it was the first piece of a much more interesting solution that is now available…
Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post). The most complicated part to deal with was the existing…
MySQL Roles are becoming more and more popular. Therefor, we receive more and more questions related to them. First I encourage you to read this previous 2 posts: MySQL 8.0 Roles and GraphML MySQL 8.0: Listing Roles In this post,…
MySQL supports different types of Indexes. They depend on the storage engine and on the type of data. This is the list of supported indexes: B-trees (the most common) R-trees (for spatial data) Hashes (for Memory engine) Inverted (for InnoDB…
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.
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…
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.…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.