ERPNext Installation in RDS AURORA MySQL

Briefly,

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

These patches are only required during site creation,

Aurora I think is old MySQL. https://mariadb.com/resources/blog/four-things-you-didnt-know-about-amazon-aurora/

Mariadb RDS works already without any patching, refer this Using Frappe with Amazon RDS (or any other DBaaS) · frappe/frappe Wiki · GitHub

Do we need to support MySQL 5.7? I can send PR for this

2 Likes