We performed a comparison between MariaDB and MySQL based on real PeerSpot user reviews.
Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Installation is straightforward."
"The most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
"It's a very easy product to set up."
"It is very simple to install, and the commands are exactly the same as MySQL."
"The product has been stable and reliable."
"MariaDB is scalable."
"MariaDB is stable and the initial setup is straightforward."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"The connectivity with PHP is quite good."
"The solution is very stable."
"I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance."
"The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
"The most valuable feature of MySQL is the informative error outputs of command line interface."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"I’m not sure if it can scale."
"MariaDB could be improved by adding more automation."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"MariaDB doesn't handle long or complex SQL queries quite as well as Oracle Database."
"The solution should do some fine-tuning on maybe the transaction per second so that users can get more than they can on the Microsoft SQL Server."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
"The customer service and support are okay. But the response time is slow. Moreover, the material is not available freely."
"It should provide better customer experiences."
"On the database side, it should be really lightweight, and the data structure should be like MongoDB."
"The licensing of the solution is on the expensive side."
"The GUI could improve to make MySQL better."
"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
"The full-text search feature must be improved."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
MariaDB is ranked 4th in Open Source Databases with 52 reviews while MySQL is ranked 1st in Open Source Databases with 142 reviews. MariaDB is rated 8.2, while MySQL is rated 8.2. The top reviewer of MariaDB writes "Easy to deploy, cost-effective, and integrates seamlessly with other products". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". MariaDB is most compared with SQL Server, Oracle Database, Firebird SQL, PostgreSQL and Percona Server, whereas MySQL is most compared with Firebird SQL, PostgreSQL, Teradata, SAP HANA and SQL Server. See our MariaDB vs. MySQL report.
See our list of best Open Source Databases vendors and best Relational Databases Tools vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.