MariaDBย vsย MySQLย vsย PostgreSQL

Need advice about which tool to choose?Ask the StackShare community!

MariaDB

10K
7.4K
+ 1
467
MySQL

75.5K
59.8K
+ 1
3.7K
PostgreSQL

56.9K
44.8K
+ 1
3.5K

PostgreSQL vs MySQL vs MariaDB - Help me Decide


PostgreSQL & MySQL are the two most popular open-source databases today.

The less popular MariaDB is a MySQL fork that happened after the acquisition of Sun Microsystems by Oracle on January 27, 2010.

Here's a graph representing the popularity of these 3 databases:

postgresql_vs_mysql_mariadb_db-ranking.png

(Source: db-engines.com)

PostgreSQL & MariaDB have been gaining ground recently, while MySQL is slowly declining. But that's not enough to make a decision.

So which one should you choose?

Let's look at this from different angles.

Performance

By running some benchmarks you can get a rough idea of how these databases compare to each other in terms of performance.

For this article, we going to use the HammerDB benchmarking tool.

This tool implements a standardized performance test called TPC-C.

Here's the description:

"TPC-C involves a mix of five concurrent transactions of different types and complexity. The database is comprised of nine types of tables with a wide range of record and population sizes."

Here's the setup:

  • Ubuntu 18.04
  • 1 GB RAM
  • 1 CPU
  • MySQL 5.7.23
  • MariaDB 10.1
  • PostgreSQL 10.5
  • Default settings

We ran the tests for 5 minutes for each database.

Here are the results:

  • PostgreSQL 18534 TPM, 7972 NOPM
  • MySQL 14051 TPM, 4659 NOPM
  • MariaDB 21441 TPM, 7172 NOPM

The meaning of these two values (TMP & NOPM) is described like this:

"TPM values cannot be compared between different database types. The NOPM value is based on a metric captured from within the test schema itself. As such NOPM (New Orders Per Minute) is a performance metric independent of any particular database implementation and is the recommended primary metric to use."

postgresql_vs_mysql_mariadb_postgresql-perf.png

Like any benchmark the results depend on the specific scenario the tests are run in.

This particular benchmark tries to reproduce the workload of any industry that must manage, sell or distribute a product or service.

Knowing that, we can conclude that both PostgreSQL & MariaDB are faster than MySQL in this particular scenario, with PostgreSQL coming on top of the raw performance game.

Features

These 3 databases support all the basic SQL operations you would expect.

But when it comes to more advanced features there is a lot of variability between them.

For example, PostgreSQL supports materialized views, while MySQL doesn't.

Here's a feature comparison table:

Feature PostgreSQL MySQL MariaDB
Materialized Views โœ“ โœ– โœ–
Partial Indexes โœ“ โœ– โœ–
Array Data Type โœ“ โœ– โœ–
JSON Data Type โœ“ โœ“ โœ“
CHECK constraints โœ“ โœ– โœ“ (from version 10.2.1)
Replication โœ“ โœ“ โœ“
Full-Text Search โœ“ โœ“ โœ“
UPSERT โœ“ โœ“ โœ“
Common Table Expressions โœ“ โœ“ โœ“
Sequences โœ“ โœ– โœ“

Looking at this table we can conclude that PostgreSQL has the most features implemented.

Besides these features, you can find some behavior differences.

For example, this query:

select 1000/0;

Returns NULL in MySQL, while PostgreSQL & MariaDB (since version 10.2.4) return a division by zero error.

This can be changed with SQL modes in MySQL.

Administration & Monitoring Tools

Because databases are critical software components there are dozens of tools available for administration, monitoring & troubleshooting.

Starting with the command-line applications:

  • mysql (MySQL, MariaDB)
  • psql (PostgreSQL)

These are great for basic administration tasks.

Why?

Because they come built-in with their respective servers so they are always available. There is nothing extra to install.

They both have a command history available, so you can re-run previously executed queries & commands.

And they have a set of bult-in commands that can facilitate interacting with the database.

For example, psql has the \d command to list all your databases, and mysql has the status command to get information like the server version & uptime.

Official graphical tools are also available.

They are:

Here's a screenshot from pgAdmin4:

![pgAdmin4]https://img.stackshare.io/stackups/postgresql_vs_mysql_mariadb_pgAdmin4.png)

And for MySQL Workbench:

