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...
Multi-Cloud Deployment for MariaDB Replication Using WireGuard
In this blog post, we are going to look into how to deploy a MariaDB replication setup in a multi-cloud environment. Suppose our primary application is located at AWS, it's the best idea to set...
MariaDB Cluster Offline Installation for CentOS
Most of the installation steps available on the Internet cover the standard online installation, presuming the database hosts are having an active internet connection to the package repositories and satisfy all dependencies. However, installation steps...
Multi-Cloud Full Database Cluster Failover Options for MariaDB Cluster
High availability is paramount in today's business reality. But every service provider comes with an inherited risk of disruption -- and cloud service providers are no different. If they go down, even temporarily, then so...
Comparing Amazon RDS Point-in-Time Recovery to ClusterControl
The Amazon Relational Database Service (AWS RDS) is a fully-managed database service which can support multiple database engines. Among those supported are PostgreSQL, MySQL, and MariaDB. ClusterControl, on the other hand, is a database management...
Preparing a MySQL or MariaDB Server for Production – Part Two
In the previous blog, we have covered some tips and tricks to prepare a MySQL server for production usage from a system administrator perspective. This blog post is the continuation... Use a Database Backup Tool...