Skip to main content
TrustRadius
MariaDB Platform

MariaDB Platform

Overview

What is MariaDB Platform?

MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database,…

Read more
Recent Reviews

TrustRadius Insights

MariaDB TX Cluster has been widely used in various industries and organizations, serving as a reliable and efficient solution for a wide …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is MariaDB Platform?

MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and…

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://mariadb.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

32 people also want pricing

Alternatives Pricing

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

Return to navigation

Product Details

What is MariaDB Platform?

MariaDB Platform is an enterprise open source database solution, able to support transactional, analytical and hybrid workloads as well as relational, JSON and hybrid data models. And it has the scalability to grow from standalone databases and data warehouses to fully distributed SQL for executing millions of transactions per second and performing interactive, ad hoc analytics on billions of rows. MariaDB can be deployed on prem on commodity hardware, is available on all major public clouds and through MariaDB SkySQL as a fully managed cloud database.

Other resources:
5 Key Steps for Selecting Your Ideal DBaaS
Guide to Open Source Database Selection: MariaDB vs. MySQL
Enterprise Database Comparison Guide – MariaDB vs. MS, IBM and Oracle

MariaDB Platform Features

  • Supported: Cloud DBaaS: SkySQL
  • Supported: Workloads: transactions, analytics and smart transactions (HTAP)
  • Supported: Transactional scalability: distributed SQL
  • Supported: Analytical scalability: columnar data with massively parallel processing
  • Supported: Development: temporal tables, JSON documents and geospatial support
  • Supported: High availability: automatic failover and transaction replay
  • Supported: Disaster recovery: online backups and point-in-time restore
  • Supported: Security: transparent data encryption and dynamic data masking
  • Supported: Oracle Database compatiblity: data types, sequences and PL/SQL

MariaDB Platform Video

MariaDB is the open source database that empowers today's business, to build a better tomorrow. With an ocean of possibilities, what will you do with MariaDB?

MariaDB Platform Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Centos, Debian, RHEL, SLES, Ubuntu
Mobile ApplicationNo

Frequently Asked Questions

MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and Temporal Data Tables, allowing one to query the data as it stood at any point in the past.

Microsoft SQL Server, Db2, and Amazon Relational Database Service (RDS) are common alternatives for MariaDB Platform.

Reviewers rate Support Rating highest, with a score of 8.7.

The most common users of MariaDB Platform are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(76)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

MariaDB TX Cluster has been widely used in various industries and organizations, serving as a reliable and efficient solution for a wide range of applications. Users have migrated their operations from Oracle to MariaDB, finding it to be an efficient and reliable database for finance-related services. Additionally, MariaDB is being utilized in academic computing and research projects, providing a quick setup without the need for complex database administration. This has enabled institutions like Pomona College to focus more on their core objectives instead of spending valuable time and resources on managing databases.

Many applications and services heavily rely on MariaDB as their database server. For example, the Eduroam Authentication Service and Stoa, a social collaborative net and learning platform, use MariaDB to ensure smooth and reliable data storage. Furthermore, MariaDB is highly regarded as a drop-in replacement for MySQL, offering performance and stability upgrades without requiring changes to legacy applications. Its simplicity and practical maintenance-free nature make it suitable for low-maintenance systems.

Moreover, MariaDB is utilized in production environments where high availability is essential. The Enterprise 3-node cluster setup leverages improvements in InnoDB performance and SQL-mode features to provide robust database solutions. Whether it's content apps, configuration management, or contest apps, MariaDB serves as the main relational database solution for multiple applications requiring reliable storage.

In addition to these key use cases, organizations have successfully employed MariaDB for storing flattened data from various sources, addressing the need for working with disparate data. Users have also found value in using front-end UI tools like Heidi SQL to overcome command line limitations when leveraging the power of MariaDB. Moreover, MariaDB finds its application in monitoring solutions, open-source projects, and even as a backup option for replication scenarios.

The Aviation division of one company relies on MariaDB as its primary database server, supporting internal business tools that require reliable data storage. Customers have also reported great satisfaction with the product's ability to replicate data across multiple sites without the high costs associated with other database solutions. Moreover, reviewers have praised MariaDB for its performance and value, thanks to its flexible engines that allow for tuning based on the needs of different applications and data.

