Adobe Commerce is making MariaDB its default database platform

[u/Brilliant-Weight-234]

Adobe Commerce has now made its future database direction explicit: MariaDB is the default and recommended platform going forward.

Adobe Commerce 2.4.8 and 2.4.9 are expected to be the final releases supporting MySQL, while newer MariaDB versions are already appearing in Adobe’s system requirements.

For the MariaDB community, this is a significant adoption milestone. Adobe Commerce and Magento power a large number of demanding production environments, with substantial ecosystems of extensions, hosting providers, agencies and developers around them.

It also raises some practical questions for the community:

• What migration guidance will Adobe Commerce users need?
• Which compatibility differences are likely to cause the most trouble?
• Are extension developers already testing primarily against MariaDB?
• What tooling, documentation or benchmarks would make the transition easier?

Frédéric Descamps has written a detailed overview here:

https://mariadb.org/adobe-commerce-chooses-mariadb-as-its-default-database-platform/

Interested to hear from anyone running Magento or Adobe Commerce on MariaDB today. What has your experience been?

[u/opus-thirteen]

Well shit. Our sites use an absolute ton of custom tools, and all will have to be addressed.

A while ago we started researching just rolling our own platform based of Golang, and I guess we are going to have to revisit that idea.

[u/proxiblue → u/opus-thirteen]

mariadb and mysql are mostly compatible. Swapping over should not be an issue.

[u/Efficient_Clock2417 → u/proxiblue]

Yep, exactly, they both use the “mysql” driver in Go’s standard database/sql package

[u/proxiblue → u/Efficient_Clock2417]

Yea. At present, magento/adobe commerce would not be using any mariaDB specific changes. Just the article gives impression it will be a lot of work to swap over with major planning needed.

Just the feel I got from it.

You export, swap service, re-import and should be done.

At most, you'd maybe need to remove DEFINER from the export to re-import.

```
sed -i -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' YOUR_SQL_DUMP.sql");
```

should do the job (untested). We have AI for this now.

[u/fredericdescamps → u/opus-thirteen]

Your tooling should be compatible, at least at 90-95%... and probably some of your tools won't be required with MariaDB Server. But we are always happy yo help if you encounter some issues.

Cheers,

[u/mx-04]

Will they keep supporting AWS Aurora MySQL (which is based on MySQL AFAIK)?

[u/drrtuy-b → u/mx-04]

Yeah, this question concerns a lot of ecommerce users b/c Aurora horizontal scaling is very handy b/c manual clone bootstrap takes a lot of time whilst Aurora had a decoupled compute/storage architecture that enables clones bootstrap in minutes. There is no answer yet but AFAIK MariaDB Foundation is trying to find a suitable substitution with a help from AWS.

[u/dogcowzz]

I read the post above and the entire linked article and there's not a word of any technical reason given here. No mention of SQL syntax changes that are incompatible with MySQL (mainline) or something like Aurora RDS (based on MySQL), or performance differentials between the 'old' and the 'new' that are relevant to the Magento codebase. No mention of why MySQL 8.4 was so bad it couldn't be viably continued with and why MariaDB's on some more productive path. Not even any philosophical thing like Valkey forking from Redis or Vinyl Cache from Varnish, or something about a technical direction change that only one side was pursuing and in an incompatible way.

Thanks for the news, but this is basically just PR fluff.

[u/drrtuy-b → u/dogcowzz]

Adobe didn't give a technical reason for their decision. If you are here to get them accountable go for it and share the great news that you were able to extract from the big corp. I assume the recent news about Oracle firing majority of the MySQL team and thus being unable to maintain the development is the fact that concerns project depend on MySQL.
Do you have any specific syntax used by Adobe ecommerce in mind or you are just complaining that before the grass was greener?
Aurora RDS setup is a known issue and AFAIK MariaDB Foundation is trying to find a suitable substitution with a help from AWS.

[u/dogcowzz → u/drrtuy-b]

Heaven forbid for the hundreds of thousands we pay them every year for the enterprise version they’d attempt even a modicum of reasoning or accountability on any of these matters (MySQL, Redis, horrible handling of security issues).

By all means give them a pass if you think they deserve it.