Tag: XtraDB
-
Table and tablespace encryption on MariaDB 10.1.3
Note that this post is now outdated. See Table and tablespace encryption on MariaDB 10.1
Introduction
For the moment, the only engines that fully support encryption are XtraDB and InnoDB. The Aria storage engine also supports encryption, but only for temporary tables.
MariaDB supports 2 different way to encrypt data in InnoDB/XtraDB:
- Specified table encryption: Only tables which you create with PAGE_ENCRYPTION=1 are encrypted. This feature was created by eperi.
- Tablespace encryption: Everything is encrypted (including log files). This feature was created by Google and is based on their MySQL branch.
-
MariaDB 10.1.1: Defragmenting unused space on InnoDB tablespace
Introduction
When you e.g. delete rows, these rows are just marked as deleted not really physically deleted from indexes and free space introduced is not returned to operating system for later reuse. Purge thread will physically delete index keys and rows, but still free space introduced is not returned to operating system and this operation can lead holes on page. If you have variable length rows, this could lead to situation where this free space can’t be used for new […]
-
MariaDB 10.1.1: Monitoring progress and temporal memory usage of Online DDL in InnoDB
Introduction
Online DDL is a new feature in MariaDB 10.0. Online DDL is processed through below 4 tasks in sequence.
- InnoDB::ha_prepare_inplace_alter_table(..)
- InnoDB::ha_inplace_alter_table(..)
- InnoDB::ha_commit_inplace_alter_table(..)
- mysql_rename_table(..)
-
MariaDB 10.0.9 now available
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate release.
Among other changes, XtraDB is now the default InnoDB implementation, Oracle’s InnoDB is included as a plugin and can be dynamically loaded if desired. Packages for Ubuntu 14.04 “trusty” and Debian “Sid” have also been added to the MariaDB Ubuntu and Debian repositories.
See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? […]
-
MariaDB 5.5.32 Now Available
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the AskMonty Knowledgebase for general information about the MariaDB 5.5 series.
Download MariaDB 5.5.32
Release Notes Changelog What is MariaDB 5.5?
This release is primarily a bug-fix release.
Includes MariaDB 5.3.12 and MySQL 5.5.32
This release includes MariaDB 5.3.12 and MySQL […]