MariaDB

Vorteile

What I like most about MariaDB is that if you know how to use MySQL then you will definitely know how to use MariaDB! With some added functionality and features it is much faster and it is pretty stable to use. The database is free to use, but lightweight in comparison to my sequel so it's perfect for starter to medium sized projects.

Nachteile

What I like least about MariaDB is that you will definitely need some guidance at first if you are not already familiar with this kind of software, especially when it comes to things like creating a new cluster. If you do run into a snag though the MariaDB community is very helpful and usually answer quick if you need a few pointers. There are also tons of forums and help guides you can refer to if need be.

Vorteile

It is so much faster than MySQL, especially when we alter the table structure of large tables it just works so much faster. The built in clustering features work quite well as well.

Nachteile

Starting a cluster is annoying. It's not overly hard, but you have to remember the statements. It would be a lot better if the startup script would say 'cannot attach to cluster, start a new one?' or something similar.
Despite the speed, we have had a couple of crashes where we could not startup the server. This has never happened to our MySQL servers, so that was a surprise. It may have been a specific 10.2 version on Ubuntu, because on our 18.04LTS servers this has not happened again.
Performance of the cluster when using INSERT IGNORE statements with 100,000s of records that are all duplicates is a lot slower than on MySQL.

In Betracht gezogene Alternativen

Warum MariaDB gewählt wurde

Gründe für den Wechsel zu MariaDB

Vorteile

it is a free database management system. it is good to store relational data.

Nachteile

There are many database that will be good alternative to MariaDB

Vorteile

MariaDB is our personal choice for the RDBMS in our training environment. it is simple to setup on linux as well as windows and is leightweigth yet performant. it starts quickly and does not take up too much space on disk.

I use mainly the terminal interface doing simple commands from the mysql command line. I like the fact that it is compatible with mysql (of which it is of course a fork). When i want to have a graphical overview of the databases and tables i use a separate tool called DBeaver to show the ERD and look at the tables.
Most of the time we work with a limited number of database records, but also have a complete dataset of all registered vehicles nationally (16+ million records) which is also performing. All within of course our training environment.

Nachteile

There is nothing I really dislike about it. It performs well, we can use it without incurring cost and it performs and is stable.

Vorteile

After Oracle which is a company for developing Databases, acquired MySQL which was the most popular database in the world. the Team behind developing Mysql forked the source code under the name MariaDB.
to insure Oracle is not going to kill MySQL in favor of it's proprietary database software. which makes MariaDB a very reliable open source community supported project.

Nachteile

Mariadb seems to work exactly like Mysql with very minor differnces.

Vorteile

It has very similar queue style and command styling to MySQL. But with additional functions. It is easy to adapt to and I can export or import any database in MariaDB software. It also has a lot of storage type which we definitely need it.

Nachteile

Migration sometimes can be hard especially when you are upgrading the software. But most of the time we can solve it on our own or with the help of the community of MariaDB.

Vorteile

I was a newbie when I start using MariaDB but the database was pretty easy to handle and use. This database can do competition with MySQL because both databases have good quality and usability. I know some developers and clients like MariaDB more than MySQL because MariaDB has an extra smoothness that makes the work more perfect. Its features, functionality, table management, edit are really good and comfortable to use, even it works fast and quickly when a command has been made.

Nachteile

I can remember just one negative side with MariaDB that is migration related. It wasn't a good experience when I tried to migrate data for the first time. It was complicated and I still feel that it's complicated!

Vorteile

It's quick to load and operate, and it's fairly stable. I appreciate that I can export my complete database to MariaDB; it's a little tricky at first, but after you get the hang of it, you'll be able to do a better job the next time you use it.
The database is free to use, but it's a much lighter than my sequel, so it's ideal for small to medium applications.

Nachteile

Honestly there isn't anything I hate about MariaDB, I wish more developers tried and used it.

Vorteile

The most appealing feature of MariaDB is its open-source license that allows us to use it freely in academia to teach relational database management courses. The setup and deployment are extremely easy and streamlines with a very intuitive phpmyadmin web interface. Before it was integrated with MySQL. After Oracle corporation changed the MySQL open-source license, MariaDb is now a great alternative that would really exceed the expectations in terms of developing and testing RDBMS concepts and models.

Nachteile

The performance lags in many cases especially when deploying on Cloud IaaS platforms. Though theses instances are not arising frequently but we believe that MariaDb can go a long way towards improving and becoming a fierce competitor to the big names in the RDBMs arena today.

Vorteile

