Ensuring continuity and open collaboration

Posts by Jan Lindstrom

InnoDB holepunch compression vs the filesystem in MariaDB 10.1

InnoDB holepunch experiments After excellent blogs by Mark Callaghan (see links below), I decided to use some of my time to experiment how different filesystems behave if the holepunch feature is used in MariaDB 10.1. First of all, MariaDB 10.1 does not use holepunch by default even if a table is page compressed (a term […]

MariaDB: InnoDB foreign key constraint errors

Introduction A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table. The purpose of the foreign key is to […]

Fortran and MariaDB

Introduction Fortran (FORmula TRANslating System) is a general-purpose, imperative programming language that is especially suited to numeric computation and scientific computing. History of FORTRAN can be tracked late 1953 when John W. Backus submitted a proposal to his superiors at IBM. The First FORTRAN compiler appeared in April 1957. Some notable historical steps where: FORTRAN […]

Table and tablespace encryption on MariaDB 10.1.3

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. […]

Causal Consistency

Introduction Causal consistency [1] is one of the consistency criteria that can be used on distributed databases as consistency criteria. Distributed database provides causal consistency if read and write operations that are causally related are seen by every node of the distributed system in the same order. Concurrent writes may be seen in different order […]

Sponsors

MariaDB Foundation sponsors

Tweets by @mariadb

Code statistics