ERPNext Installation in RDS AURORA MySQL

Frappe Framework Customization
1

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.

2 Likes
2

Can you share your script. Thanks

3

Please do make a pull request. It has to go on develop if it’s not a bugfix.

4

Hello @seethersan were you able to create a pull request?, I am a similar issue Installing ERPNext on a mariaDB server on Azure.

5

Hi! did you end up upstreaming these changes?
it’s great if we can run Aurora out-of-the-box without manual patches

6

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