Overall, MariaDB has become a go-to choice for organizations of all sizes and industries. Its simplicity, reliability, and versatility have fueled its adoption for various use cases, making it a preferred database solution both internally and externally. From simple web applications to mission-critical systems, MariaDB has proven to be a valuable asset in managing and storing data. Another significant use case for MariaDB is its application in clustered setups with manual sharding. By utilizing multiple engines like Spider, Connect, Federated, MyISAM, Memory, InnoDB, and potentially ColumnStore, organizations can optimize data access and ensure efficient storage. This approach enables companies to handle large amounts of data while maintaining optimal performance and scalability.

Furthermore, MariaDB's licensing advantages and free software nature make it a popular choice for mission-critical applications. It serves as a reliable and cost-effective option for hosting various applications, including widely used platforms like WordPress and Magento. Many organizations have chosen MariaDB as their go-to relational database solution for both internal and third-party applications.

Beyond traditional database usage, MariaDB plays a crucial role in collecting and sending data to centralized servers while maintaining top performance. This decentralization capability allows organizations to distribute their data efficiently without sacrificing reliability or speed.

In terms of user experiences, customers have reported great satisfaction with MariaDB's performance and value. They appreciate the product's ability to provide replicated data across multiple sites without incurring high costs typically associated with other database solutions. Additionally, users have praised the fast and thorough support provided by the MariaDB team, ensuring smooth operations and quick issue resolution.

Overall, the versatility of MariaDB has positioned it as a dependable choice across various industries and applications. From serving as the primary relational database for critical systems to powering simple web applications quickly, MariaDB's simplicity, ease of use, reliability, and ability to handle diverse use cases make it an invaluable tool for businesses seeking robust database storage solutions.

High Availability: Many users have praised MariaDB TX Cluster for providing high availability, which is crucial for their business needs. This feature ensures that their databases are always accessible and minimizes downtime.

Performance Improvement: Several reviewers have mentioned the great advantage of using the proxy for MariaDB, MaxScale, as it significantly improves performance. Users appreciate the faster response times and enhanced efficiency they experience when using this feature.

Quick and Helpful Support: The prompt and helpful support provided by the MariaDB team has been highly appreciated by many users. They have stated that their questions were answered quickly and efficiently, making it easier for them to resolve any issues they encountered.

UI Lacking: Users have expressed dissatisfaction with the user interface of MariaDB, describing it as confusing and inefficient. They recommend incorporating UI tools similar to those offered by its competitors to enhance usability and streamline tasks. Some users feel that the current interface makes it difficult to perform tasks efficiently.

Replication Issues: Some users have encountered problems with replication in MariaDB, specifically related to table locks. They suggest that better troubleshooting tools be provided out of the box to address these issues effectively. This would help users resolve replication-related problems more easily.

Performance Impact: The addition of indexes to large tables and performing operations like altering the table has resulted in replication and storage issues, significantly impacting the overall performance of MariaDB. Users have reported experiencing slowdowns and delays due to these performance issues caused by certain database operations on large tables.

Attribute Ratings

Reviews

(1-25 of 29)
Companies can't remove reviews or game the system. Here's why
Score 7 out of 10
Vetted Review
Verified User
Incentivized
In a distributed application, on each host we have an instance of MariaDB Platform that collects data. Then every day the data is sent to a centralized server with another database. MariaDB Platform offers a great way to decentralize and to keep performances at top, including robustness and availability.
  • Easy to install
  • No big hardware required
  • Clear configuration files
  • Performances not comparable to e.g. Oracle
  • Indexes not always updated
  • Recovery procedures in case of dataloss are not linear
