Database | Amazon RDS for MariaDB Flashcards

1
Q

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

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which versions of MariaDB does Amazon RDS support?

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

Amazon RDS for MariaDB

Amazon RDS for MariaDB | Database

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Yes. Please refer to the Amazon RDS FAQs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly