Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7. Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver…
In MySQL HeatWave, the Database as a Service (DBaaS) offered by Oracle, Machine Learning is incorporated to provide database administrators (DBAs) and developers with an optimal experience. Those tools are the Auto ML advisors like the autopilot indexing for example.…
MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very…
Yesterday, MySQL 8.4, the very first LTS version of MySQL was released. A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications. The default value of…
You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL…
In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games.…
If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI. If you already have a connection setup using a bastion to host, you…
Recently during the Swedish MySQL User Group (SMUG), I presented a session dedicated to MySQL InnoDB Primary Keys. I forgot to mention a detail that many people are not aware, but Jeremy Cole has pointed out. Primary Key always included…
Our MySQL Belgian Days were a complete success. With 120 participants, the room was packed throughout the 2 days from the first to the last session. A record for this event ! The audience was made up of customers (some…
Maintaining a production dataset at a manageable size can present a considerable challenge during the administration of a MySQL InnoDB Cluster. Old Days Back in the day when we only had one main copy of our data (the source), and…
The MySQL Belgian Days are sold-out, our event that will take place the 1st and 2nd February 2024 in Brussels seems to have already attracted a lot of interest. And this interest is justified, because here is the program for…
I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI. I will explain how to install OpenTofu and how to use it to deploy on OCI.…
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.