Database | Amazon RDS for MariaDB

Question 1

What are the differences between Amazon RDS for MySQL and MariaDB?

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

Answer 1

MariaDB Server is a popular open source relational database created by the original developers of MySQL. The MariaDB database engine is fully compatible with MySQL Community Edition version 5.5. There are several additional features available in MariaDB including:

Thread Pool for enhanced scalability

Query optimizer improvements

Global Transaction IDs (GTIDs) for more reliable replication

Parallel replication for increasing performance

See the Amazon RDS User Guide for more details.

Question 2

Which versions of MariaDB does Amazon RDS support?

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

Answer 2

Amazon RDS currently supports MariaDB major versions 10.0, 10.1 and 10.2.

Question 3

How does Amazon RDS distinguish between “major” and “minor” version releases?

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

Answer 3

In the context of MariaDB, version numbers are organized as follows:

MariaDB version = X.Y.Z

X = Major version, Y = Release level, Z = Version number within release series.

From the Amazon RDS standpoint, a version change would be considered major if either major version or release level is being changed. Example: going from 10.0.X -> 10.1.X.

A version change would be considered minor if the version number within the release is being changed. Example: going from 10.1.14 -> 10.1.17.

Question 4

Does Amazon RDS provide guidelines for upgrading engine versions or deprecation of engine versions that are currently supported?

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

Answer 4

Yes. Please refer to the Amazon RDS FAQs.