Is MariaDB easier and better suited for a WordPress website? I've been having problems with MySQL 8.0.20 on Ubuntu 18.04, and because I don't have a lot of knowledge on databases, I was thinking on switching to MariaDB as I heard it has better settings and performance out of the box.

So:


Is MariaDB a better solution for someone who is still learning database?
Can I just bring the MySQL database to MariaDB without any conversion or anything else (just drag and drop)?
Can I run mariadb with apache 2.4 and php 7.4?
1) There is very little difference between MySQL and MariaDB, especially for a beginner. Stick with whatever ships with your preferred Linux distribution.

2) You cannot do this even between different versions of MySQL and MariaDB.

2.1) You can only upgrade in-place, and not downgrade. If you need to downgrade, you will have to mysqldump and import on the new version.

2.2) If you are upgrading, MySQL and MariaDB versioning differs, so choose carefully if you intend to switch in-place. In some cases, upgrading requires special preparation, e.g. between MariaDB 10.1 and earlier / MySQL 5.7 and earlier to MariaDB 10.2 and later or very recent MySQL 8.0.x.

Bottom line - don't version hop. Pick one and stick with it until you know exactly what you are doing.

3) Yes, MariaDB speaks the same wire protocol as MySQL so anything that will run against one at a low level will run against the other.