What about Postgres? I'm not a database expert, just wondering. Is MariaDB more of a one-to-one replacement for MySQL?
MariaDB is a drop in replacement, as is Percona.
PostgreSQL is a completely different database system, and is definitely preferable if starting from scratch, but migrating from MySQL to it can be a pain.
Yes. Maria is a fork of MySQL, while PostgreSQL is an unrelated product aside from using a dialect of SQL.
Not something I'd like to risk my own company's database on.