Deploying MariaDB Replication for High Availability
MariaDB Server offers asynchronous and synchronous replication. It can be set up to have a multi-source replication or with a multi-master setup. For a read and write intensive application, a master-slave setup is common, but...
What's New in MariaDB MaxScale 2.4
MaxScale 2.4 was released on December 21st, 2019, and ClusterControl 1.7.6 supports the monitoring and managing up to this version. However, for deployment, ClusterControl only supports up to version 2.3. One has to manually upgrade...
Using the MariaDB Audit Plugin for Database Security
There are different ways to keep your data safe. Practices such as controlling database access, securing configuration, upgrading your system, and more are part of database security. It is even possible that you have security...
Exploring Storage Engine Options for MariaDB
MariaDB Server was originally derived from MySQL and has therefore inherited its pluggable storage engine architecture. Different storage engines have different characteristics in terms of performance but also features and possibilities. This allows users to...
What is MariaDB Enterprise Cluster?
MariaDB Enterprise Cluster is a subscription service of a highly available database solution from MariaDB Corporation which is managed with an Enterprise Lifecycle. There are three aspects of the Enterprise Lifecycle that are provided by...
Introduction to MaxScale Administration Using maxctrl for MariaDB Cluster
MariaDB Cluster consists of MariaDB Server with Galera Cluster and MariaDB MaxScale. As a multi-master replication solution, any MariaDB Server with Galera Cluster can operate as a primary server. This means that changes made to...
Using the Aria Storage Engine with MariaDB Server
MariaDB Server is one of the most popular open-source database servers. It was created by the original developers of MySQL and it became popular for being fast, scalable, and robust. MariaDB has a rich ecosystem...
What Are MariaDB Temporal Tables?
Starting from 10.3.4, MariaDB comes with temporal tables. It is still quite an uncommon feature and we would like to discuss a bit what those tables are and what they can be useful for. First...
How to Deploy a MariaDB Cluster for High Availability
MariaDB Cluster is a multi-primary replication system built from MariaDB Server, MySQL wsrep patch and Galera wsrep provider. Galera is based on synchronous (or ‘virtually synchronous’) replication method, which ensures the data applied to other...
An Overview of the New DBaaS from MariaDB – SkySQL
MariaDB has recently launched its new DBaaS offering, SkySQL. It might be a surprise to some, but this has been an anticipated move from MariaDB as they have been actively pushing state of the art...
What is MariaDB ColumnStore?
In general, databases store data in row format and use SQL as query language to access it, but this storage method is not always the best in terms of performance, it depends on the workload...
What’s New in MariaDB Server 10.5?
MariaDB Server 10.5 is a fresh, new, and stable version from MariaDB that was released on June, 24th 2020. Let’s take a look at the features that it will bring us. More Granular Privileges With...