The open source license makes MariaDB the most cost-effective RDBMS solution on the market today. It has the main features in the MySQL database, it is actually incepted by the MySQL developers with very similar functionality, performance, and client management.

Nachteile

We don't expect the performance to be up to the competitions with DBMS leaders such as Oracle and DB2. But still it is a great development and deployment RDBMS that can facilitate testing database applications before moving to another database in the production phase.

Vorteile

Nunca he tenido problemas con esta base de datos, la he instalado en varios diseños de páginas web que he realizado en WordPress y nunca he tenido problemas.

Nachteile

En algunas ocasiones cuando la Base de Datos crece mucho, observo que consume muchos recursos de mi servidor.

Vorteile

MariaDB est un gestionnaire de bases de données intégrer dans MySQL, pour vos projet web

Nachteile

MariaDB est limité en terme de capacité de données à stocker

Vorteile

J'utilise MariaDB dans des projets d'applications web et mobile, en tant que gestionnaire de bases de données

Nachteile

MariaDB est limité en terme de capacité de stockage de données, donc pas adapté à des projets de grandes capacités

Vorteile

In first time it's open source and it capacity of large amount of data management

Nachteile

Cluster creation is not simple to manage and some lack of interoperability with MySQL

Vorteile

I mostly like pulling and storing data using standard SQL queries. We can define reference as foreign keys which keep the integrity of data.Also, auto-increment key generation is very helpful. Datetime and timestamp data types are very helpful to sort the records.The limit keyword is also there to pull the data in a pagination manner.Integration of MariaDB is very simple. I have used MariaDB with Java frameworks like Spring, Dropwizard, and Struts 2 and didn't face a single issue regarding its connectivity.

Nachteile

The only thing is when a table grows much then pulling data using a SELECT query becomes slow than expected.

Vorteile

There is little you cannot do with it. Almost any database needs are covered by mariadb (formerly mysql) open source dbms. It is very fast, it provides many functions for data manipulation and if installed in good hardware it can take a huge load.

Nachteile

There is little to none to be unhappy about mariadb. Maybe we could talk about cluster performance and advanced functions for usage in the cloud, but still it covers 90% of use cases out there.

Vorteile

It is easy to work with database also the best for using to someone who is very familiar to using databases. This serves as a perfect database for industry usage also which makes its use easy for professionals.

Nachteile

MariaDB is not good for beginners as the documentation for it is quite heavy to understand for beginners.

Vorteile

Database optimization, data replication, data management

Nachteile

Instalation is very hard, especially for beginner

Vorteile

I like the functionalities that it has similar to its predecessor, but it is easier to use for new programmers. the great compatibility with mysql is reassuring because you don't need a lot of translator or start from scratch with the database

Nachteile

The only disadvantage that could arise would be in some case of incompatibility, but since they are very similar services we should not find any such case.

Vorteile

It is very much faster than MySQL, It can aslo be used to build web application for the clients. It has alot of features amazing functionalities and table and table management. Its 100% compatible and much important it is easy to use.

Nachteile

The price is bit expensive but free version also alot of work can be done.

Vorteile

What I appreciate the most about MariaDB is the interoperability it provides with the different DB administration tools, the compatibility, simplicity and robustness when handling large transactions places confidence in the product. I have been using it for 7 years with File Repositories DB.

Nachteile

When performing dumps and/or migrations, it is usually a little problematic. It is necessary to use the correct parameters to obtain a comprehensive and secure backup for new installations. Experience in this context is required.

Vorteile

MariaDB is something new in the market and at the beginning I was not sure about making the migration, but it has been very easy to use and has shown a lot of stability and speed, I really like it to be OpenSource with the software under the GPL license. This reduces many costs which gives a point in favor when choosing it, I like that it has a large community where there are always people willing to help in any problem, its configuration in the servers is quite simple and with very few resources can have the service operational, I like that the hosting providers have added it at no additional cost, which makes me consider it a lot when I'm going to implement a content manager or an electronic commerce system. New tables are an advantage in INFORMATION_SCHEMA

Nachteile

Although the community has tried to guarantee 100% compatibility with MySQL the reality is that it is not quite true when migrating to MariaDB it is necessary to change some data types that are not available. I did not like that it is necessary to uninstall MySQL on my development servers in order to install MariaDB. This software is fine for small and medium projects but it is limited when you need a robust database and with many long and frequent queries so for large projects it is not a good option.

Vorteile

Easy, Fast, Secured, and stable.Can hold huge data also.

Nachteile

