MariaDB

MariaDB Review

Kommentare: My overall experience with MariaDB has been very favorable. I like the clustering features a lot, and it's built in already, which is awesome since it saves me time. I like that I can export my entire database in to MariaDB, be it a little hard to figure out at first but once you get the hang of it you will do better with it the next time round.

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.

MariaDB a good RDBMS

Kommentare: We want to be able to migrate data in our training from a H2 (flat file) database to an RDBMS enviroment that can be shared among multiple servers. Furthermore we want a simple command line where we can use easy commands to create and manipulate data. MariaDB offers all that.

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.

MariaDB_01

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

MariaDB as a drop in replacement for MySQL just works

Kommentare: We use it to store all of our data.

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.

Best Database server ever

Kommentare: I am using it in ERP systems and applications, all my cloud applications uses MariaDB as backend.

Vorteile:

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

Nachteile:

Perfomance tunning needs more tools to get best performance.