Some apps like ERPNext are only optimized for MariaDB and use MariaDB specific features. Slowly MariaDB is getting incompatible with MySQL by adding features like custom sequences not available in MySQL.
From a Cloudron dev’s POV, adding MariaDB as an addon is a trivial task because MySQL is already there. Please add MariaDB as an addon. Thank you!
@nj Thanks for all the hard work on ERPNext - https://forum.cloudron.io/topic/1228/erpnext-cost-effective-erp-solution/ (for others to follow). My understanding is that the app will still need to be an "admin" is it? With the flexibility to create multiple databases.
We had phabricator which wanted similar support. MySQL addon supports this via
multipleDatabasesflag . Is this enough ?
@girish I have figured out a solution that doesn’t require admin permissions to ERPNext. It’s just that they use MariaDB specific commands here and there. That’s why MySQL addon is not useful at all.
Multiple databases works kinda fine but needs patching the source because ERPNext likes to use the same value for db-user and db-name; in fact there’s no way to give it the db-user. The name of the database is itself is considered username.
While building this addon, I would recommend setting the user’s name and database the same - ie. without prepending the same string with ‘db’ or ‘user’
Multiple databases isn’t required as ERPNext doesn’t work really well as a multi-site ERP anyway.