Showing entries 11 to 20 of 43709
« 10 Newer Entries | 10 Older Entries »
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!

Reasons

Oracle places significant attention on the security of all its products, and MySQL is no exception. The removal of the weak authentication plugin has been carefully considered, we had some extra time for the LTS release as it was initially intended for version 8.4, but it is now fully effective.

But why is the mysql_native_password considered as weak compared to more modern …

[Read more]
MySQL: Plugin 'mysql_native_password' is not loaded

In libera:#mysql a user has been running MySQL in a docker container with mysql:latest. This container got automatically upgraded to MySQL 9.0.0, an innovation release.

Part of the 9.0 release is the removal of the mysql_native_password plugin, which has been deprecated since 8.0. The user now can no longer login to their database. They have no backup and no replica.

We recreate the problem from scratch, using docker, and then recover the instance.

Creating a test setup

On my system, I am using LVM2, and I am routinely using the XFS file system. I am creating a 10 GB sized test filesystem, which I mount to /a. In that, we create a mysql and a conf directory.

The official mysql image is running as UID 999, and that is …

[Read more]
Advanced Data Load with MySQL Shell

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to use when loading database dumps.

MySQL 9.0 is out! Thank you for your contributions!

MySQL is Open Source and accept contributions from the Community. This is the list of contributions accepted in the last releases.

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 most popular Open Source database.

With these releases, we also want to thank all the great contributors who send patches to MySQL.

For some time now, all the contributors have also been highlighted in the Release Notes, but we never thank enough, so let’s take back the good habits of listing them in a dedicated blog post.

Some contributions were merged into multiple versions. Let’s have a look at all these contributions:

[Read more]
Advanced Data Dump with MySQL Shell

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to use when dumping database schemas and data.

MySQL 9.0 Community Edition: A Quick Peek

MySQL 9.0 was released on July 1, 2024. This is an ‘Innovation’ release, which means it provides access to the latest features and improvements in MySQL technologies. Innovation releases are the opposite of the Long Term Support (LTS) releases, where stability is the top priority, and only needed security and other fixes are available. This […]

How to setup FastAPI with MySQL HeatWave and Post the Data into MySQL

FastAPI is a modern, fast (high-performance), web framework for building APIs with Python based on standard Python type hints.

MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one MySQL Database—without the complexity, latency, risks, and cost of ETL duplication.

MySQL July 2024 GA Releases Now Available

MySQL Server 9.0.0 Innovation, 8.4.1 LTS, 8.0.38, are now available for download and in the MySQL HeatWave Database Service. These are the latest General Availability (GA) releases as of July 1, 2024.

Galera Cluster for MySQL 8.0.37-26.19 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.37-26.19 (release notes, download), with Galera replication library 4.19 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.37, adding a synchronous option for your MySQL High Availability solutions.

In the Galera replication …

[Read more]
Showing entries 11 to 20 of 43709
« 10 Newer Entries | 10 Older Entries »