Author Archives: Frédéric Descamps
The MariaDB Foundation Sea Lions Champions recognize individuals and organizations that strengthen the MariaDB ecosystem through technical excellence, community leadership, open-source stewardship, ecosystem impact, and real-world adoption.
This first edition’s nominees reflect the diversity and strength of the MariaDB Community: developers, educators, advocates, companies, community organizers, and partners who help MariaDB grow as an open, collaborative, and industry-relevant database platform.
Each nomination highlights a different way to strengthen the database ecosystem and help MariaDB remain open, useful, and innovative.
Technical Excellence
The Technical Excellence category highlights people who contribute deep technical expertise, engineering quality, and innovation around MariaDB and the broader database ecosystem.
…
Continue reading “Celebrating the MariaDB Foundation Sea Lions Champions Nominees”
If you are a Galera user, you are strongly recommended to upgrade ASAP!
MariaDB Community Server corrective releases are now available for the currently maintained long-term series. These releases address critical CVEs, and we strongly recommend that all users review the security advisories and upgrade as soon as possible.
These are Stable (GA) releases and are recommended for users running the corresponding MariaDB Server series.
…
Continue reading “MariaDB Community Server Corrective Releases”
The MariaDB Foundation is pleased to announce the availability of MariaDB Server 12.3 LTS, the latest Long Term Support release of MariaDB Server. The first GA of the 12.3 series is 12.3.2.
MariaDB Server 12.3 LTS includes the features and improvements introduced during the MariaDB 12.x development series and provides a stable release line for production environments requiring long-term maintenance.
Highlights
MariaDB Server 12.3 LTS includes improvements across several areas of the server, including binary logging, SQL compatibility, replication, optimizer behavior, security, GIS, JSON, and general server usability.
Important
In MariaDB 12.3, innodb_snapshot_isolation defaults to ON
As we wanted to be correct when using REPEATBLE READ isolation level, we changed the default of the InnoDB snapshot isolation.
…
We are very pleased to welcome ProxySQL as a Silver Sponsor of the MariaDB Foundation.
ProxySQL is the leading proxy for MySQL and has recently focused on supporting more and more of MariaDB, both with the Proxy and with other open-source projects ProxySQL is stewarding, like dbdeployer and orchestrator.
I had the chance to interview René Cannaò, CEO of ProxySQL.
Why is it important for ProxySQL to sponsor an organization like the MariaDB Foundation?
ProxySQL was born within the MySQL ecosystem, and MariaDB has always been an important part of it.
…
Continue reading “ProxySQL joins MariaDB Foundation as Silver Sponsor”
We are concluding our series related to new data types using the Type_handler framework, with some limitations that are not yet covered by the framework:
- No custom indexing methods. A plugin type cannot introduce a new indexing method.
- No custom hashing. Plugin types can’t provide their own function for hash-based operations. Things like MEMORY table indexes, GROUP BY, and partitioning fall back to the underlying type’s hash.
- No new field attributes. Plugin types cannot define custom attributes beyond the existing ones: length, precision, scale, and GIS SRID.
…
Continue reading “Adding a New Data Type to MariaDB with Type_handler – Part 5”
This is part 4 of a series related to extending MariaDB with a custom data type using the Type_handler framework.
You can find the previous articles below:
- Adding a New Data Type to MariaDB with Type_handler – Part 0 – how to build MariaDB Server
- Adding a New Data Type to MariaDB with Type_handler – Part 1 – understanding the framework
- Adding a New Data Type to MariaDB with Type_handler – Part 2 – minimal working data type
- Adding a New Data Type to MariaDB with Type_handler – Part 3 – data type output transformation
Overriding Existing Types
In the previous examples, our MONEY data type inherits from DOUBLE and then we override some methods.
…
Continue reading “Adding a New Data Type to MariaDB with Type_handler – Part 4”
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.
But finally, someone has decided to take up the torch. ProxySQL announced this big decision last month.
We at the MariaDB Foundation are very happy that dbdeployer has risen from the ashes thanks to the ProxySQL team, and we are committed to further developing and contributing to this great tool for all its users, especially those who use it to deploy MariaDB Server.
…
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 this article, we will extend our data type just a bit by transforming the result into a VARCHAR and adding a currency sign to it: the dollar sign ($).
This is the expected result:
MariaDB [test]> …
Continue reading “Adding a New Data Type to MariaDB with Type_handler – Part 3”