The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.
These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …
2022 is off to a flying start and there are seven new MariaDB Server releases to kick things off. The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.1, the first release candidate in the MariaDB 10.8 series, MariaDB 10.7.2, the first Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.6, MariaDB 10.5.14, MariaDB 10.4.23, MariaDB 10.3.33 and MariaDB 10.2.42, the latest stable releases in their respective series. …
FOSDEM, one of the premier free and open source events on the calendar, is taking place this weekend, Saturday 5 February to Sunday 6 February. The MariaDB devroom will be taking place on the Saturday.
Thanks to the committee, consisting of
Sveta Smirnova (Percona)
Oli Sennhauser (FromDual)
Manuel Arostegui (Wikimedia Foundation)
Federico Razzoli (Vettabase)
Daniel Black (MariaDB Foundation)
Daniel Bartholomew (MariaDB Corporation)
for their valuable feedback.
The schedule is:
Take a look at the schedule on the FOSDEM site for any last-minute changes, as well as links to the videos and chatrooms.
…
In this blog we are going to see how to create a link to a remote server and use it to access multiple tables at once.
In the previous blog we have seen how to establish a remote connection between Docker containers.
The way we did it was to specify the connection string to reference a single table only.
But what if we need more tables, what if need a whole database?
The solution is to link to a remote database with the CREATE SERVER statement.
A link obtained this way can be passed to the CREATE TABLE statement of a storage engine (SE) to make a connection where using the table discovery feature SE will find out about the table fields and create the table.
…
Continue reading “Create a link to a remote server and access data using CONNECT SE”
At Vettabase we support various databases,and in particular we are MariaDB enthusiasts. Even more, we’re proud to be MariaDB Foundation Technology Partners. So I’m happy to write this small wrap-up about the MariaDB Foundation public activities in 2021! Just a disclaimer before starting: this is not an official retrospective, it’s a subjective, opinionated one. My opinions represent myself alone. So here is my favourite 2021 news in the MariaDB world…
MariaDB 10.6 went Generally Available in November (I wrote a summary on Vettabase website). A couple of unmaintained storage engines were removed, as well as 23 InnoDB variables.
…
As an Oracle compatibility syntax extension, the IN, OUT, and INOUT / IN OUT quantifiers of stored function parameters was requested in MDEV-10654. It was noted that Postgres and DB2 also support this syntax. A few years later thanks to our community contributor Manohar KB of Rakuten Securities Japan, this functionality was created. Alexander Barkov from the MariaDB Corporation provided reviews and extended this PL/SQL syntax to be available in the non SQL_MODE=ORACLE mode of SQL/PSM.
Having OUT parameters on functions enables the nesting of functions will multiple return values where previously there was only the single return value possible.
…
Continue reading “10.8 preview feature: IN, OUT, INOUT, IN OUT parameters in CREATE FUNCTION”
Following up on our announcement of the new release model, first used in 10.7.0, we are pleased to announce that the MariaDB Server 10.8.0 preview releases are now available.
Maturing MariaDB more quickly
One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.
Candidate features for MariaDB 10.8
The features available in the preview releases, and therefore under consideration for release in 10.8.1, are:
- MDEV-4989 mysqlbinlog GTID support
- MDEV-10654 Stored Procedures INOUT Parameters
- MDEV-11675 Lag free ALTER TABLE in replication
- MDEV-13756 Descending indexes
- MDEV-14425 InnoDB redo log improvements
- MDEV-17554 Auto create partition
- MDEV-26519 JSON Histograms
- MDEV-26713 Windows – Improved i18n support
- MDEV-27106 Spider Storage Engine Improvements
- MDEV-27265 Misc.
…
Continue reading “MariaDB 10.8.0 preview releases now available”
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?
…