Author Archives: Daniel Black
Last year I filed a bug report MDEV-33603 on what a looked like a benign problem with an optimizer taking a different code path in a particular trivial looking test. Its benign looking nature lead to me not looking at it until last week. The “benign” bug as it turned out is a bug in an OpenSSL optimization on IBM POWER, which maybe not the lowest level of “How deep”, but its certainly a long way from the high level (above storage engines) optimizer decisions in MariaDB.
I feel I need to start this story justifying why it was left so long.
…
XAMPP, Apache + MariaDB + PHP + Perl, is a valuable learning installer/product for new developers on Windows, Linux and MacOS. There needs to more maintainers, potentially you, for this product to remain useful.
Its currently maintained by a single maintainer, Beltran Rueda, who is time poor, but wants the project to continue. With a small amount of ongoing support from you, the reader, who has or could gain iTcl programming skill, this product, that enables the future generations of developers, could be maintained. High on the priority list for the project is a few version bumps (notably MariaDB 10.4, that isn’t packaged or maintained any longer) and resolving some poor user experiences.
…
Earlier I posted that this presentation was about to happen, and it did! I presented to a keen audience of over 20 people live, and number who watched later (it was in a rather early US time, however attracted a number of attendees from Europe, India, Thailand all the way to east of Australia at UTC+10:30.
Below is the video, and the slide outline is available.
The journey to this presentation began as a request to update our Clang version that we use in Buildbot, MariaDB’s CI system.
…
Continue reading “Deep dive into Clang sanitizer testing with MariaDB (Post Event)”
MariaDB uses Clang’s memory, address, and undefined behavior sanitizers are used for identify coding flaws during the continuous development and testing process. MariaDB would like to share via an online event on how easy perform the same sanitizer checking.
The MemorySanitizer environment is particularly onerous to create. Because MariaDB use container based build and testing, we have an environment that can be re-used by anyone.
Our “Deep Dives” were once an internal skills transfer mechanism, however for the first time we’re making it available for anyone to join.
This particular deep dive will cover:
- Basics of MemorySanitizer, Address Santizer and Undefined Behavour Sanitizer;
…
Continue reading “Deep dive into Clang sanitizer testing with MariaDB”
.jpg){kind=link}
Every once in a while a truly inspiring contribution comes to us at MariaDB. Today’s timely contribution was from Sigma, and their inspiring contribution was in pull request 3937 which adds the AMEN statement for committing transactions. The need for harmonizing cultural norms with SQL standards is largely under explored aspect of engineering and here seems to be a good a place to start as any.
As described:
This pull request introduces a new statement, amen, which serves as an alternative to the traditional commit command in MariaDB. The motivation behind this change is to provide a more thematic and culturally resonant way to conclude transactions, reflecting the religious connotation of the name “MariaDB”.
…
Continue reading ““Amen” statement for committing transactions”
There are a number of SQL Fiddles, web interfaces to databases for testing / learning SQL. Recently we noticed the versions on these falling behind and not presenting users with updates that would deliver the latest MariaDB features and bug fixes.
In reaching out to the people that manage these fiddles we’re pleased to announce that so far, two providers have updated their MariaDB version(s).
PHPize.online / SQLize.online
PHPize.online and SQLize.online are the pet projects of Slava Rozhnev. These have both been updated and now have available MariaDB 11.4, our current long term support version, and also MariaDB 11.5.
…
We launched Red Hat UBI based Docker Official Images for MariaDB! These are available on Docker Hub with tags containing ubi including lts-ubi.
The MariaDB plc folks suggested this would be good for enterprise users. After dusting of an old prototype, jointly developing the image, a couple of requests for packages into the UBI repository, and running through our test suite for compatibility testing, there is now an image available for everyone that will be maintained.
Attention to the Red Hat Open Shift Certification Policy made some compliance changes to the UBI based MariaDB image.
…
Easy question, easier answer. Docker Official Images are the official image distributor of MariaDB Server. It was years ago that the Docker Official Image of MariaDB Server gained all its environment variables in MARIADB_* form and its fork on the MariaDB Corporation Docker Hub was deprecated and eventually removed. As a result of contributing to the Docker Official Images of MariaDB Server, the day to day maintenance was transferred to the MariaDB github organization. Here, the MariaDB Foundation, with support from MariaDB Corporation (now MariaDB plc) on server and releases, continue to develop and support the Docker Official Image.
…
Continue reading “Where is the official MariaDB Container Image?”