Improving Your Amazon RDS Databases for MariaDB
Having access to the latest version of open source databases is important to optimize your workloads in terms of availability, performance, security, etc.
In February 2022, AWS released MariaDB version 10.6 for Amazon RDS for MariaDB alongside a number of other exciting features.
DBTA hosted a webinar with Otto Kekäläinen, Software Development Manager at Amazon, who showcased the new features including MyRocks storage engine, IAM integration, flexible upgrades, and more.
With Amazon RDS, users get the most options and 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 security and operational excellence.
The platform is easy to administer, Kekäläinen said. There is a single console and API to manage all relational databases. Tools include hardware provisioning, patching, backup/restore, scaling, and high availability, all in just a few clicks. Security and surveillance are also integrated.
The open source MariaDB database server was created in 2009 by some of the original MySQL developers (eg 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 to MySQL 5.6/5.7
- AWS Identity and Access Management (IAM) integration
- Delayed replication
- MyRocks Storage Engine
Previously, instances could only be upgraded to a major version higher than the current version. Now customers can perform any of the following upgrades seamlessly in a single step, significantly reducing downtime.
- Upgrade Amazon RDS for MariaDB 10.2/10.3/10.4/10.5 to 10.6 in one step
AWS IAM provides granular access control across AWS: customers can specify who can access what services and resources, and under what conditions. With IAM policies, customers manage their workforce and system permissions to ensure least privilege permissions.
Deferred replication is a disaster recovery strategy: customers set a configurable amount of time that 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, which adds RocksDB to MariaDB. It uses Log Structured Merge (LSM) architecture to provide efficient data ingestion. InnoDB uses the B+ tree. It is best suited for write-intensive workloads, Kekäläinen said.
An archived on-demand replay of this webinar is available here.