Which is better to choose MySQL or MariaDB?

Question

MySQL

I am new to programming. There was a question of a choice of a database.

Answer 1

First, Mari n aDB doesn't exist, but MariaDB does .
Secondly, I myself use MariaDB, switched from MySQL. In fact, there is no difference, but at some points MariaDB executes queries corny faster, and XtraDB is more interesting than InnoDB.
Read all about it here .

Answer 2

In the beginning you won't notice any difference, flip a coin.

Answer 3

MariaDB adds optimizations that improve the performance of the DBMS compared to the original MySQL.
Unlike MySQL, in MariaDB, only those tables that are needed for the query are requested.
MariaDB provides another powerful performance improvement with a new type of table that is not in the form of row storage but in the form of column storage.
MariaDB provides the MyRocks storage engine, which allows you to store data in RocksDB (an embedded database that was designed to improve the processing performance of data stored on SSD drives).
MariaDB introduces another performance improvement, the sharded key cache. This helps multiple threads to run in parallel, increasing concurrency in the application, resulting in improved database performance.
One of the latest versions of MariaDB - 10.0 allows parallel execution of multiple queries. The idea is that some requests from the Master can be passed to slave servers for execution. This parallelism in query execution certainly gives MariaDB an edge over MySQL.
The MariaDB team ensures that MariaDB can replace MySQL in existing applications. In fact, for every MySQL version, they release the same MariaDB version number to indicate that MariaDB is generally compatible with the corresponding MySQL version. This opens up the possibility of a seamless transition to MariaDB without any changes to the application's codebase.