Perfomance tunning needs more tools to get best performance.

Vorteile

It truly is a drop-in replacement for MySQL. Especially when you alter the table structure of an existing table with millions of rows the lock time goes down from 10s of minutes to 10s of seconds. Setting up a Galera cluster is not trivial, especially starting it the first time, but when it's up and running, it works really well.

Nachteile

Starting up a Galera cluster is annoying. The first node needs a manual start. They need to come up with a better way for non-database-people to easily start it up. Also we get many small Galera log files that sometimes just fill up the inodes on the server; why they don't just keep adding to the same log file is a mystery to us.

Vorteile

MariaDB is 100% compatible with MySQL queries and everything else. A 100% drop in replacement that is guaranteed to stay open source forever. You have a vast ecosystem of support and updates and tools. It just works, and I think that is the best thing you can really say about a piece of software. Install it, configure it, run the updates and it just keeps chugging along without an issue.

Nachteile

And now the 1 gripe. Price. The free edition is more then enough for 99.95% of our clients and what they do.
When we needed a little bit more, the price was out of control. What we needed could be duplicated in other ways, but to get it "built in" was not worth it.

Vorteile

It is based on MySQL, and has great compatibility with tools based on it, it is OpenSource like MySQL, but the difference is that MariaDB is governed by the [SENSITIVE CONTENT HIDDEN] of MySQL and not Oracle, Oracle is a Closed Source Database company, If someday they decide to remove the plug on MySQL or making it weaker to sell their products there would be no option to MySQL users, but MariaDB exists now.

Nachteile

It's missing some statistic tools that PostGreSQL already comes with, they can be added but it might be kind of cumbersome, Tools are not as polished as MySQL Workbench, DBeaver is the best one that I tried but have some issues from time to time.

Vorteile

Stable and quick. I have multiple dev environments that I run for testing and general project development. MariaDB has more up to date releases on arm-type devices and has a much more supported docker container than other databases.

Nachteile

The only improvement really needs to be general support. SQL syntax is pretty universal but there are some minor quirks that I had to end up fixing with StackOverflow answers after having no luck with the forum.

Vorteile

For years now, many hosts have offered MariaDB as RDBMS. DB management and performance are excellent, 90% of the work is done by the correct design of the data structure.

Nachteile

No problem or defect regarding the use I make of it.

Vorteile

It integrates perfectly with applications in various programming languages. It is compatible with MySQL. It is very popular and well-known. Better performance than MySQL.

Nachteile

It does not support data masking. Less popular than PostgreSQL or MySQL.

Vorteile

This is an opensource solutions which is a fork of MySql. I love how light it is compared to other softwares. It is reliable, light, much faster alternative. If you know mySQL then it is just the free version of it.

Nachteile

I ran into some configuration problem when trying to configure it on my VPS server. It doesn't have lots of tutorials like other, but you can always find a way around of it. You cannot get personalize support for this software like others, because it is a comunity based DB software. Less update and bug fixing sometime make word really hard.

Vorteile

It's a great drop-in replacement for MySQL. I have been using in my dev, test and prod sites and never really had any issues other than obvious identified bugs.

Nachteile

Sometimes it's slow on merging upstream from MySQL which becomes pain because you can't use the same feature which already exists in MySQL.

Vorteile

This is the relational database systems of choice if you need or want to switch MySQL. There is no client reconfigurationnecessary. It is developed by the open source community and it is broadly supported in all environments.

Nachteile

The shrinking of the idx log files is a bit tedious and needs downtime.

Vorteile

MariaDB is an excellent, free and open source solution for data storage, with a strong tradition of quality and a high level of support.

Nachteile

The renumbering of versions (skipping from 5.5 to 10.0) has left some confusing documentation and version tracking problems.

Vorteile

I like how it's compatible with MySQL. It makes it easy to use for our team which is experienced already with MySQL.

Nachteile

I don't have anything I don't like about MariaDB.

Vorteile

MariaDB is an alternative to MySql totally free and open source
Maintains full compatibility with MySQL, allowing migrations from MySql to MariaDB in a clean and smooth manner
When complex queries are received and you have to perform temporary tables, they are cached instead of being written to the disk
Being a very dynamic community and open to developers, MariaDB guarantees the fastest appearance of patches, which can solve any security problems
MariaDB can be used from most existing management systems for MySQL, such as PhpMyAdmin or HeidiSQL, and is compatible with popular applications such as WordPress, Drupal, and others

Nachteile

