I would just like to ask if MySQL 8.0 or MySQL EE are supported by Frappe, and if the are any long term plans to make Frappe compatible with MySQL 8/EE? Our team is considering purchasing an enterprise license however, based on conversations with oracle, there is a possibility that some things may not work as intended as Frappe was designed with MariaDB which has diverged from Oracle MySQL.
Our company is looking into purchasing a license for MySQL as we are dealing with a rapidly growing database. Currently backups & restores take hours. And we are expecting the load + data in our sever to increase in the future.
Would you know if MariaDB enterprise supported? We can also consider MariaDB Enterprise if its features/capabilities are similar to that of Mysql EE.
few years ago I was able to install ERPNext on AWS Aurora. For local development developers had access to Aurora for everyone to face same issues and resolve them. The team specifically required Aurora and were okay with delayed upgrades and restricted usage.
following patching was done at framework level in v13 (haven’t checked with latest version)
sed -i -e "s/\`name\` varchar(100) DEFAULT NULL,/\`name\` varchar(100),/g" /home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/framework_mariadb.sql;
sed -i -e "s/ROW_FORMAT=COMPRESSED/ROW_FORMAT=DYNAMIC/g" /home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/framework_mariadb.sql;
sed -i -e "s/ROW_FORMAT=COMPRESSED/ROW_FORMAT=DYNAMIC/g" /home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py;
sed -i -e "s/ROW_FORMAT=COMPRESSED/ROW_FORMAT=DYNAMIC/g" /home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/schema.py;
If you are okay with manual or auto test of your workflows with custom database then you can use it.
drawback is, you have to run your tests and patch the code as required on every upstream upgrade. It will not make sense if you need to be up to date with latest upstream code.
It may make sense if your other apps are already using custom db or you can only use product that was approved by some long bidding process which limit your choices.