lefred

Dealing with caching_sha2_password as authentication method in MariaDB Server
MariaDB Server supports different authentication methods just like MySQL.

Depending on your installation, the number of available and active authentication plugins can vary.

But you should always have those 3 by default:

MariaDB > select plugin_name from information_schema.plugins

https://lefred.be/content/dealing-with-caching_sha2_password-as-authentication-method-in-mariadb-server/
#MariaDB

Have you ever used the #MariaDB CONNECT storage engine?

CONNECT lets MariaDB query external data sources — such as CSV, JSON, XML files, ODBC/JDBC sources, and remote tables — as if they were regular SQL tables. It can be useful for integrations, reporting, migration work, and lightweight ETL.

We are running a quick poll to learn how people use it, or why they don’t.

Please take a minute to participate and share your experience 👇 https://mariadb.org/poll-connect-engine-survey/

We reached the final post of our series about extending MariaDB with a new data type using the Type_handler framework. Let's have a look at the limitations & workarounds. 🦭🧩 https://mariadb.org/adding-a-new-data-type-to-mariadb-with-type_handler-part-5/ #mariadb #plugin

Sarò a Roma il 27 maggio per parlarti di MariaDB 🦭 🏟️ 🇮🇹 https://shorturl.at/yLXP0 #mariadb #event

Adding a New Data Type to MariaDB with Type_handler – Part 3
In the previous article, we wrote, compiled, and tested our first custom data type for MariaDB using the Type_handler framework.

But currently, aside from allowing the use of its new name (MONEY) and listing it in the metadata, our new data type behaves exactly like a DOUBLE, the class it inherits from.

In
https://lefred.be/content/adding-a-new-data-type-to-mariadb-with-type_handler-part-3/
#DataType #MariaDB #Plugins

Testing the newly implemented #MariaDB #Galera Cluster in dbdeployer! Great job #proxysql team 🦭🦭🦭 ⚙️🏕️ https://proxysql.github.io/dbdeployer/providers/galera/

The series continues! Adding a New Data Type to MariaDB with Type_handler, part 4: let's see how to override existing types and change how our new type is sorted. https://mariadb.org/adding-a-new-data-type-to-mariadb-with-type_handler-part-4/ 🦭🧩 #mariadb

Long live to dbdeployer!
As you know, MySQL-Sandbox and then dbdeployer have always been part of the Swiss Army knife for DBAs trying to evaluate, test, or reproduce issues with a certain version of their database.

The author, Giuseppe Maxia, aka the datacharmer, produced incredible work on these two projects. Unfortunately, Giuseppe decided to archive the project in 2023. Read the announcement.

B
https://lefred.be/content/long-live-to-dbdeployer/
#CommunityTool #MariaDB

Last call to nominate your favorite #MariaDB Sea Lion Champion candidate! 🦭 👑 https://mariadb.org/know-a-mariadb-champion-submit-a-nomination/

This is part 3 of our series about how to add a new data type with the Type_handler framework, an easy way to extend MariaDB 🦭 🧩 https://mariadb.org/adding-a-new-data-type-to-mariadb-with-type_handler-part-3/ #mariadb

Wanna keep coding over the weekend? Here is part 2 of the series about how to extend MariaDB 🦭, adding a new data type 🧩 : https://mariadb.org/adding-a-new-data-type-to-mariadb-with-type_handler-part-2/ #mariadb

The latest MariaDB Adoption Index data shows something I really like to see: not one lucky spike, but multiple signals moving in the right direction at the same time. We're really on a roll! https://mariadb.org/mariadb-keeps-climbing-community-adoption-and-momentum/ #MariaDB #momentum #adoption 🦭

Deploying on OCI with the starter kit – part 8 (using MySQL REST Service)
The starter kit deploys a MySQL HeatWave DB System on OCI and enables the MySQL REST Service automatically:

The REST Service enables us to provide access to data without requiring SQL. It also provides access to some Gen AI functionalities available in MySQL
https://lefred.be/content/deploying-on-oci-with-the-starter-kit-part-8-using-mysql-rest-service/
#Cloud #HeatWave #MDS #MySQL #MySQLRESTService #OCI

Deploying on OCI with the starter kit – part 7 (GenAI in HeatWave)
We saw in part 6 how to use OCI's GenAI Service. GenAI Service uses GPUs for the LLMs, but did you know it's also possible to use GenAI directly in MySQL HeatWave? And by default, those LLMs will run on CPU. The cost will then be reduced.

This means that when you are connected to your MySQL Hea
https://lefred.be/content/deploying-on-oci-with-the-starter-kit-part-7-genai-in-heatwave/
#Cloud #GenAI #HeatWave #MDS #OCI

Deploying on OCI with the starter kit – part 5 (connecting to the database II)
In part 4 of our series on the OCI Hackathon Starter Kit, we saw how to connect to the deployed MySQL HeatWave instance from our clients (MySQL Shell, MySQL Shell for VS Code, and Cloud Shell). In this post, we will see how to connect from an application usin
https://lefred.be/content/deploying-on-oci-with-the-starter-kit-part-5-connecting-to-the-database-ii/
#Cloud #Devel #HeatWave #MDS #MySQL #OCI #Python

MySQL 9.5 – Thank you for your contributions!
On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release.

In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories.

Connector J

#98699 - Allow empty ke
https://lefred.be/content/mysql-9-5-thank-you-for-your-contributions/
#95 #Contributions #MySQL

How do you upgrade MySQL HeatWave when deploying with Terraform?
Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform?

When you tried, you realized, I hope you didn't turn off backups, that the instance is destroyed and recreated new!

This is our current MySQL HeatWave DB System deployed u
https://lefred.be/content/how-do-you-upgrade-mysql-heatwave-when-deploying-with-terraform/
#Cloud #HeatWave #MDS #MySQL #OCI

Uplevel the MySQL REST Service
The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet.

The MySQL REST Service was first released on https://labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released on MySQL
https://lefred.be/content/uplevel-the-mysql-rest-service/
#94 #Component #General #MRS #MySQL #MySQLRESTService

The slides of my session about #MySQL Document Store 🐬 at #techorama 🎪 🇳🇱 are now online: https://buff.ly/4eBARWD

Today I received a copy of Red Stack Magazin where my article on #MySQL
GIPK 🔑 mode has been published ! #doag