postgresql_vs_mysql_mariadb_MySQL_Workbench_Mainscreen_Mac.png

Now we move onto more specialized tools like pghero (PostgreSQL).

PgHero is "a performance dashboard for Postgres".

Here's a screenshot:

postgresql_vs_mysql_mariadb_pgHero.png

For MySQL, and MariaDB, you can use MySQL Tuner. This is a Perl script that will analyze your configuration file & database statistics to produce configuration recommendations.

Here's a screenshot:

postgresql_vs_mysql_mariadb_mysqltuner.png

There are also log-parsing tools to help you find slow queries.

Here's pt-query-digest for MySQL, a tool for analyzing your logs & running queries to find the slowest queries so you can optimize them.

As you can see in this screen, it's also a command-line tool:

postgresql_vs_mysql_mariadb_pt-query-digest.png

And here is pgBadger for PostgreSQL:

postgresql_vs_mysql_mariadb_pgBadger.png

pgBadger is like pt-query-digest, but it will analyze PostgreSQL logs & slowest queries.

It looks like PostgreSQL has more graphical tools available, so if you are more comfortable using tools with graphical frontends, instead of command-line applications, then you may want to keep this in mind when making your decision.

Extensibility

You can install plugins & extensions if you need extra features for your database.

Extending MySQL & MariaDB is mostly done in the form of UDFs (User-Defined Functions), which are small plugins written in C.

However, it doesn't seem to be a very popular feature, so it's hard to find any useful UDF extensions.

PostgreSQL has some helpful extensions:

  • PostGIS adds spatial search capabilities for geographic information systems (GIS)
  • HStore allows you to use key-value storage without having to install a specialized database
  • Multicorn allows you to query other sources of data (like Redis, Amazon S3, or even Twitter!) as if they were real tables

If you need any of these extensions then PostgreSQL might be a great choice for you.

Final Considerations

To make a good decision you should consider what your needs are.

  • Is your application going to do a lot of work with geographic information? Then the PostGIS extension would be of great help.
  • Could your application benefit from specific features that each database supports, like materialized views or partial indexes? Then choose that database.
  • Do you need more hosting & support options? Then MySQL or MariaDB may be a better fit.

We hope you found this comparison useful!

Advice on MariaDB, MySQL, and PostgreSQL
Soufiane L
Needs advice
on
PostgreSQL
MySQL
and
MongoDB

I'm planning to build a freelance marketplace website, using tools like Next.js, Firebase Authentication, Node.js, but I need to know which type of database is suitable with performance and powerful features. I'm trying to figure out what the best stack is for this project. If anyone has advice please, Iโ€™d love to hear more details. Thanks.

See more
Replies (3)
malekmfs
at Meam Software Engineering Group ยท | 6 upvotes ยท 24.2K views
Recommends
PostgreSQL

Postgres and MySQL are very similar, but Mongo has differences in terms of storage type and the CAP theorem. For your requirement, I prefer Postgres (or MySQL) over MongoDB. Mongo gives you no schema which is not always good. on the other hand, it is more common in NodeJS community, so you may find more articles about Node-Mongo stuff. I suggest to stay with RDBMS if possible.

See more
Ruslan Rayanov
Recommends
MySQL

We have a ready-made engine for the online exchange and marketplace. To customize it, you only need to know sql. Connecting any database is not a problem. https://falconspace.site/list/solutions

See more
Nurullah SERT
Recommends
PostgreSQL
MySQL

This is a little about experience. Postgresql is fine. You can use either the related table structure or the json table structure.

See more
View all (3)
Dennis Kraaijeveld
Needs advice
on
PostgreSQL
MongoDB
and
ExpressJS

For learning purposes, I am trying to design a dashboard that displays the total revenue from all connected webshops/marketplaces, displaying incoming orders, total orders, etc.

So I will need to get the data (using Node backend) from the Shopify and marketplace APIs, storing this in the database, and get the data from the back end.

My question is:

What kind of database should I use? Is MongoDB fine for storing this kind of data? Or should I go with a SQL database?

See more
Replies (3)
Arash JalaliGhalibaf
Software Engineer at Cafe Bazaar ยท | 10 upvotes ยท 36K views
Recommends
PostgreSQL

