MariaDB vs MySQL on Amazon’s AWS RDS

Since their separation six years ago, the edge in the MariaDB vs MySQL competition has shifted towards MariaDB. Amazon cloud users might end up the big winners.

MariaDB was created as a fork of the MySQL database after MySQL was acquired by Oracle in 2008. MariaDB is a drop in, fully backward-compatible replacement for MySQL that actually offers more DB engines than MySQL itself. In fact, MariaDB has moved beyond MySQL with faster bug fixes, rapid feature enhancements, and support for NoSQL solutions like Cassandra and LevelDB.

Since the fork, many significant MySQL users – including Wikipedia, Suse, and Google – have migrated MySQL deployments to MariaDB for the better support, vibrant community, and open-source commitment. Nevertheless, when it comes to open source, efficient, and easy-to-use SQL databases, MySQL is probably still the first name that comes to mind.

Five advantages of MariaDB vs MySQL

You may want to more fully compare MariaDB vs MySQL compatibility, features, and upgrade paths. In the meantime, here are some more obvious advantages of MariaDB:

1. MariaDB vs MySQL: MariaDB is more reliably open source

MariaDB releases all of its code under GPL, LGPL, or BSD licenses. Unlike MySQL EE, MariaDB does not have closed source modules. With Oracle’s ownership of MySQL – and its unclear development and business model – MariaDB’s popularity is growing.

2. MariaDB vs MySQL: MariaDB supports many more engines

In addition to all the default MySQL engines, MariaDB supports more engines, including  XtraDB, (a drop in replacement for InnoDB), the Connect and Cassandra engines for NoSQL, and Spider for sharing.

3. MariaDB vs MySQL: MariaDB has more features

Parallel Replication, Thread pooling, Multi-source replication, Dynamic Columns, and engine-independent table statistics are some areas where MariaDB has passed MySQL 5.6. You can read the full list of new features here.

4. Active-active clustering

Unlike traditional master-slave replication, Galera Cluster supports master-master replication. Galera Cluster is shipped with MariaDB 10.1, so there is no need to add a separate cluster version.

5. Virtual Column support (Cassandra Storage Engine)

The Cassandra Storage Engine allows access to data in a Cassandra cluster from MariaDB. The primary goal of Cassandra SE (Storage Engine) is data integration between the SQL DB and NoSQL data-store. Cassandra SE makes Cassandra’s column family appear as a table in MariaDB. Users can select, insert, update, and write joins against this table.

MariaDB vs MySQL and AWS

Since October 2015, Amazon RDS (Relational Database Service) supports MariaDB version 10.0.17 community edition, across all regions except US Gov. Amazon RDS also supports the XtraDB and Aria storage engines for MariaDB instances. RDS’s Point-In-Time Restore and Snapshot Restore require a recoverable storage engine, and are supported for the XtraDB engine only. The Aria storage engine is used for spatial indexes to handle geographical data, but are not recommended for general use.
Like other RDS databases, MariaDB is protected by AWS security features like VPCs and DB Security Groups. Just like RDS for MySQL, user privileges are handled by IAM. You can modify DB Instance settings like DB instance class, Multi-AZ deployment, allocated storage, storage-type, master password, security group, and retention period. MariaDB usually performs a cache warming for better performance. However in AWS, if you choose Provisioned IOPS storage, cache warming is not required.
As of the current release (10.0.17), Amazon RDS does not support the following MariaDB features:

  • MariaDB Galera Cluster
  • HandlerSocket
  • Multi-source Replication
  • Storage engine-specific object attributes, as described in Engine-defined New Table/Field/Index
  • Attributes

Setting Up MariaDB on RDS:

Let’s see how we can set up MariaDB through the AWS Management Console.

  • Select MariaDB Community Edition as your database:
MariaDB vs MySQL
  • Specify your usage profile:
MariaDB vs MySQL
  • Specify DB details:
MariaDB vs MySQL
  • Set advanced settings like Network and Security, Database Options, Backup and, on the next page, Maintenance Window:
MariaDB vs MySQL
  • Click “Launch DB Instance”.

