MariaDB logo

MariaDB

An enhanced, drop-in replacement for MySQL
3.7K
2.7K
+ 1
472

What is MariaDB?

Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
MariaDB is a tool in the Databases category of a tech stack.
MariaDB is an open source tool with 3.1K GitHub stars and 928 GitHub forks. Here’s a link to MariaDB's open source repository on GitHub

Who uses MariaDB?

Companies
720 companies reportedly use MariaDB in their tech stacks, including Docplanner, Grooveshark, and MAK IT.

Developers
2948 developers on StackShare have stated that they use MariaDB.

MariaDB Integrations

Tutum, Liquibase, Galera Cluster, Rackspace Cloud Database, and PuPHPet are some of the popular tools that integrate with MariaDB. Here's a list of all 32 tools that integrate with MariaDB.

Why developers like MariaDB?

Here’s a list of reasons why companies and developers use MariaDB
MariaDB Reviews

Here are some stack decisions, common use cases and reviews by companies and developers who chose MariaDB in their tech stack.

Tassanai Singprom
Tassanai Singprom
JavaScript
JavaScript
PHP
PHP
HTML5
HTML5
jQuery
jQuery
Redis
Redis
Amazon EC2
Amazon EC2
Ubuntu
Ubuntu
Sass
Sass
Vue.js
Vue.js
Firebase
Firebase
Laravel
Laravel
Lumen
Lumen
Amazon RDS
Amazon RDS
GraphQL
GraphQL
MariaDB
MariaDB
Google Analytics
Google Analytics
Postman
Postman
Elasticsearch
Elasticsearch
Git
Git
GitHub
GitHub
GitLab
GitLab
npm
npm
Visual Studio Code
Visual Studio Code
Kibana
Kibana
Sentry
Sentry
BrowserStack
BrowserStack
Slack
Slack

This is my stack in Application & Data

JavaScript PHP HTML5 jQuery Redis Amazon EC2 Ubuntu Sass Vue.js Firebase Laravel Lumen Amazon RDS GraphQL MariaDB

My Utilities Tools

Google Analytics Postman Elasticsearch

My Devops Tools

Git GitHub GitLab npm Visual Studio Code Kibana Sentry BrowserStack

My Business Tools

Slack

See more
AWS Elastic Beanstalk
AWS Elastic Beanstalk
Heroku
Heroku
Ruby
Ruby
Rails
Rails
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
MariaDB
MariaDB
Microsoft SQL Server
Microsoft SQL Server
Amazon RDS
Amazon RDS
AWS Lambda
AWS Lambda
Python
Python
Redis
Redis
Memcached
Memcached
AWS Elastic Load Balancing (ELB)
AWS Elastic Load Balancing (ELB)
Amazon Elasticsearch Service
Amazon Elasticsearch Service
Amazon ElastiCache
Amazon ElastiCache

We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

See more
Abdullah Erdoğan
Abdullah Erdoğan
Developer at Prizma · | 6 upvotes · 31.3K views
Visual Studio
Visual Studio
Git
Git
GitLab
GitLab
MariaDB
MariaDB
nginx
nginx
Linux
Linux
.NET
.NET
.NET Core
.NET Core

Visual Studio Git GitLab MariaDB nginx Linux

Visual Studio 2019 is increasing my productivity incredibly when I building MVC WebAPI and Web project. GitLab is essential tools for me. Issue boards are great as well as Source code safe in GitLab. The most amazing thing is Microsoft's new strategy on .NET enviroment for me. I love .NET Core 's cross platform support. I can deploy my projects on Linux via nginx and .NET Core runtime or self host options. MariaDB become our first choose database option because of its great talents.

See more
Joshua Dean Küpper
Joshua Dean Küpper
CEO at Scrayos UG (haftungsbeschränkt) · | 5 upvotes · 50.7K views
atScrayos UG (haftungsbeschränkt)Scrayos UG (haftungsbeschränkt)
MariaDB
MariaDB
PostgreSQL
PostgreSQL
GitLab
GitLab
Sentry
Sentry