The migration of a very tested and reliable system such as MySQL. Although absolute compatibility is guaranteed, and a large stable and powerful system, we must assess whether today a complex system is worth passing to MariaDB

Vorteile

As a fork of another solution you have all the advantages of the old solution but with more actualizations and an improved experience.
Easy to connect with a wide variety of DB clients and integrates with a large amount of software-
Widely recommended as there are a lot of documentation on the web.

Vorteile

The new system tables, which keep statistics that are of great help for the optimization of the Database. Its new ARIA storage engines that replace MyISAM and XtraDB that replaces InnoDB and are fault-proof, and the PBXT engine: which is a transactional storage engine with a lot of new and beautiful features. On the other hand its speed improvement especially in complex queries when using the Aria storage engine, since Aria caches data from temporary tables in memory, which is a performance against the use of the hard drive. In the replication substantial improvements have been introduced, for example the "group commit for the binary log" that accelerates replication up to twice as much. Its ability to handle more than 200.00 connections.

Nachteile

I really have not got something so far that I do not like the driver. For which I recommend its use

Vorteile

We can easily switch to this database with simple steps. It provide better sequrity on data. Retrieve data from table is easy and fast. Easy to handle complex queries.

Nachteile

It should add more simplicity while implementing culstering on tables. Debugging tool it not good it does not tract all the missing indexes.

Vorteile

MariaDB has picked up the community-oriented development mindset where MySQL left off since being acquired by Oracle. I've had virtually no problems with stability, and MariaDB seems to be actively developed.

Nachteile

Unfortunately, the majority of the community still seems to use MySQL, and that will become a problem as MySQL and MariaDB continue to diverge. How many developers will want to support both platforms? It's difficult to say.

Vorteile

Is a medium to lightweight database engine, in resource consumption, fast as long as you set it up correctly.
Database backups are simple, but no easy to automate.
Uses a very standard SQL language.
It's very easy to find libraries for this database in any operative system.

Nachteile

It does not include a default manager
It's all console by default

Vorteile

I have used MariaDB in small environments, and production environments handling millions of transactions. It has proven very reliable, robust, and I have come to rely on it.

Nachteile

Sometimes the configuration can be quite terse, but it is very well documented, and there is always somebody out there who can help!

Vorteile

1. High Performance and availability
2. Has an active open-source developer community.
3. Robust Transactional Support.
4. Availability of many Storage Engines.

Nachteile

1. MariaDB is no longer completely compatible with MySQL. Which makes migration a tedious process.
2. Needs improvement in caching.
3. It doesn’t support full outer joins.

Vorteile

Ideal for companies that want to take SQL to the next level. Efficient, secure, ideal for the user's wanting to integrate various application together.

Nachteile

Open source and hopefully the developers will keep on top of the software for years to come. Integration software works as long as other vendors stay together and keep on collaborating.

Vorteile

A fork from mysql, much more updated and well maintained, doesn't require a lot of learning very simple and reliable!

Nachteile

I hate the option to log in without password after installing new mariadb server, I wish I could set a password before installing, but it doesn't prevent from doing it after the installation it's just extra steps...

Vorteile

Security features is very good as we get security patches more frequently. Easy to move from other database. It provider better speed performance that MYSQL.

Nachteile

Maintain the indexing on table is very complex. It provide many features but query performance feature is still missing.

Vorteile

Fast and stable.
Compatible with other database systems. You can import and export database backups from most SQL backups.
Compatible with different kinds of servers. You can install it on most operating systems.

Nachteile

I was unable to set it up on my localhost to run alongside another database system without conflicts.

Vorteile

MariaDB it's a great database that provides a very good way to storage data and it's compatible with multiple operating systems.

Nachteile

Some useful SQL functions it's not available in this database, but it's still a very good way to storage data.

Vorteile

I've been using MariaDB on CentOS 7 with PHP 7.1, and I have to say that this is running smooth. I have a hard time consuming any resources, or using much processor with this setup.

Nachteile

The only con I see is the settings. Just like MySQL, you need to understand how to use the settings to optimize MariaDB, but there is community support. So be ready to study a little.

Vorteile

MariaDB is a free MySQL clone with improvements such as faster speed and better replication. It requires minimum resources.

Nachteile

It doesn't have all the MySQL features and it has delayed compatibility with MySQL versions starting from 5.5.

Vorteile

An option to the MySQL database, as it is more updated than the free version of MySQL, and its license and its compatibility with Linux allows a low cost in production environment.

Nachteile

Because it is a good open source option, this means support is through the community, and the vendor is not responsible for data loss.