Of course it depends on the use you need your application, the scenario. Ideal if for "little" applications, not "corporate" ones. So if you are evaluating SQL server VS MariaDB Platform go straight with MariaDB, opensource, easy to move/backup, fast response (with a limited number of users in the same time)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have a MariaDb Cluster to store 2.2 TB of data with a manual sharding to optimize the access data. We use several engines like Spider, Connect, Federated, MyIsam, Memory and InnoDb. Currently, we are planning [to] add ColumnStore too. We also have a PoC with Galera for HA between managers and we did uses cases with Max Scale.
  • Simplicity
  • Open source
  • SQL standard
  • High cost horizontal scale
  • Kafka compatibility
  • JSON management
  • Applications where the users need [to] execute many short queries.
  • With new storage engines such as Aria, which allows to replace MyISAM with some improvements, and XtraDB, which evolves InnoDB.
  • To fuse the legacy features with the features available in NoSQL databases.
  • Connection management, which allows multiplying the number of concurrent accesses.
  • New clustering engines, such as Galera, which allow interesting possibilities for Cloud adoption.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is our primary database for user data.
  • SQL - Is well known and supports most types of usage cases for a database.
  • Open source - means there's lots of support and resources to develop on.
  • Multi-platform - runs on any operating system and doesn't tie it down.
  • Full text searches - slows startup to the extreme, leaks memory, can be buggy.
  • Startup process needs to be streamlined and with more output. You shouldn't need to debug the system to find out what the startup process is doing.
  • More consideration to using multiple databases. Most solutions seem to concentrate on single database products.
  • MariaBackup is buggy and might not work on larger databases. Taking backups or restoring them takes manual work. Could really need some easy to use tools and less hand scripting shell scripts.
MariaDB suits most use cases, but also needs expertise to use and debug. So if you haven't got experience in MariaDB/MySQL, some problem cases might be too difficult to solve without help.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is used across the whole organization. The main business problem that it address is to serve as a database for our own and third party applications.
  • Great stabiltity
  • Good performance on retrieving data
  • Easy configuration
  • Easy management
  • DDL operations do not work well on running MariaDB Cluster
  • Cluster management from CLI could be improved
If you use a MariaDB Cluster, it is well suited in scenarios where your tables don't change, because if you perform DDL operations on a running cluster, you will break it, so you must prepare a downtime window to perform this type of operations. If you don't need a cluster, I think MariaDB Platform works fine in almost every scenario.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is used for several in-house solutions with internal and customer visibility as well as a replica repository as the first stage of Analytic data. We use a combination of Galera and Primary Secondary with Maxscale as a load balancer and router. Currently, everything is on-prem but we are looking at migrating to the cloud.
  • Read/write split
  • Connection handling
  • Transaction replay
  • Service independence
  • Stats
  • Load Management
  • Galera Cluster for write heavy applications
  • Expanded Standard config templates
Different services, read-write split, replication are well suited. Write heavy with Galera Cluster presents challenges.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is our production database for clients' VRP.
  • Easy deployment.
  • Ample amount of tools to be used.
  • Documentation.
  • Initial setup needs to be improved (determining correct configuration values).
  • If replication fails, needs to be easier to recover.
  • More functionality in the Community Server.
Well Suited
For any relational data, one of the easiest databases to use

Less appropriate
Big Data is lacking.
Performance, manageability of data
December 14, 2020

RDBMS at its best

Score 9 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is our primary relational database. We have multiple databases including WordPress and Magento running on it.
  • High performance and availability.
  • Has an active open-source developer community.
  • Robust transactional support.
  • Availability of many storage engines.
  • MariaDB is no longer completely compatible with MySQL, which makes migration a tedious process.
  • Needs improvement in caching.
  • It doesn't support full outer joins.
  • Implementation of JSON datatype in MariaDB isn't ideal.
MariaDB is well suited for running secure ACID-compliant relational databases with vertical scaling support.
December 01, 2020

A Tiny Review of MariaDB

Score 10 out of 10
Vetted Review
Verified User
Incentivized
Initially we just use it as in place upgrade for MySQL as part of system regeneration, later it turned out that its performance was far better than the original MySQL that we replaced. Our system was designed to be low maintenance and less human interaction, therefore we need a database system that quite simple and practically maintenance-free.
  • Aria engine support, the improved MyISAM, it deliver faster performance with less required buffer than InnoDB, also almost a maintenance free table that less fragmented, no need to optimize so often.
  • Based on out experience, having smaller memory requirement.
  • With proper setup, it is fast.
  • It will nice to have Aria engine be able to perform concurrent SELECT and INSERT/UPDATE like in InnoDB.
