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.

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

Amanda Cross
Amanda Cross
— January 7, 2021

New Content: AWS Terraform, Java Programming Lab Challenges, Azure DP-900 & DP-300 Certification Exam Prep, Plus Plenty More Amazon, Google, Microsoft, and Big Data Courses

This month our Content Team continues building the catalog of courses for everyone learning about AWS, GCP, and Microsoft Azure. In addition, this month’s updates include several Java programming lab challenges and a couple of courses on big data. In total, we released five new learning...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Avatar
Stuart Scott
— December 17, 2020

Where Should You Be Focusing Your AWS Security Efforts?

Another day, another re:Invent session! This time I listened to Stephen Schmidt’s session, “AWS Security: Where we've been, where we're going.” Amongst covering the highlights of AWS security during 2020, a number of newly added AWS features/services were discussed, including: AWS Audit...

Read more
  • AWS
  • AWS re:Invent
  • cloud security
Joe Nemer
Joe Nemer
— December 4, 2020

AWS re:Invent: 2020 Keynote Top Highlights and More

We’ve gotten through the first five days of the special all-virtual 2020 edition of AWS re:Invent. It’s always a really exciting time for practitioners in the field to see what features and services AWS has cooked up for the year ahead.  This year’s conference is a marathon and not a...

Read more
  • AWS
  • AWS Glue Elastic Views
  • AWS re:Invent
Bryony Harrower
Bryony Harrower
— November 6, 2020

WARNING: Great Cloud Content Ahead

At Cloud Academy, content is at the heart of what we do. We work with the world’s leading cloud and operations teams to develop video courses and learning paths that accelerate teams and drive digital transformation. First and foremost, we listen to our customers’ needs and we stay ahea...

Read more
  • AWS
  • Azure
  • content roadmap
  • GCP
Joe Nemer
Joe Nemer
— October 25, 2020

Excelling in AWS, Azure, and Beyond – How Danut Prisacaru Prepares for the Future

Meet Danut Prisacaru. Danut has been a Software Architect for the past 10 years and has been involved in Software Engineering for 30 years. He’s passionate about software and learning, and jokes that coding is basically the only thing he can do well (!). We think his enthusiasm shines t...

Read more
  • AWS
  • careers
  • champions
  • upskilling
Joe Nemer
Joe Nemer
— October 14, 2020

New Content: AWS Data Analytics – Specialty Certification, Azure AI-900 Certification, Plus New Learning Paths, Courses, Labs, and More

This month our Content Team released two big certification Learning Paths: the AWS Certified Data Analytics - Speciality, and the Azure AI Fundamentals AI-900. In total, we released four new Learning Paths, 16 courses, 24 assessments, and 11 labs.  New content on Cloud Academy At any ...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Joe Nemer
Joe Nemer
— September 15, 2020

New Content: Azure DP-100 Certification, Alibaba Cloud Certified Associate Prep, 13 Security Labs, and Much More

This past month our Content Team served up a heaping spoonful of new and updated content. Not only did our experts release the brand new Azure DP-100 Certification Learning Path, but they also created 18 new hands-on labs — and so much more! New content on Cloud Academy At any time, y...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Joe Nemer
Joe Nemer
— August 28, 2020

AWS Certification Practice Exam: What to Expect from Test Questions

If you’re building applications on the AWS cloud or looking to get started in cloud computing, certification is a way to build deep knowledge in key services unique to the AWS platform. AWS currently offers 12 certifications that cover major cloud roles including Solutions Architect, De...

Read more
  • AWS
  • AWS Certifications
Patrick Navarro
Patrick Navarro
— August 25, 2020

Overcoming Unprecedented Business Challenges with AWS

From auto-scaling applications with high availability to video conferencing that’s used by everyone, every day —  cloud technology has never been more popular or in-demand. But what does this mean for experienced cloud professionals and the challenges they face as they carve out a new p...

Read more
  • AWS
  • Cloud Adoption
  • digital transformation
Avatar
Andrew Larkin
— August 18, 2020

Constant Content: Cloud Academy’s Q3 2020 Roadmap

Hello —  Andy Larkin here, VP of Content at Cloud Academy. I am pleased to release our roadmap for the next three months of 2020 — August through October. Let me walk you through the content we have planned for you and how this content can help you gain skills, get certified, and...

Read more
  • alibaba
  • AWS
  • Azure
  • content roadmap
  • Content updates
  • DevOps
  • GCP
  • Google Cloud
  • New content
Alisha Reyes
Alisha Reyes
— August 5, 2020

New Content: Alibaba, Azure AZ-303 and AZ-304, Site Reliability Engineering (SRE) Foundation, Python 3 Programming, 16 Hands-on Labs, and Much More

This month our Content Team did an amazing job at publishing and updating a ton of new content. Not only did our experts release the brand new AZ-303 and AZ-304 Certification Learning Paths, but they also created 16 new hands-on labs — and so much more! New content on Cloud Academy At...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Alisha Reyes
Alisha Reyes
— July 16, 2020

Blog Digest: Which Certifications Should I Get?, The 12 Microsoft Azure Certifications, 6 Ways to Prevent a Data Breach, and More

This month, we were excited to announce that Cloud Academy was recognized in the G2 Summer 2020 reports! These reports highlight the top-rated solutions in the industry, as chosen by the source that matters most: customers. We're grateful to have been nominated as a High Performer in se...

Read more
  • AWS
  • Azure
  • blog digest
  • Certifications
  • Cloud Academy
  • OWASP
  • OWASP Top 10
  • Security
  • VPCs