You can also set up MariaDB using the AWS CLI. The following syntax (and its optional arguments) will launch MariaDB on RDS:

rds-create-db-instance db-instance-identifier
[-a (--db-security-groups) value[,value...] ]
[-sg (--vpc-security-group-ids) value[,value...] ]
[-au (--auto-minor-version-upgrade) value ]
[-b (--preferred-backup-window) value ]
-c (--db-instance-class) value
[-cs (--character-set) value ]
[-ct (--copy-tags-to-snapshot) value ]
-e (--engine) value
[-g (--db-parameter-group-name) value]
[--iops value ]
[-st (--storage-type) value ]
[-se (--storage-encrypted) value ]
[--kms-key-id value ]
-lm (--license model) value
[-m (--multi-az) value]
[-n (--db-name) value ]
[-og (--option-group) value ]
-p (--master-user-password) value
[--port value ]
[-r (--backup-retention-period) value ]
-s (--allocated-storage) value
[-sn (--db-subnet-group-name) value ]
-u (--master-username) value
[-v (--engine-version) value ]
[-w (--preferred-maintenance-window) value]
[-pub (--publicly-accessible) value ]
[-tca (--tde-credential-arn) value ]
[-tcp (--tde-credential-password) value ]
[-tk (--tag-key) value ]
[-tv (--tag-value) value ]
[-z (--availability-zone) value ]

MariaDB and Amazon EC2:

Of course, there’s nothing stopping you from setting up MariaDB yourself on an Amazon EC2 instance. You will need to import a MariaDB Signing Key:

sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDBStarting

…and then create a file “MariaDB.repo” in /etc/yum.repos.d/

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enable=1

You install MariaDB server and client using:

 yum install MariaDB-server MariaDB-client

To start the service, run:

/etc/init.d/mysql start

You can also choose from a number of MariaDB AMIs in the AWS Marketplace. The AMI images are documented here.

MariaDB vs MySQL: conclusion

MariaDB support from AWS has been long expected. With this new release, Amazon expanded its RDS portfolio in a significant way. Though there is only one version that’s supported so far, that could change in the coming months. Being one of the world’s most popular databases, MariaDB on AWS adds opportunities for Amazon and its many users.

Interested in learning more about databases on AWS? Try Cloud Academy’s hands-on Amazon RDS lab or our AWS Database Fundamentals course.

Avatar

Written by

Chandan Patra

Cloud Computing and Big Data professional with 10 years of experience in pre-sales, architecture, design, build and troubleshooting with best engineering practices. Specialities: Cloud Computing - AWS, DevOps(Chef), Hadoop Ecosystem, Storm & Kafka, ELK Stack, NoSQL, Java, Spring, Hibernate, Web Service


Related Posts

Avatar
Stuart Scott
— October 16, 2019

AWS Security: Bastion Host, NAT instances and VPC Peering

Effective security requires close control over your data and resources. Bastion hosts, NAT instances, and VPC peering can help you secure your AWS infrastructure. Welcome to part four of my AWS Security overview. In part three, we looked at network security at the subnet level. This ti...

Read more
  • AWS
Avatar
Sudhi Seshachala
— October 9, 2019

Top 13 Amazon Virtual Private Cloud (VPC) Best Practices

Amazon Virtual Private Cloud (VPC) brings a host of advantages to the table, including static private IP addresses, Elastic Network Interfaces, secure bastion host setup, DHCP options, Advanced Network Access Control, predictable internal IP ranges, VPN connectivity, movement of interna...

Read more
  • AWS
  • best practices
  • VPC
Avatar
Stuart Scott
— October 2, 2019

Big Changes to the AWS Certification Exams

With AWS re:Invent 2019 just around the corner, we can expect some early announcements to trickle through with upcoming features and services. However, AWS has just announced some big changes to their certification exams. So what’s changing and what’s new? There is a brand NEW ...

Read more
  • AWS
  • Certifications
Alisha Reyes
Alisha Reyes
— October 1, 2019

New on Cloud Academy: ITIL® 4, Microsoft 365 Tenant, Jenkins, TOGAF® 9.1, and more

