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

Joe Nemer
Joe Nemer
— April 3, 2020

Breaking News: All AWS Certification Exams Now Available Online

Remote proctoring for all AWS certifications Cloud Academy is an Advanced AWS Technology Partner, and we are happy to announce all AWS certification exams are available online!  What does this mean for you? You can stay focused on your certification goal. Or you can start a certifica...

Read more
  • AWS
  • AWS certification
  • AWS Certifications
Connie Benton
Connie Benton
— April 1, 2020

How To Build a Career with AWS Certifications

From Iaas and PaaS solutions to digital marketing, cloud computing reshapes the world of technology. As the influence of this technology grows, so does investment. Tens of billions of dollars are being spent on cloud computing-related services each year. This influx is continuing to inc...

Read more
  • AWS
  • Certifications
Vijayakumar Athithan
Vijayakumar Athithan
— March 27, 2020

What is Cognito in AWS?

Web applications usually allow a valid username and password combination for successful sign in to the application. Modern authentication flows incorporate more approaches to ensure user authentication. When using AWS, this is no exception, thanks to the abilities and features offered b...

Read more
  • AWS
  • AWS Cognito
  • Solutions Architect
Avatar
Andrew Larkin
— March 20, 2020

The 12 AWS Certifications: Which is Right for You and Your Team?

As companies increasingly shift workloads to the public cloud, cloud computing has moved from a nice-to-have to a core competency in the enterprise. This shift requires a new set of skills to design, deploy, and manage applications in cloud computing. As the market leader and most ma...

Read more
  • AWS
  • AWS Certifications
Alisha Reyes
Alisha Reyes
— March 17, 2020

Cloud Academy’s Blog Digest: How Do AWS Certifications Increase Your Employability, How to Become a Microsoft Certified Azure Data Engineer, and more

With everything going on right now, it's likely that the only thing you've been reading lately is related to the coronavirus pandemic. It's important to stay informed during these times, but it's also good to jump into something that can take your mind off of the current situation for j...

Read more
  • AWS
  • Azure
  • blog digest
  • Certifications
  • Cloud Academy
  • programming
  • Security
Avatar
Cloud Academy Team
— March 13, 2020

Which Certifications Should I Get?

As we mentioned in an earlier post, the old AWS slogan, “Cloud is the new normal” is indeed a reality today. Really, cloud has been the new normal for a while now and getting credentials has become an increasingly effective way to quickly showcase your abilities to recruiters and compan...

Read more
  • AWS
  • Azure
  • Certifications
  • Cloud Computing
  • Google Cloud Platform
Alisha Reyes
Alisha Reyes
— March 7, 2020

New on Cloud Academy: Intro to GitOps; AWS Courses; Java, Python, Amazon Linux 2, Ubuntu, & Docker Playgrounds; and much more

New Lab Playgrounds This month, our Content Team released six new "playground labs." Our playground labs provide a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions — all without having to instal...

Read more
  • AWS
  • Azure
  • gitops
  • Google Cloud Platform
  • lab playground
  • programming
Alisha Reyes
Alisha Reyes
— March 6, 2020

New on Cloud Academy: Intro to GitOps; AWS Courses; Java, Python, Amazon Linux 2, Ubuntu, & Docker Playgrounds; and much more

New Lab Playgrounds This month, our Content Team released six new "playground labs." Our playground labs provide a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions — all without having to instal...

Read more
  • AWS
  • Azure
  • gitops
  • Google Cloud Platform
  • lab playground
  • programming
Patrick Navarro
Patrick Navarro
— March 4, 2020

AWS Certifications: How Do They Increase Your Employability and Progress Your Career?

AWS certifications are no walk in the park. They’re designed to validate in-depth, specialist knowledge and comprehensive experience, often requiring months of dedicated studying to earn even for those already working with the cloud platform. But the rewards that AWS professionals ca...

Read more
  • AWS
  • AWS certification
  • certification
Avatar
Chandan Patra
— February 21, 2020

Elasticsearch vs. CloudSearch: AWS Cloud Search Choices

Elasticsearch vs. CloudSearch: What's the main difference? Let's compare AWS-based cloud tools: Elasticsearch vs. CloudSearch. While both services use proven technologies, Elasticsearch is more popular, open source, and has a flexible API to use for customization; in comparison, CloudS...

Read more
  • AWS
  • Azure
  • cloudsearch
  • elasticsearch
Avatar
Andrew Larkin
— February 13, 2020

Cloud Academy Content Roadmap Updates

Welcome to our Q1 2020 roadmap. This is the content we plan to build over the next three months, between February 1 - and April 30, 2020. Let's look at some of our roadmap highlights. Atlassian Bamboo for CI/CD We had a lot of requests for practical guides on how to apply DevOps tool...

Read more
  • Artificial Intelligence
  • AWS
  • Azure
  • Docker
  • Google Cloud Platform
  • Kubernetes
  • Machine Learning
Alisha Reyes
Alisha Reyes
— February 7, 2020

New on Cloud Academy: Git Labs, CKA and CKAD Lab Challenges, AWS and Azure Learning Paths, AGILE, and Much More

We just kicked off our first Free Weekend of 2020. This means we've unlocked our Training Library for just 72 hours. Until Sunday at 11:59 pm (PST), you can get unlimited access to our industry-leading learning paths, courses, certification prep exams, and our most popular hands-on labs...

Read more
  • agile
  • AWS
  • Azure
  • Google Cloud Platform
  • Linux
  • OWASP
  • programming
  • red hat
  • scrum