Postgres is a solid database with a promising background. In the relational side of database design, I see Postgres as an absolute; Now the arguments and conflicts come in when talking about NoSQL data types. The truth is jsonb in Postgres is efficient and gives a good performance and storage. In a comparison with MongoDB with the same resources (such as RAM and CPU) with better tools and community, I think you should go for Postgres and use jsonb for some of the data. All in all, don't use a NoSQL database just cause you have the data type matching this tech, have both SQL and NoSQL at the same time.

See more
Recommends
MongoDB

I have found MongoDB easier to work with. Postgres and SQL in general, in my experience, is harder to work with. While Postgres does provide data consistency, MongoDB provides flexibility. I've found the MongoDB ecosystem to be really great with a good community. I've worked with MongoDB in production and it's been great. I really like the aggregation system and using query operators such as $in, $pull, $push.

While my opinion may be unpopular, I have found MongoDB really great for relational data, using aggregations from a code perspective. In general, data types are also more flexible with MongoDB.

See more
Luciano Bustos
Senior Software Developer ยท | 1 upvotes ยท 26.6K views
Recommends
PostgreSQL

I will use PostgreSQL because you have more powerfull feature for data agregation and views (the raw data from shopify and others could be stored as is) and then use views to produce diff. kind of reports unless you wanna create those aggregations/views in nodejs code. HTH

See more
View all (3)
Krunal Shah
Needs advice
on
PostgreSQL
and
MongoDB

I want to store the data retrieved from multiple APIs and perform some analytics on it. The data stored in DB will never/hardly change. First, I thought it would be better to retrieve the data and create table columns for them, but some data might have different columns than others. So I thought about storing the JSON response from API directly to the table and use it. So which database will be the better choice, PostgreSQL or MongoDB.

See more
Replies (6)
Nikhil Gurnani
Sr. Backend Engineer at Grappus ยท | 8 upvotes ยท 33.7K views
Recommends
MongoDB

Hey Krunal, your requirement sounds pretty clear and specific to what you want to do with that data. My recommendation to you, would be to use MongoDB. Since schema-less IO is faster in MongoDB, your general speed of reading / writing from and to the database would be quick. Additionally, the aggregate framework is very powerful with large data so that is also something that you can use in computing your analytics.

See more
Maxim Ryakhovskiy
Recommends
Mongoose
MongoDB

I suggest you to go with MongoDB, because it is schema-less, i.e., it permits you to easily manipulate the schema of a table. If you want to add a column, it can be done without much effort. Moreover, MongoDB can deal with more types of data, since the latest is stored as key-value pair. I do not what kind of analysis you are going to do, but NoSQL is not the best choice if you are going to use complex queries. In addition, if you are working with huge amount of data and you are interested in optimising the performance, I suggest you PostgreSQL. Since you are speaking about API and JSON, I guess that you may using Node JS for fetching API. I suggest you to try Mongoose, which facilitate the use of MongoDB with Node JS.

See more
Tarun Batra
Back End Developer at instabox ยท | 3 upvotes ยท 30.3K views

Looks like the use case is to store JSON data. mongoDB and Postgres differ in so many aspects like scaling and consistency. Postgres has excellent JSON support now with the power of SQL. MongoDB is good in handling schema less data. However in this case it seems these differences donโ€™t matter that much. Iโ€™d recommend you go with what you are most comfortable with.

See more
Bob Bass
President & Full Stack Enginee at Narro, LLC ยท | 3 upvotes ยท 30.1K views
Recommends
PostgreSQL
MySQL

This is largely a matter of opinion. I see that someone else responded and recommended MongoDB but since you are doing data analytics, I highly recommend you go with SQL. You're going to have a really hard time normalizing the data when you can't manipulate relationships and bulk edit with a nice update query.

I'm much more experienced with MySQL than any other database and I am having a hard time getting on board with noSQL entirely because it's really hard to query complex data with relationships using noSQL. I'm using Firestore with one of my apps and MongoDB with another app but they both use MySQL for the heavy lifting and then a document database for things like permissions, caching, etc.

It sounds like the type of problem you need to reverse engineer. I'm sure you can imagine what the data sets would look like if you use MongoDB or Postgres. I suspect that putting in a little bit more work up front will pay high dividends and productivity once the data is normalized.

Again - it's largely a matter of preference but I prefer SQL almost every time.

See more
Luiz H. Rapatรฃo
Senior Software Engineer at rapatao.com ยท | 3 upvotes ยท 30.2K views
Recommends
MongoDB

