MariaDB

Avantages

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

Inconvénients

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

Avantages

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

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

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.

Inconvénients

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.

Alternatives envisagées 

Pourquoi choisir MariaDB 

Pourquoi passer à MariaDB

Avantages

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

Inconvénients

There are many database that will be good alternative to MariaDB

Alternatives envisagées 

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Alternatives envisagées 

Pourquoi choisir MariaDB 

Pourquoi passer à MariaDB

Avantages

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.

Inconvénients

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!

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

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.

Inconvénients

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.

Avantages

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.

Inconvénients

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

Avantages

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

Inconvénients

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

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Alternatives envisagées 

Logiciel antérieur 

Avantages

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.

Inconvénients

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

Avantages

Database optimization, data replication, data management

Inconvénients

Instalation is very hard, especially for beginner

Avantages

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

Inconvénients

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.

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

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

Inconvénients

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.

Avantages

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

Inconvénients

Perfomance tunning needs more tools to get best performance.

Avantages

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.

Inconvénients

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.

Avantages

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.

Inconvénients

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.