Skip to main content

Why MariaDB instead of MySQL, PostgreSQL, or MongoDB?

·385 words·2 mins
Alejandro Duarte
Author
Alejandro Duarte
Alejandro Duarte is a Software Engineer, published author, and award winner. He currently works for MariaDB plc as a Developer Relations Engineer. Starting his coding journey at 13 with BASIC on a rudimentary black screen, Alejandro quickly transitioned to C, C++, and Java during his academic years at the National University of Colombia. Relocating first to the UK and then to Finland, Alejandro deepened his involvement in the open-source community. He’s a recognized figure in Java circles, credited with articles and videos amassing millions of views, and presentations at international events.

Can you tell us a little bit about your database and what makes it unique?
#

MariaDB is widely known for being a fork of MySQL. However, MariaDB is much more than that. It features multiple storage engines and components tailored to any kind of workload. If you need high-performance transactional capabilities, you have InnoDB, if you need fast analytical processing, you have ColumnStore. Read-heavy workloads? Use the Aria engine. Write-heavy workloads? You have MyRocks. Sharding? Go with the Spider engine. Do you need to scale both reads and writes? Use MariaDB Xpand. Do you want to use NoSQL queries in your application or export data to Kafka, use MaxScale.

Using the storage engines is as simple as saying CREATE TABLE or ALTER TABLE ENGINE=MyRocks or Aria or ColumnStore. It is that simple. And the cool thing is that you can run cross-engine SQL queries. Your application doesn’t need to become a persistence polyglot and handle multiple types of databases with their different connections and query languages.

What kind of businesses or organizations is your database best suited for? (What use cases is your database best suited for?)
#

As a truly scalable relational database that guarantees ACID properties and the possibility to be deployed on the cloud through SkySQL, or on-premise, or hybrid; MariaDB is a great option for supporting operational processes in web, mobile, and IoT applications. It also is the only distributed SQL database that offers both transactional and analytical capabilities through MariaDB Xpand�—a distributed SQL database that automatically slices and rebalances data among nodes in a dynamically scalable cluster while making this cluster look as if it was a single database to your application.

Can you provide any examples of customers who use your database in their operations?
#

If you are shopping online, listening to music, checking your bank account, reading a Wikipedia article, or even setting up a 5G antenna, MariaDB is likely the database behind those things. MariaDB has 1 billion downloads on Docker Hub and 75% of the Fortune 500 use it.

One of the most interesting users is Samsung. They are able to handle 80,000 requests per second with MariaDB. 80 thousand per second! That’s crazy! And there are many other interesting user stories in multiple industry verticals. I invite you to explore more at mariadb.com.

Enjoyed this post? I can help your team implement similar solutions—contact me to learn more.

Related

ChatGPT as a MariaDB database
·230 words·2 mins
ChatGPT is truly impressive. You can instruct it to do all sorts of things when they can be communicated in plain text.