I don't have an unquestionable opinion regarding your use case. I only trend to pick the MongoDB since it is schemaless avoiding null columns that you not always know when it is used (it depends on the source of the data). The only drawback that I could consider is the query's complexity in MongoDB, sometimes it is a bit tricky, when compared to the traditional SQL queries.

See more
Recommends
MongoDB

MongoDB should be better for unstructured/less structured data.

See more
View all (6)
Decisions about MariaDB, MySQL, and PostgreSQL
Usman Sadiq
Student at University of Toronto ยท | 7 upvotes ยท 16.7K views
Migrated
from
PostgreSQL
to
MongoDB

MongoDB's document-oriented paradigm is nicely suited to the results of our ML model. We felt that this compatibility offered some time savings on figuring out and implementing an extensive data formatting and processing system. MongoDB's flexible schemas schemas (due to it being non-relational) were also attractive as a source of additional agility for our development process. The MongoDB ecosystem also has great GUI tools to simplify testing.

See more

Backend:

  • Considering that our main app functionality involves data processing, we chose Python as the programming language because it offers many powerful math libraries for data-related tasks. We will use Flask for the server due to its good integration with Python. We will use a relational database because it has good performance and we are mostly dealing with CSV files that have a fixed structure. We originally chose SQLite, but after realizing the limitations of file-based databases, we decided to switch to PostgreSQL, which has better compatibility with our hosting service, Heroku.
See more
Anthony Simon
Lead Engineer at Stylight ยท | 20 upvotes ยท 44.9K views

I try to follow an 80/20 distribution when it comes to my choice of tools. This means my stack consists of about 80% software I already know well, but I do allow myself 20% of the stack to explore tech I have less experience with.

The exact ratio is not whatโ€™s important here, itโ€™s more the fact that you should lean towards using proven technologies.

I wrote more about this on my blog post on Choosing Boring Technology: https://panelbear.com/blog/boring-tech/

See more
Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of MariaDB
Pros of MySQL
Pros of PostgreSQL
  • 149
    Drop-in mysql replacement
  • 100
    Great performance
  • 74
    Open source
  • 54
    Free
  • 44
    Easy setup
  • 15
    Easy and fast
  • 14
    Lead developer is "monty" widenius the founder of mysql
  • 6
    Also an aws rds service
  • 4
    Learning curve easy
  • 4
    Consistent and robust
  • 2
    Native JSON Support / Dynamic Columns
  • 1
    Real Multi Threaded queries on a table/db
  • 790
    Sql
  • 673
    Free
  • 557
    Easy
  • 527
    Widely used
  • 485
    Open source
  • 180
    High availability
  • 158
    Cross-platform support
  • 103
    Great community
  • 78
    Secure
  • 75
    Full-text indexing and searching
  • 25
    Fast, open, available
  • 14
    SSL support
  • 13
    Reliable
  • 13
    Robust
  • 8
    Enterprise Version
  • 7
    Easy to set up on all platforms
  • 2
    NoSQL access to JSON data type
  • 1
    Replica Support
  • 1
    Easy, light, scalable
  • 1
    Relational database
  • 1
    Sequel Pro (best SQL GUI)
  • 753
    Relational database
  • 506
    High availability
  • 436
    Enterprise class database
  • 379
    Sql
  • 298
    Sql + nosql
  • 171
    Great community
  • 145
    Easy to setup
  • 129
    Heroku
  • 128
    Secure by default
  • 111
    Postgis
  • 48
    Supports Key-Value
  • 46
    Great JSON support
  • 32
    Cross platform
  • 29
    Extensible
  • 26
    Replication
  • 24
    Triggers
  • 22
    Rollback
  • 21
    Multiversion concurrency control
  • 20
    Open source
  • 17
    Heroku Add-on
  • 14
    Stable, Simple and Good Performance
  • 13
    Powerful
  • 12
    Lets be serious, what other SQL DB would you go for?
  • 9
    Good documentation
  • 7
    Intelligent optimizer
  • 7
    Scalable
  • 6
    Transactional DDL
  • 6
    Modern
  • 6
    Reliable
  • 5
    Free
  • 5
    One stop solution for all things sql no matter the os
  • 4
    Relational database with MVCC
  • 3
    Faster Development
  • 3
    Full-Text Search
  • 3
    Developer friendly
  • 2
    Excellent source code
  • 2
    search
  • 2
    Great DB for Transactional system or Application
  • 1
    Full-text
  • 1
    Free version
  • 1
    Text
  • 1
    Open-source