We aware that Oracle is half-heartedly developing MySQL, therefore an in-place upgrade to a database system that still supported & actively develop will be needed. For this scenario, MariaDB is fit perfectly.
October 09, 2020

MariaDB Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are using MariaDB Enterprise 3-node cluster setup in production with 10.4.13 version and on top of the cluster using max scale router to load balance read/write OLTP traffic. In the 10.4 version, there is a lot of improvement done for InnoDB performance and especially the changes regarding the instance drop of any table fields. I also found very useful the use of the SQL-mode feature for strict typecasting.
  • Strict type checking with default mode on for STRICT_TRANS_TABLES
  • Instant drop column operation (instant add column is already available), a big part of schema changes can be performed ad hoc
  • MariaDB 10.4 will benefit from faster extension of VARCHAR columns, additionally, character set and collation changes on non-indexed columns will be instant.
  • MariaDB 10.4 comes with an option for expiring user password
  • Galera 26.4 - MariaDB 10.4 will benefit from a new Galera version with features like streaming replication or improved SST thanks to backup locks.
  • MariaDB 10.4 you can set SQL-mode = MSSQL
  • Explain and analyze works as a separate command as compared to other MySQL products
MariaDB is well suited when it comes to making any DDL changes or DML changes in DB objects.
José Javier Dominguez Reina | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We currently have 2 installations of MariaDB TX Cluster formed by 3 nodes each installation.
One installation is in the pre-production environment and another is in the production environment.
In MariaDB TX Cluster we have the databases of two of the main applications of the company, which in addition to having internal use also have public use from the internet.
  • High availability through the MariaDB TX Cluster.
  • Performance improvement with proxy for MariaDB, MaxScale.
  • Great support, respond quickly to questions.
  • Constant evolution of the product.
  • Improving the migration of databases from MySQL to Maria DB, by default they are done easily but as there is an error it is costly to solve it.
  • Some minor bugs in MariaDB version updates.
Our installation scenario is a MariaDB cluster composed of 3 nodes to achieve high availability in the service and in this way the application that accesses the backend (MariaDB) is always working and is not down at any time.

To achieve high performance of the application when accessing the database, a MariaDB MaxScale has been mounted that acts as a proxy for queries to the database.

Score 10 out of 10
Vetted Review
Verified User
Incentivized
My team is currently using MariaDB Enterprise to store data for several customer-facing microservices that delivery critical weather data in the form of alerts and reports. To the best of my knowledge we are the only team in our division that uses it. Previously we were using a NoSQL implementation but it was not a good fit for the types of data we store. Moving to a relational model has made a huge improvement in performance and reliability. We specifically chose MariaDB as it supports a multi-region replication model.
  • Replication - Works extremely well and has very reasonable latency.
  • Monitoring - There is no shortage of tools for monitoring clusters.
  • Reliability - Rock-solid product that appears to be quite resilient.
  • I honestly can't think of anything I'd change.
Given that MariaDB is a relational database, it is best suited for situations where data integrity is a necessity and said data is highly structured. It is a little more difficult to scale so having a consistent load is also a plus since you can plan for capacity more easily.
If being able to scale easily and dynamically is import then MariaDB might not be a good fit. Also if data consistency is less important than speed or flexibility then there are other database models (document, key-value store, etc.) that may be a better fit.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
My company provides finance-related services to customers, using our own proprietary software. We process customer transactions and store customer data in our own data center. MariaDB is our production RDBMS software - one way to look at it is that it's the bedrock on which everything rests.

