Is MariaDB better than MySQL in every way? Or does MySQL have some advantages?

Question

MySQL

Does it make sense to use MySQL 8.0 today? Is there something unique to MySQL that makes it better to use MySQL over MariaDB, MongoDB or Percona in some cases?
PS. MongoDB was accidentally included in this list.

Answer 1

Is MariaDB better than MySQL in every way?

And nothing, what is it one and the same?
But out of the two, I would choose MySQL because it's made by a corporation, not a free community (which is where the difference lies).

Answer 2

MariaDB has many features that are missing in MySQL: time versioning, support for engines for OLAP and KVS, new methods for accessing data and processing them in the execution plan, support for Oracle's pl/sql syntax compatibility mode, support for plugable custom data types. But there are differences in MYSQL too: data dictionary instead of .frm files and metadata in myisam tables. Operator syntax support for JSON from the standard. The advertised atomic DDL is not a fig not atomic true: the base will not ROLLBACK a column shabby with ALTER TABLE DROP COLUMN.
Therefore, if added features are important to you, then use MySQL. If performance is important, then MDB.
Oh, by the way, Oracle decided to break the feature freeze system after the major release became GA and added a behavior-changing feature in 8.0.
Percona is now something that "borrows" commits from both projects. Once they had a cool tooling and a team of hackers who understood the DBMS kernel code, but the times have passed and, by and large, Percona is now a support business - I would not bet on them.

Answer 3

I would exclude MongoDB, this is from another opera.
About MySQL\MariaDB\ Percona\AWS Aurora etc. - an interesting question. Firstly, are we interested in something other than the core product - things like a cluster, commercial plugins, etc.
Are we interested in non-standard storage engines?
Do we need business support?
Based on this, you can analyze and choose.
Another option is to just use what you got with the distribution.

Answer 4

in the fork furnace. sooner or later, this thread will lag behind the original so much that everyone will forget about it.
and it’s not a fact that the muscle itself will survive the competition with postgres in its segment.

Answer 5

In MariaDB 10, I found a problem with query caching, even with SQL_NO_CACHE, and cutting off the cache is completely blasphemy. Therefore, I returned to MySQL.