Category Archives: Development
MariaDB does have bugs. Users see them sometimes. Sometimes developers look for a long time at bug reports and code and still cannot see how the situation occurred. Developers during their analysis ask questions like:
- I wonder if this was already fixed in {not released version}? But how can I ask a user to test that?
- Can I get the user to get good stack trace that would help understand this better? But users sometimes find this hard.
- What exact hardware and kernel configuration is this bug occurring on? And how would I reproduce this?
…
During the development of MariaDB, a lot of things are tested. However the most important workload to be tested is the one we don’t have access to, and that is your workload.
As many of you run your own CI, we’d like you to invite you to join the testing of MariaDB. quay.io/mariadb-foundation/mariadb-devel is a container repository using the latest from our main stable branches. By the time any code gets into these branches it has been reviewed and passed our tests. The developers of the change consider it finished, so this is the perfect time to take this code and test it on your workload.
…
Continue reading “New Service – quay.io/mariadb-foundation/mariadb-devel”
Quarterly release structure delivers new features to the community faster
REDWOOD CITY, Calif. and HELSINKI – December 9, 2021 – MariaDB Corporation Ab and MariaDB Foundation today announced a new release model for MariaDB Server, by MariaDB Corporation referred to as MariaDB Community Server, centered on the goal of delivering new features and innovation faster to the millions of MariaDB users around the world. Under the new model, new server release series, such as MariaDB 10.7 or 10.8, occur once a quarter, rather than once a year, bringing more opportunities for new features and contributions to be delivered to the MariaDB user base.
…
Continue reading “MariaDB Announces New Innovation Release Model”
CONNECT is a storage engine (SE) plugin used to access external, local or remote data. In this blog we are going to show how to install the CONNECT storage engine in a Docker container and how to share JSON data between containers.
Enabling CONNECT SE plugin in Docker
CONNECT SE needs to be installed within the container in order to use it. To see how to do that please check Installing plugins in the MariaDB Docker Library Container.
Create JSON data on remote server
The most important feature of CONNECT SE to MariaDB is the flexibility to create tables from various data sources, like the same database and other DMBS’s tables or files with different formats.
…
Continue reading “Using CONNECT SE to access remote JSON data with demo examples in Docker”
Python is my personal favourite programming language, at least this century. So when the opportunity presented itself to have a talk at PyConZA, off I went. Not to South Africa in person, for a 40 minute talk, though.
Technical challenges on Streamyard
It was a live presentation, streamed on Streamyard with chat on Discord. I complained of the bad connectivity I had in central Munich, much to the amusement of the South African audience, which evidently thought they were role models and market leaders when it comes to bad Internet.
…
MariaDB plugins are software components that may be added to the core software without the need to rebuild the MariaDB Server. Plugins can be storage engines, additional security requirements, special log information about the server and others. MariaDB has a large number of built-in plugins which are permanently installed (listed in SHOW PLUGINS query). Plugins can be loaded at start-up, during initialization, or loaded dynamically when the server is running.
In this blog we are going to see how to list available plugins in the MariaDB container as well as the methods of installing plugins in a container.
…
Continue reading “Installing plugins in the MariaDB Docker Library Container”
Everyone wants performance. Speeding up the insert into empty InnoDB tables and partitions is a common enough use case to optimize. Thirunarayanan Balathandayuthapani from the MariaDB Corporation wrote this improvement to the bulk inserting into InnoDB tables that is available as a preview for testing.
To achieve this, if the table is empty then InnoDB will pre-sort the records for each index, and build the indexes one page at a time. If the transaction does bulk insert operation then InnoDB should create buffer of size innodb_sort_buffer_size for each index.
If the buffer ran out of memory then InnoDB will create a temporary file for storing the data.
…
The “Misc features” preview includes all the other features that did not make it into a separate dedicated preview binary.
MariaDB Server 10.7 includes the JSON_EQUALS function, which compares inputs as JSON objects, regardless of whitespace, key order, or number format.
(more…) …
Continue reading “10.7 feature preview: Miscellaneous features”