Sign up to add or upvote prosMake informed product decisions

Cons of MariaDB
Cons of MySQL
Cons of PostgreSQL
    Be the first to leave a con
    • 14
      Owned by a company with their own agenda
    • 1
      Can't roll back schema changes
    • 9
      Table/index bloatings

    Sign up to add or upvote consMake informed product decisions

    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.

    What is 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.

    What is 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.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use MariaDB?
    What companies use MySQL?
    What companies use PostgreSQL?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with MariaDB?
    What tools integrate with MySQL?
    What tools integrate with PostgreSQL?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    Blog Posts

    Dec 8 2020 at 5:50PM

    DigitalOcean

    +11
    2
    1701
    +6
    2
    1469
    Nov 20 2019 at 3:38AM

    OneSignal

    +8
    7
    3733
    Jul 9 2019 at 7:22PM

    Blue Medora

    +8
    11
    1715
    What are some alternatives to MariaDB, MySQL, and PostgreSQL?
    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.
    Cassandra
    Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
    CouchDB
    Apache CouchDB is a database that uses JSON for documents, JavaScript for MapReduce indexes, and regular HTTP for its API. CouchDB is a database that completely embraces the web. Store your data with JSON documents. Access your documents and query your indexes with your web browser, via HTTP. Index, combine, and transform your documents with JavaScript.
    See all alternatives
    Reviews of MariaDB, MySQL, and PostgreSQL
    Review of
    MariaDB

    MySQL was founded by Allan Larsson, Michael Widenius and David Axmark in the year 1995, 19 years ago. It was released under the name of co-founder Michael Widenius daughter, โ€˜Myโ€˜. This project was released under GNU General Public License as well as under certain Proprietary License. MySQL was owned by MySQL AB firm until it went into the hands of Oracle Corporation. It is written in Programming Language โ€“ C and C++ and is available for Windows, Linux, Solaris, MacOS and FreeBSD.

    In the year 2009, Michael Widenius started working on MarisDB as a fork of MySQL. In the year 2012 the bricks of nonprofit MariaDB Foundation was laid. It was named after the founderโ€™s daughter Maria.

    MariaDB is a fork of MySQL Relational Database Management System which again is released under GNU General Public License. It is written in Programming Language โ€“ C, C++, Perl and Bash and is available for Systems Linux, Windows, Solaris, MacOS and FreeBSD.

    How developers use MariaDB, MySQL, and PostgreSQL
    AngeloR uses
    PostgreSQL

    We use postgresql for the merge between sql/nosql. A lot of our data is unstructured JSON, or JSON that is currently in flux due to some MVP/interation processes that are going on. PostgreSQL gives the capability to do this.

    At the moment PostgreSQL on amazon is only at 9.5 which is one minor version down from support for document fragment updates which is something that we are waiting for. However, that may be some ways away.

    Other than that, we are using PostgreSQL as our main SQL store as a replacement for all the MSSQL databases that we have. Not only does it have great support through RDS (small ops team), but it also has some great ways for us to migrate off RDS to managed EC2 instances down the line if we need to.

    Cloudcraft uses
    PostgreSQL

    PostgreSQL combines the best aspects of traditional SQL databases such as reliability, consistent performance, transactions, querying power, etc. with the flexibility of schemaless noSQL systems that are all the rage these days. Through the powerful JSON column types and indexes, you can now have your cake and eat it too! PostgreSQL may seem a bit arcane and old fashioned at first, but the developers have clearly shown that they understand databases and the storage trends better than almost anyone else. It definitely deserves to be part of everyone's toolbox; when you find yourself needing rock solid performance, operational simplicity and reliability, reach for PostgresQL.

    Brandon Adams uses
    PostgreSQL

    Relational data stores solve a lot of problems reasonably well. Postgres has some data types that are really handy such as spatial, json, and a plethora of useful dates and integers. It has good availability of indexing solutions, and is well-supported for both custom modifications as well as hosting options (I like Amazon's Postgres for RDS). I use HoneySQL for Clojure as a composable AST that translates reliably to SQL. I typically use JDBC on Clojure, usually via org.clojure/java.jdbc.

    Rajeshkumar T uses
    MySQL
    • We are used MySQL database to build the Online Food Ordering System

      • Its best support normalization and all joins ( Restaurant details & Ordering, customer management, food menu, order transaction & food delivery).
      • Best for performance and structured the data.
      • Its help to stored the instant updates received from food delivery app ( update the real-time driver GPS location).
    Srinivas Adireddi uses
    MySQL

    1.It's very popular. Heared about it in Database class 2. The most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. 3. MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

    ShadowICT uses
    MySQL

    We use MySQL and variants thereof to store the data for our projects such as the community. MySQL being a well established product means that support is available whenever it is required along with an extensive list of support articles all over the web for diagnosing issues. Variants are also used where needed when, for example, better performance is needed.

    ReviewTrackers uses
    PostgreSQL

    PostgreSQL is responsible for nearly all data storage, validation and integrity. We leverage constraints, functions and custom extensions to ensure we have only one source of truth for our data access rules and that those rules live as close to the data as possible. Call us crazy, but ORMs only lead to ruin and despair.

    shridhardalavi uses
    MySQL

    MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

    Jeff Flynn uses
    PostgreSQL

    Tried MongoDB - early euphoria - later dread. Tried MySQL - not bad at all. Found PostgreSQL - will never go back. So much support for this it should be your first choice. Simple local (free) installation, and one-click setup in Heroku - lots of options in terms of pricing/performance combinations.

    John Galbraith uses
    MySQL

    I am not using this DB for blog posts or data stored on the site. I am using to track IP addresses and fully qualified domain names of attacker machines that either posted spam on my website, pig flooded me, or had more that a certain number of failed SSH attempts.

    Scrayos UG (haftungsbeschrรคnkt) uses
    MariaDB

    Aside from Redis, we use MariaDB to store long-term information like user-data and big-data like regeneration-information for our open-world servers. We extensively use the relational aspects of MariaDB in joins, nested queries and unions.

    Seungkwon Park uses
    MariaDB

    mysql๋ณด๋‹ค mariaDB๊ฐ€ join๋ฉด์—์„œ ์šฐ์ˆ˜ํ•˜๋‹ค๋Š” ๋ฌธ์„œ๋ฅผ ์ฝ์—ˆ์Šต๋‹ˆ๋‹ค. ์ด ๋ถ€๋ถ„์€ ์ €์˜ ๋ธ”๋กœ๊ทธ์—์„œ๋„ ๋‹ค๋ค˜๊ณ  ์ €์˜ word press ๋ธ”๋กœ๊ทธ๋Š” mysql ๋Œ€์‹  mariaDB ๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

    ํŠนํžˆ limit ๊ธฐ๋Šฅ์ด pagenation ์ฒ˜๋ฆฌ๋ฅผ ํ•  ๋•Œ ๋„ˆ๋ฌด ์ง๊ด€์ ์ด๊ณ  ํŽธํ•ด์„œ mariaDB, mysql์„ ์‚ฌ๋ž‘ํ•ฉ๋‹ˆ๋‹ค.

    Ana Phi Sancho uses
    MariaDB

    Introduced in computer science course.managing relational database management systems, database analytics, and for data processing

    nrise uses
    MariaDB

    ์ˆ˜ ๋ฐฑ๋งŒ๊ฐœ๊ฐ€ ๋„˜๋Š” ํƒœ๊ทธ ํ‚ค์›Œ๋“œ์˜ ์ž๋™์™„์„ฑ์„ ์œ„ํ•ด์„œ ๋ณ„๋„์˜ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ๊ตฌ์ถ•ํ•˜์˜€์Šต๋‹ˆ๋‹ค. MariaDB ๋Š” MySQL ์„ ํฌํฌํ•œ ํ”„๋กœ์ ํŠธ์ž…๋‹ˆ๋‹ค. MySQL ๊ณผ์˜ ๊ฐ•๋ ฅํ•œ ํ˜ธํ™˜์„ฑ์„ ์ง€๋‹ˆ๋ฉฐ, ํฐ ํŠœ๋‹ ์—†์ด ๊ฐ•๋ ฅํ•œ ์„ฑ๋Šฅ์„ ๋ณด์žฅํ•ฉ๋‹ˆ๋‹ค.

    Dolls Kill uses
    MariaDB

    MariaDB has allowed us to easily scale out our DB cluster. Also has better replication tools than MySQL