I managed to install successfully ERPNext in RDS Aurora MySQL. I had to configure the Parameter Groups to fit the requirements of the ERPNext database. Also I had to modify some sql statements that Frappe use to create some tables because RDS Aurora doesn’t support large primary keys when COMPRESSED format is used in table creation. Also RDS doesn’t support GRANT ALL PERMISSION, so I had to change the statement that gives permission to the user. I made some modifications in frappe to allow the SSL connection whit RDS because Amazon only provides a bundle certificate, I changed the mysql connection string to only use this certificate and it works correctly. I was thinking in make a pull request to Frappe but I’m not sure if I can do it to master.
Can you share your script. Thanks
Please do make a pull request. It has to go on
develop if it’s not a bugfix.
Hello @seethersan were you able to create a pull request?, I am a similar issue Installing ERPNext on a mariaDB server on Azure.
Hi! did you end up upstreaming these changes?
it’s great if we can run Aurora out-of-the-box without manual patches
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. Four Things You Didn’t Know About Amazon Aurora | MariaDB
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