We also use MariaDB for development and testing, of course. We used to be an Oracle shop but over the course of time, we migrated all of our operations to MariaDB. It meets the needs of a relatively small business efficiently and reliably.
  • Simpler learning curve. MariaDB is a cleaner, simpler system that is (IMO) easier to learn and easier to manage effectively than many other database systems.
  • Lower hardware requirements. After migrating to MariaDB from another database software system, we find that our hardware needs have substantially decreased.
  • MariaDB support is very responsive. It's like they actually care. On the few occasions we've run into technical issues, support has always come through with what we needed. Once it was showing me a relatively new feature the server supported that I wasn't aware of, that, once I was able to properly make use of it helped me resolve a serious production performance issue.
  • Architectural flexibility. As an example, the ready availability of synchronous (Galera) versus asynchronous replication schemes without being locked into one of the other by enormous technical complexity or punitive licensing, allows the customer to find what really works best for their needs.
  • Complications from the single, global shared ibdata1 (which may be considered more an InnoDB limitation).
  • Backups and restores, especially if you do partial (per db) backups. Actually the backups work very well but the restores are not pleasant.
  • Certain weaknesses in Galera. Because of the way it works it doesn't handle very large single transactions very well (I understand that has improved in recent releases, but that was after we moved away from Galera), and there are altogether too many ways to stall an entire Galera cluster - you will find them.
For a smaller company with fewer resources and less of an established investment in other database software (including having paid the substantial premium for staff expertise with that other software), MariaDB is an excellent idea. It's easier to learn, easier to manage, easier to license.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use MariaDB for all of our customer-facing applications. It provides replicated data across multiple sites without the high costs of many other DB solutions. It delivers great performance at a great price with flexible engines that allow tuning based on the needs of your data and applications. Their support is fast and thorough.
  • Query optimization
  • Table partitioning
  • Relational and non-relational data
  • Adding servers to replication series (playing catchup)
MariaDB is an economical, scale-able, relational database.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is the main data base solution for almost all the applications we are developing that require storing data in relational database. It's used for storing content and parts of websites as well as some configuration. It's also used for simple contest apps that require entry code checkout. Software development team is mainly working with MariaDB but apps, website or tools based on MariaDB are used across all organization.
  • It's easy to use for software development team members with knowledge of SQL.
  • It's better than standard MySQL solutions, it's a little bit faster.
  • It's also often required for some applications that we use for example CMS.
  • While using with large data it's slowing.
It's really good as a database for CMS, small apps. Its relational structure is well suited for organizing structured data used while building web apps and other web solutions.

It is noticeably slowing when working on tables with 10-20+ millions of rows. We had cases when we made operations, for example select or insert, on over 60 millions rows and some of them took a few seconds. It was crucial to use faster servers to achieve better latency.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are using MariaDB as our database choice for one service in our microservice architecture.
MariaDB is one of our go-to choices for relational database system if we need to launch a simple web application quickly without the need for any complex feature in the application or database itself. Its simplicity and ease of use are definitely the most appealing aspects for us.
  • Simple, easy to install and upgrade.
  • Mature.
  • Massive user base which makes it easier to find support when needed.
  • Lack of advanced features.
  • Caching performance is lackluster compared to PostgreSQL or SQL Server.
  • Arguably prone to error since it doesn't distinguish data as accurate as PostgreSQL for example.
MariaDB is more suited if you need to quickly launch a simple application or store simple data. Its simplicity to download, install, and upgrade is one of the main strength for us. However, for more complex use case that requires more out of the box solution or needs a high precision, I don't think MariaDB is suitable.
February 18, 2020

MariaDB: good OLTP db

Anson Abraham | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Vital db for quite a large number of our applications used internally and externally. The database is used for some management tools used by the infrastructure team. Externally it's being used for reporting to our customers as well as holding some of the metadata. MariaDB is tied into Galera which also helps out considerably for high availability.
  • Fast writes. Writes are fast, where it depends on the hardware.
  • Reads are fast. Putting into memory is easy.
  • Functions and procedures are easy to implement.
  • Paritioning is nicely implemented.
  • Bloating. Can't reduce the size of idx log file, especially when data is truncated from tables. Space is not reclaimed. Need to find way to "shrink" file.
  • Writes are dependent on hardware. If hardware isn't great, writes will be effected. If that can still be solved through software.
  • Flushing of cache data is not as fast as it should be. There can be cases of malformed data.
