Enhancing Your Amazon RDS for MariaDB Databases

Having access to the latest version of open source databases is important to optimize your workloads for availability, performance, security, and more.

In February 2022, AWS launched MariaDB version 10.6 for Amazon RDS for MariaDB alongside a number of other exciting capabilities.

DBTA held a webinar with Otto Kekäläinen, software dev manager, Amazon who featured the new capabilities including, MyRocks Storage engine, IAM integration, flexible upgrades, and more.

With Amazon RDS, users get the most options and widest freedom, Kekäläinen explained. The solution gives users multiple database engines to choose from, allows users to seamlessly integrate with other AWS services, and provides safety and operational excellence.

The platform is easy to adminster, Kekäläinen said. There is a single console and API for managing all relational databases. Tools include hardware provisioning, patching, backup/restore, scaling, and high availability, with a few clicks. Security and monitoring is also built in.

The MariaDB open source database server was created in 2009 by some of the original developers of MySQL (e.g. Michael “Monty” Widenius).

RDS for MariaDB offers the familiar MariaDB server, which is the same open source software you could run yourself, Kekäläinen said.

New features include:

  • Support for MariaDB 10.6 major
  • One-step major upgrade (“Multi-major” version upgrade)
  • Customers can also easily migrate from RDS for MySQL 5.6/5.7
  • AWS Identity and Access Management (IAM) integration
  • Delayed Replication
  • MyRocks storage engine

Previously, instances could only be upgraded to one major version higher than the current version. Now, customers can perform any of the following upgrades seamlessly in a single step, thus reducing downtime substantially.

  • Upgrade from Amazon RDS for MariaDB 10.2/10.3/10.4/10.5 to 10.6 in a single step

AWS IAM provides fine-grained access control across all of AWS: Customers can specify who can access which services and resources, and under which conditions. With IAM policies, customers manage permissions to their workforce and systems to ensure least-privilege permissions.

Delayed Replication is a Disaster Recovery Strategy: Customers set a configurable time by which a replica lags behind the source database.

Amazon RDS for MariaDB now supports 2 storage engines: InnoDB and MyRocks. MyRocks is an open source storage engine, originally developed by Facebook, that adds RocksDB to MariaDB. It uses Log Structured Merge (LSM) architecture to provide efficient data ingestion. InnoDB uses B+ tree. It is best suited for write-intensive workloads, said Kekäläinen.

An archived on-demand replay of this webinar is available here.