How to use AWS RDS for ERPNext

wale · December 3, 2018, 5:23pm

Hi,

Is anyone using AWS RDS for ERPNext? I would really appreciate some insight into how to set this up

Many thanks

tmatteson · December 3, 2018, 6:22pm

To be fair, I think most of the pages on the wiki are “buried” without a maintained table of contents.

wale · December 3, 2018, 7:39pm

Awesome!

I agree

Many thanks for this

Ajay_Patil · October 10, 2019, 6:12pm

How did you create parameter group with settings for Mariadb 10.3?

ngoploti · September 23, 2021, 5:26am

Click on create parameter group as you see on the image. And you set the value for the different available parameters according to your Mariadb version as show on this link Using Frappe with Amazon RDS (or any other DBaaS) · frappe/frappe Wiki · GitHub

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-character-set = utf8mb4

As I am using Mariadb 10.4 on AWS RDS I was just able to set only 2 parameters:
character-set-server
collation-server

moe01325 · September 23, 2021, 8:56am

did you get a noticeable performance increase by using RDS?

or what are your motivations to use RDS?

ngoploti · October 6, 2021, 11:25am

with RDS you have a database as a service. Installing Mariadb on EC2 will cost you more. And you won’t have the flexibility in ressource management.

mohammad-ihraiz · June 25, 2024, 5:10am

Sorry for opening a dead thread but I need to ask you if the ignored 2 parameters:

character-set-client-handshake = FALSE
default-character-set = utf8mb4

have affected your ERPNext instance in any negative way?