At Cloud Academy, we're always striving to make improvements to our training platform. Based on your feedback, we released some new features to help make it easier for you to continue studying. These new features allow you to: Remove content from “Continue Studying” section Disc...

Read more
  • AWS
  • Azure
  • Google Cloud Platform
  • ITIL® 4
  • Jenkins
  • Microsoft 365 Tenant
  • New content
  • Product Feature
  • Python programming
  • TOGAF® 9.1
Avatar
Stuart Scott
— September 27, 2019

AWS Security Groups: Instance Level Security

Instance security requires that you fully understand AWS security groups, along with patching responsibility, key pairs, and various tenancy options. As a precursor to this post, you should have a thorough understanding of the AWS Shared Responsibility Model before moving onto discussi...

Read more
  • AWS
  • instance security
  • Security
  • security groups
Avatar
Jeremy Cook
— September 17, 2019

Cloud Migration Risks & Benefits

If you’re like most businesses, you already have at least one workload running in the cloud. However, that doesn’t mean that cloud migration is right for everyone. While cloud environments are generally scalable, reliable, and highly available, those won’t be the only considerations dri...

Read more
  • AWS
  • Azure
  • Cloud Migration
Joe Nemer
Joe Nemer
— September 12, 2019

Real-Time Application Monitoring with Amazon Kinesis

Amazon Kinesis is a real-time data streaming service that makes it easy to collect, process, and analyze data so you can get quick insights and react as fast as possible to new information.  With Amazon Kinesis you can ingest real-time data such as application logs, website clickstre...

Read more
  • amazon kinesis
  • AWS
  • Stream Analytics
  • Streaming data
Joe Nemer
Joe Nemer
— September 6, 2019

Google Cloud Functions vs. AWS Lambda: The Fight for Serverless Cloud Domination

Serverless computing: What is it and why is it important? A quick background The general concept of serverless computing was introduced to the market by Amazon Web Services (AWS) around 2014 with the release of AWS Lambda. As we know, cloud computing has made it possible for users to ...

Read more
  • AWS
  • Azure
  • Google Cloud Platform
Joe Nemer
Joe Nemer
— September 3, 2019

Google Vision vs. Amazon Rekognition: A Vendor-Neutral Comparison

Google Cloud Vision and Amazon Rekognition offer a broad spectrum of solutions, some of which are comparable in terms of functional details, quality, performance, and costs. This post is a fact-based comparative analysis on Google Vision vs. Amazon Rekognition and will focus on the tech...

Read more
  • Amazon Rekognition
  • AWS
  • Google Cloud Platform
  • Google Vision
Alisha Reyes
Alisha Reyes
— August 30, 2019

New on Cloud Academy: CISSP, AWS, Azure, & DevOps Labs, Python for Beginners, and more…

As Hurricane Dorian intensifies, it looks like Floridians across the entire state might have to hunker down for another big one. If you've gone through a hurricane, you know that preparing for one is no joke. You'll need a survival kit with plenty of water, flashlights, batteries, and n...

Read more
  • AWS
  • Azure
  • Google Cloud Platform
  • New content
  • Product Feature
  • Python programming
Joe Nemer
Joe Nemer
— August 27, 2019

Amazon Route 53: Why You Should Consider DNS Migration

What Amazon Route 53 brings to the DNS table Amazon Route 53 is a highly available and scalable Domain Name System (DNS) service offered by AWS. It is named by the TCP or UDP port 53, which is where DNS server requests are addressed. Like any DNS service, Route 53 handles domain regist...

Read more
  • Amazon
  • AWS
  • Cloud Migration
  • DNS
  • Route 53
Alisha Reyes
Alisha Reyes
— August 22, 2019

How to Unlock Complimentary Access to Cloud Academy

Are you looking to get trained or certified on AWS, Azure, Google Cloud Platform, DevOps, Cloud Security, Python, Java, or another technical skill? Then you'll want to mark your calendars for August 23, 2019. Starting Friday at 12:00 a.m. PDT (3:00 a.m. EDT), Cloud Academy is offering c...

Read more
  • AWS
  • Azure
  • cloud academy content
  • complimentary access
  • GCP
  • on the house