new | show | ask | jobs Github

christophilus 2 days ago

I’ve been tempted by MariaDB for this reason. I’d love to hear from anyone who has run both.

▲

paulryanrogers 2 days ago | parent [-]

IMO Maria has fallen behind MySQL. I wouldn't chose it for anything my income depends on.

(I do use Maria at home for legacy reasons, and have used MySQL and Pg professionally for years.)

▲

danaris a day ago | parent [-]

> IMO Maria has fallen behind MySQL. I wouldn't chose it for anything my income depends on.

Can you give any details on that?

I switched to MariaDB back in the day for my personal projects because (so far as I could tell) it was being updated more regularly, and it was more fully open source. (I don't recall offhand at this point whether MySQL switched to a fully paid model, or just less-open.)

	▲	Seattle3503 a day ago \| parent \| next [-]
		SKIP LOCKED was added in 10.6 (~2021), years after MySQL had it (~2017). My company was using MariaDB around the time and was trailing a version or two and it made implementing a queue very painful.
	▲	chuckadams a day ago \| parent \| prev \| next [-]
		One area where Maria lags significantly is JSON support. In MariaDB, JSON is just an alias for LONGTEXT plus validation: https://mariadb.com/docs/server/reference/data-types/string-...
	▲	paulryanrogers a day ago \| parent \| prev [-]
		IME MariaDB doesn't recover or run as reliably as modern versions of MySQL, at least with InnoDB.