We primarily use MariaDB but use PostgreSQL as a part of GitLab , Sentry and @Nextcloud , which (initially) forced us to use it anyways. While this isn't much of a decision – because we didn't have one (ha ha) – we learned to love the perks and advantages of PostgreSQL anyways. PostgreSQLs extension system makes it even more flexible than a lot of the other SQL-based DBs (that only offer stored procedures) and the additional JOIN options, the enhanced role management and the different authentication options came in really handy, when doing manual maintenance on the databases.

See more
Nicolas de Mauroy
Nicolas de Mauroy
Founder at Open Lowcode · | 5 upvotes · 4.3K views
atOpen LowcodeOpen Lowcode
MariaDB
MariaDB

We use MariaDB because it is a free open-source SQL database. I was looking for a low-cost technical stack, and SQL database made a huge sense as it is transactional, and offers all the confort of relational queries, which, for me, is better for general purpose database than noSQL alternatives.

MariaDB is the really free drop-in replacement for mysql, which makes it a good default choice. Note that at some point, I plan to support also Post/gre SQL, which is the other famous SQL open-source database in the enterprise world.

See more
StackShare Editors
StackShare Editors
MySQL
MySQL
MariaDB
MariaDB

Airbnb’s web experience is powered by a Rails monolith, called Monorail, that talks to several different Java services. MySQL databases store business data and are partitioned by functionality, with messages and calendar management, for example, stored separately from the main booking flow in their own databases.

As traffic to the site continued growing, though, “one notable resource issue with MySQL databases [was] the increasing number of database connections from application servers.”

Airbnb uses AWS’s Relational Database Service (RDS) to power their MySQL instances, and “RDS uses the community edition of MySQL server, which employs a one-thread-per-connection model of connection management.” With Airbnb’s scale, this meant that their databases would hit the C10K problem, which states that “there is an upper bound in the number of connections that MySQL server can accept and serve without dramatically increasing the number of threads running, which severely degrades MySQL server performance.”

When an RDS MySQL server hits resource limits, users will have trouble connecting to the site.

MySQL does have dynamic thread pooling, but it’s only available in the enterprise edition; AWS MySQL RDS, though, doesn’t offer this feature, meaning Airbnb didn’t have access to dynamic thread pooling out-of-the-box.

After surveying several options, the team chose MariaDB MaxScale, which is “a MySQL database proxy that supports intelligent query routing in between client applications and a set of backend MySQL servers.”

Instead of using the MariaDB MaxScale off-the-shelf, however, they decided to fork it and implement their own version that would include connection pooling. Other MaxScale features, like request throttling and query blocklisting were implemented as well.

To enable horizontal scaling of the web application, the team deployed a MaxScale database proxy service in between app servers and MySQL servers. Through the service discovery system SmartStack, applications now “discover and connect to the database proxy service instead of the MySQL database,” allowing horizontal scaling to meet capacity demands.

Additionally, new Airbnb MaxScale proxy server instances can be launched to further enable horizontal scaling.

See more

MariaDB's Features

  • Replication
  • Insert Delayed
  • Events
  • Dynamic
  • Columns
  • Full-text
  • Search
  • GIS
  • Locale
  • Settings
  • subqueries
  • Timezones
  • Triggers
  • XML
  • Functions
  • Views
  • SSL
  • Show Profile

MariaDB Alternatives & Comparisons

What are some alternatives to MariaDB?
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
Percona
It delivers enterprise-class software, support, consulting and managed services for both MySQL and MongoDB across traditional and cloud-based platforms.
Oracle
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
See all alternatives

MariaDB's Followers
2707 developers follow MariaDB to keep up with related blogs and decisions.
Yusuf Hadiwinata Sutandar
AlgorithmCreative
Ezzat Makar
phathwa
Lalit Nayyar
Watscho Aiwasov
M Can Yılmaz
Tobias Bielohlawek
Rahul Kumar
Ayush Singh