If you need a robust and scalable OLTP rdbms, MariaDB works. If you need an OLAP, MariaDB is not for you. Look elsewhere. If you implement Galera, then you'll have a high availability database engine. No one true master, all masterless/slaveless. If you need to use a DB for management tools like Cloudera, etc... then MariaDB works.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use MariaDB to host databases for applications used by both employees and customers. It is managed and hosted by IT, but is used to host data for a wide variety of mission-critical services. Because MariaDB is free software, we are able to use it without some of the licensing concerns that we face with other database systems.
  • Reliability - MariaDB handles heavy usage loads well for high-traffic applications.
  • Easy Administration - For those who are familiar with MySQL, MariaDB is easy to administer and configure.
  • Cost - MariaDB is free to use.
  • Driver Support - Some third party applications use database drivers that cause unexplained slowness with MariaDB. This can be worked around by using the MySQL drivers, but it's not clear what causes the problem in the first place.
  • Support - While online communities are helpful in diagnosing problems, there isn't as much professional documentation/support available for MariaDB as some of the other major database options.
  • Data Visualization - It would be helpful if there were more built in options for analyzing statistics and generating reports.
MariaDB is especially helpful for organizations that are currently using MySQL but would like to move to a product with friendlier licensing terms. This is easier to do if you have an in-house programming team that can implement integrations on their own, as some outside firms will sometimes prefer to work with other database solutions that have more restrictive/expensive licensing.
Jason Smith, DPA | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is being used for all our academic computing and research projects at Pomona College where an relational database is needed. The problem that is solves for us is that we can get projects and development up quick on MariaDB without having to have to worry about complex DBA stuff or dealing with expensive licences. Lot's of out online infrastructure uses MariaDB and most anything that is currently on MySQL will be moved to MariaDB.
  • MariaDB does well with PHP or Python (django) in a web environment. Developers are able to work quickly.
  • MariaDB is extremely well documented and has a gigantic support community. If you need ask a question on how to do things you can go to many placces online and find answers quickly.
  • MariaDB is fast! Queries with tens of thousands of rows are quick.
  • MariaDB is highly compatible with Oracle's MySQL. Basically the same thing but more open and with a brighter future.
  • With MariaDB it is so easy to import and export data, and backups are a cinch. This saves me so much time as compared to other RDBMS.
  • I can honestly sat that there is no area where MariaDB needs improvement. Nothing is hard to use, the learning curve is just the nature of the product. I see no missing functionality, add ting things would only be unwanted bloat.
MariaDB works well in a web development environment using PHP or Python. We have also used it in a Tomcat environment. I do not see any reason to use any other database such as Oracle, Informix, or any MySQL server. In my opinion they all under perform MariaDB when it comes to performance and ease of administration. MariaDB is very scalable. You can use the same instance for small projects with a few hundred rows or with a few million. MariaDB is powerful and that power can be found in its command line which makes the manipulation of any data easy, especially when the SQL is not of a proprietary nature.
February 07, 2019

MariaDB Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is being used across our entire organization for various databases. Various different teams use MariaDB and rely on it to maintain their backend application. We implement monitoring and metrics for MariaDB to ensure we are getting the best performance out of our databases. MariaDB can be replicated on other servers for high availability
  • Stores data
  • Backwards compatible with MySQL
  • Opensource
  • Simple to setup
  • Easy query language
  • Query language doesn’t support working with arrays.
  • Doesn’t support full outer joins.
  • Not guaranteed to be 100% compatible with MySQL.
MariaDB is best for use cases where MySQL was previously being used but due to licensing or not wanting to use Oracle's MySQL, you can use MariaDB. For the most part, it's a drop in replacement supporting the same syntax as MySQL, requiring no changes in applications which use it, meaning MySQL Databases can be migrated to MariaDB.
August 28, 2018

MariaDB vs. MySQL

Dan Mahoney | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MariaDB is being used across a division of the company (Aviation division). It is the primary database server for our internal business tools.
  • We are seeing more security releases than we did when we were running MySQL
  • Very large queries complete more quickly on MariaDB than they do on MySQL
  • Setting up Master-Master replication is more straightforward in MariaDB than it is in MySQL
  • MariaDB doesn't yet have a Memcached interface
  • CHECKSUM TABLE can give different results in MariaDB than in MySQL
