TrustRadius
MariaDB is an open-source database.https://media.trustradius.com/product-logos/Sz/zD/L4K60PQV3H3F.PNGMariaDBEasy and simple RDMBS based on an open-sourced platform2019-02-26T16:38:57.178ZMariaDB is used in our organization to handle medium/small sized DB with non-mission critical applications. It is used for information lookup and small-sized reporting.,Standard RDMBS which runs on an open-sourced platform
Performance is enough for small to medium-sized applications
Low cost,Within our organization we put so much effort into maintaining software security, do we believe MariaDB should handle the security patch better.
Certain that join performance could improve
Support model is still a concern for mission critical applications,8,Free license
Runs on cheap Linux commodity hardware
Works well and is fast enough on most cases,MySQL,DB2,8Feng CaiMariaDB vs. MySQL2018-08-28T18:41:06.259ZMariaDB 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,9,I can't answer this question, as I don't have access to information at that level.,MySQL and PostgreSQLDan MahoneyMariaDB Review2019-02-07T17:34:09.824ZMariaDB 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.,9,Open Source means we do not have to deal with licencing and can contribute back to the community
Not having to deal with Oracle
Drop in replacement for MySQL. No changes required on our applications.,MySQL, PostgreSQL, Amazon Relational Database Service, InfluxDB and MongoDB,Amazon Relational Database Service, MySQL, InfluxDB, Amazon Elastic Compute Cloud (EC2), Amazon CloudWatch, Nagios, Amazon Route 53, Google App Engine,10Verified UserEasy to store data with minimum CPU resources2018-05-24T16:06:32.815ZIt 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.,8,Helping to integrate to solve deadlock issues.
Reduces the business cost as it provides facility to handle a large amount of data on one server.
It takes fewer CPU resources while using it.,Eclipse, Microsoft Visual Studio Team System, NetBeansParry GhumanMariaDB: good OLTP db2018-01-17T16:29:01.373ZVital 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.,8,Implementing Galera. No downtime, no loss in revenue and monitoring.
ROI is dependent on hardware. If you spend for the hardware, your ROI might not be seen for quite awhile.
Not as much ease of administration as one would think. So time and effort are involved w/ the dba.,PostgreSQL, Oracle Database and Microsoft SQL Server,PostgreSQL, Cassandra, Oracle Database 12c, Microsoft SQL Server, MemSQLAnson AbrahamSQL database you can count on2018-02-01T22:34:44.190ZIt 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.,10,Free to use and openly developed. No license costs.
Widely known product by lots of people. Easy to find people who can work with it.
Stable and bug-free. Has worked well in production environments.,MySQL, MongoDB and Microsoft SQL Server,IntelliJ WebStorm, BitbucketVerified UserGreat Database server with free license and many features2016-11-08T22:08:57.414ZMariaDB 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,10,Low CAPEX if you have a team that use open source software day by day
Medium OPEX if you have a team that use open source software day by day
Perfect to use in academic ambient to support researchers and students,MySQL, PostgreSQL and Microsoft SQL Server,Moodle, WordPress, Apache CloudStack, XenServer, Slack, GoToMeeting, Skype for Business, ZimbraStênio Pereira FilhoMariaDB Review2017-06-06T18:49:32.945ZI 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,10,Low cost
No licenses
Quick to implement (under an hour),PostgreSQL and MongoDB,PostgreSQL, MongoDBAndrew MeyerMariaDB > MySQL2016-09-28T16:29:52.993ZWe'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,9,The fact that's it's open source and free has had a huge impact. We're in the process of moving away from Oracle and their cost per CPU pricing model.,MySQL,Oracle Database, RedisCasey SmithMaria DB Review2016-05-27T16:27:45.984ZMaria DB was utilised as a data storage tool for asset and geo calibration data. On its own, Maria DB would have struggled to meet the requirements of the users in question as they did not have sufficient experience in using command line. However Maria DB was successfully leveraged using the front UI of Heidi SQL.,Data Storage
Data processing
Data Retrieval,Stronger help
Better literature
For small to meddium volumes of data there is nothing wrong with MySQL,8,Working within a business (especially an older organisation) which is often resistant to change, it can be difficult to complete tasks that require new technology. The ability to utilise open source software like Maria DB is invaluable to circumnavigate the politics of an organisation’s budgetary limitations. In this case using Maria DB to store, handle and manipulate large volumes of data without having to rely on the on the standard Microsoft applications becomes heavily limited when even medium volumes of data is applied.,MongoDB and MySQL,dbForge Studio for SQL Server, Google Analytics, Webtrends OptimizeAndy G TeasdaleDrop-in replacement for MySQL, but without crashes2016-05-26T19:47:51.025ZWe use MariaDB as a drop-in replacement for MySQL. We benefit from the fact that it does not require changing the client side at all - we maintain some legacy applications that would not be easy (or even possible!) to change. At the same time, we benefit from the performance and stability upgrades that MariaDB offers over MySQL.,The primary reason for me to migrate from MySQL to MariaDB was its stability. I experience more than one crash with data corruption on MySQL's standard MyISAM and InnoDB; I haven't seen any with MariaDB.
I love progress reporting for ALTER TABLE queries. In MySQL you would be facing a long running ALTER TABLE query and have no way to know when it finishes. With MariaDB you see the progress in the process list (especially important if there's a boss breathing down your neck!)
I haven't done significant benchmarks, but MariaDB seems faster than MySQL. I think it is mostly evident when using subqueries.,MariaDB has added a lot of extra features over MySQL. However, I think one in particular is still missing - and really, just the one - an ability to compute median values from the data. I miss it in my work quite often.,10,The fact that MariaDB does not crash and the data is safe helped us provide a much more stable service and has generated thousands of dollars of revenue from the new clients we could sign up.
I don't think we would have stayed with MySQL for long and would have migrated to another database; thankfully MariaDB is compatible with the MySQL client side, so we did not have to do any development for the client side to replace the engine. Developer time saved!,MySQL, FirebirdSQL, Amazon Aurora and Amazon DynamoDB,CakePHP, Amazon Elastic Compute Cloud (EC2), Amazon S3 (Simple Storage Service), Amazon Relational Database Service, Amazon DynamoDB,Implemented in-house,No,No,9Rytis SlatkevičiusMariaDB Review2016-02-01T15:18:43.887ZI use MariaDB for every aspect of my database. I prefer using MariaDB over MySQL!,A bunch of third party storage engines.
Various performance enhancements.
Parallel replication and multi-source replication.,The future of MariaDB is uncertain. It is developed mainly by a small company that may not have as strong a future as Oracle. There have been and will continue to be MySQL improvements that will never make it into MariaDB.
MariaDB has basically forked off of MySQL 5.5, and it will not acquire all the features of MySQL 5.6 or future releases.,10,I really chose MariaDB for speed over MySQL.,MySQL and PostgreSQLBrandon CluffMariaDB implemetation first phase2016-08-05T15:54:35.620ZThe Engineering department uses MariaDB for its OLTP system. It solves the problem we had with NoSQL databases to give us an ACID compliant reliable database storage engine.,Gives us the flexibility to design data structures which can be joined to give data served by our APIs.
Provides us options to use multiple storage engines based on the data being stored.,Replication technology can definitely improve. Currently we face lot of issues with replication causing table locks.
Provide better troubleshooting tools out of the box, for example a comprehensive GUI like SSMS for SQL Server.
Alter table and add indexing is an overhead on large tables which causes replication and storage issues.,7,Positive - We have seen less time spent by support teams in investigations as they could join multiple tables to find the data.
Negative - We have seen a lot of table locks in the system due to replication and schema changes on large tables.,Microsoft SQL Server and CassandraVerified User
Unspecified
MariaDB
38 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
