How to use AWS RDS for ERPNext

Hi,

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

Many thanks

1 Like

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

3 Likes

Awesome!

I agree

Many thanks for this

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


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 https://github.com/frappe/frappe/wiki/Using-Frappe-with-Amazon-RDS-(or-any-other-DBaaS)

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

did you get a noticeable performance increase by using RDS?

or what are your motivations to use RDS?

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.