MariaDB is a good fit for most cases where MySQL is being considered.

In cases where the database will never get very large, MySQL might be a better choice. Queries can take a little longer in MariaDB if MariaDB is using the default configuration, just because the default config. includes the Aria engine.
Parry Ghuman | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is used for storing web services data on microgrid control. The same product is also used to store weather data to analyze the electricity consumption in the future.
  • It gives better performance with a large amount of data.
  • Easy to switch from SQL database.
  • Help to take backups for integration and testers.
  • Hard to implement relational queries.
  • The graphical user interface should be more attractive.
  • It does not show or allow to add a filter to the execution plan.
Easy to switch from another database. Installation is very easy and integration team always prefers to solve issues using MariaDB tool.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used in both internal applications and also in applications and services that are sold to external customers. The software that is being developed in-house uses MariaDB as a database and it is also used when the software is deployed to clustered production environments. MariaDB works as a free and open solution for software that requires a database to function.
  • Easy to switch to it from MySQL. No client side re-configuration or re-programming is needed.
  • Developed by open community.
  • Widely supported in all environments and software.
  • It's not guaranteed to be 100% compatible with MySQL (especially newer versions). However I've never encountered problems with this.
  • Could have some UI tools incorporated into it like its competitors.
MariaDB suits perfectly if you want to switch away from Oracle-owned MySQL but still want to keep maximum compatibility and minimize efforts required for migration. It's also a perfect choice for any use case where usage of a relational database has been decided. However if for some reason you need enterprise-level support for your database solution, the choice for MariaDB might need some more thought since it's entirely community-driven.
June 06, 2017

MariaDB Review

Andrew Meyer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I use MariaDB for monitoring solutions and an open source project. It's easy to use and I can always find great support. I also have it in a replicated scenario so if something were to happen then I have a backup. This is a great product and would definitely recommend it for someone trying to learn new things!
  • SQL
  • Applications
  • Replication
  • Fixing replication issues still needs some work
[It's a] multi-server open-source application.
Stênio Pereira Filho | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MariaDB actually is used in our Eduroam Authentication Service thats provide authentication to +200 thousand local wifi users. It is being used as database server in other important service called Stoa, that is a big social collaborative net and learning platform used by students and teachers. Security is a special focus for ours developers and we happy with MariaDB. When some critical security issue is discovered, we receive immediately a new version of MariaDB to get the fix.
  • Synchronous multi-master cluster that permits to develop high availability applications
  • Compatible with applications developed to MySQLDB.
  • Not much modification required
  • Quicker security releases. You don't need to wait about 2 or 3 months to security patches.
  • MariaDB is developed fully in the open: all development decisions can be reviewed and debated on a public mailing list of in the public bug tracker
  • We still do not have confidence in using MariaDB in our administrative systems because we do not have experience to use it in critical systems
  • We can consider that It is developed mainly by a small company and the future of MariaDB maybe is uncertain (!) (?).
  • On the other hands, we didn't find other cons of this software
MariaDB is well suited in scenarios where it is possible to use open source software and scenarios that demands active-active clusters. MariaDB is maintained to date with the latest version of MySQL and will work just like MySQL. All the commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert the databases to switch to MariaDB. But in critical systems we do not risk using it yet.
September 28, 2016

MariaDB > MySQL

Casey Smith | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We're currently using MariaDB to store flattened data from other various sources for quick searching. It addresses the problem of needing to work with data from disparate sources.
  • It has many speed improvements over MySQL.
  • It offers better time precision over MySQL.
  • It adheres to open source methodologies and testing, which MySQL has moved away from since Oracle took it over.
  • It could use a memcached interface.
  • Although it is traditionally thought of as a binary drop-in replacement for MySQL, some incompatibilities have come up since version 5.1
MariaDB is well suited for general purpose RDBMS needs or anywhere you need a DB that's simple to set up. For example, it is a breeze to use in Docker containers.
Return to navigation