PHP and MySQL 9
As you can read in my previous post related to MySQL 9 and authentication, the old mysql_native_password plugin has been removed. In that post, I showed an example using PHP 7.2, the default version in OL8. If you are using…
MySQL 9.0 – it’s time to abandon the weak authentication method
With the latest MySQL Innovation Release, we decided that it was time to remove the remaining weak authentication plugin: mysql_native_password. We previously deprecated it and made it not default loaded in MySQL 8.4 LTS and, now, in 9.0 it’s gone!…
MySQL 9.0 is out! Thank you for your contributions!
On July 1st, 3 new releases of MySQL came out. Indeed, we released the next 8.0 (8.0.38), the first update of the 8.4 LTS (8.4.1), and the very first 9.0 as Innovation Release. We now support 3 versions of the…
Perl DBD MySQL for MySQL 8.0 and 8.4 LTS
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…
Machine Learning with MySQL HeatWave and predictions in Grafana
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.…
Using Oracle Analytics Cloud with MySQL HeatWave
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…
MySQL 8.4 LTS – new production-ready defaults for InnoDB
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…
Javascript support in MySQL: the UUID example
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…
MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know
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.…
MySQL Shell for VS Code – Bastion Host & Invalid fingerprint detected
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…
MySQL InnoDB: Primary Key always included in secondary indexes as the right-most columns… or not
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…
Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024
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…
