Tag Archives: MariaDB 12.1
The MariaDB Foundation is pleased to announce the availability of MariaDB 12.1.2, the latest stable rolling release.
MariaDB 12.1.2 features performance enhancements, deeper MySQL and Oracle compatibility, and other general improvements.
See the release notes and changelogs for details.
Release Notes Changelog Overview of MariaDB 12.1
MariaDB APT and YUM Repository Configuration Generator
Contributors to MariaDB 12.1.2
Aleksey Midenkov (MariaDB Corporation)
Alexander Barkov (MariaDB Corporation)
Alexey Botchkov (MariaDB Corporation)
Alexey Yurchenko (Codership)
Andrei Elkin (MariaDB Corporation)
Arcadiy Ivanov
Brandon Nesterenko (MariaDB Corporation)
Christian Hesse
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Dave Gosselin (MariaDB Corporation)
Debarun Banerjee (MariaDB Corporation)
Denis Protivensky (Codership)
Dmitry Shulga (MariaDB Corporation)
Elena Stepanova (MariaDB Corporation)
Fariha Shaikh (Amazon)
Florian Smeets (FreeBSD)
Hemant Dangi (Codership)
i18n.site
Jan Lindström (MariaDB Corporation)
Jean Weisbuch
Jimmy Hú (MariaDB Corporation)
J. …
Continue reading “MariaDB 12.1.2 rolling release now available”
For historical reasons, the handling of FOREIGN KEY constraints in MariaDB Server is somewhat peculiar. Unlike CHECK constraints, which are being enforced at the query execution layer for all tables, FOREIGN KEY constraint definitions will simply be ignored unless the underlying storage engine supports them.
The storage engine is not only responsible for enforcing referential integrity between tables, but also storing the constraint definitions. Currently, InnoDB is the only storage engine that supports foreign key constraints, between persistent, non-partitioned tables.
Partitioning is implemented by a storage engine wrapper that makes each partition or subpartition appear as a separate table in the underlying storage engine.
…
Continue reading “Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1”
We are pleased to announce the availability of a preview of the MariaDB 12.1 series. MariaDB 12.1 will be a rolling release.
MariaDB 12.1 introduces numerous new features, in particular
Performance improvements
- Segmented key cache for Aria (MDEV-24)
- MDL scalability improvements (MDEV-19749)
- Parallel replication for galera replicas (MDEV-20065)
- Buffered logging for audit plugin (MDEV-34680)
- Faster vector distance calculations via extrapolation (MDEV-36205)
Compatibility features
- caching_sha2_password plugin (MDEV-9804)
- ( + ) for outer join syntax (MDEV-13817)
- rpl_semi_sync_master_wait_for_slave_count (MDEV-18983)
- Associative arrays: DECLARE TYPE ..
…