Choosing the right RDS instance type


I am currently planning to switch my MySQL Databases from a shared hosting provider, to RDS, so i can have more control over my account and benefit from provided performance advantages. However, I am very lost which instance type to choose, specially when choosing the amount of memory, so i need help with this subject.

I currently have 7 databases, respectively having the following sizes and number of users: 1- Database 1: Around 200 users per month / 250 kb database size, around 50 records overall. 2- Database 2: Around 200 users per month / 250 kb database size, around 50 records overall. 3- Database 3: Around 500 users per month / 250 kb database size, around 30 records overall. 4- Database 4 (e-comm): Around 500 users per month / 1mb database size, around 1000 records overall. 5- Database 5 (e-comm): Around 200 users per day / 100mb database size, around 300000 records overall. 6- Database 6: around 50 users per month / 10mb database size, around 5000 records overall. 7- Database 7: around 5 users per month / 5mb database size, around 5000 records overall.

I would like to know what memory size is the recommended to include all these databases in. Also I would like to ask if it is a best practice to include database 5 in a separate database instance, or I should simply increase the memory of the database instance?

1 Answer
Accepted Answer

To determine the appropriate memory size for your RDS instance, you will need to consider the size and usage patterns of your databases. From the information you provided, it seems that the majority of your databases are relatively small and have low usage, with the exception of Database 5, which is larger and has a higher usage rate.

Based on the information you provided, I would recommend starting with an RDS instance with at least 4GB of memory. This should provide enough memory to comfortably handle your smaller databases, while also providing some headroom for growth. However, to handle the load of Database 5, you may want to consider upgrading to a larger instance type or using a separate RDS instance solely for that database.

When deciding whether to use a separate RDS instance for Database 5, you will need to consider factors such as the amount of traffic it receives, the complexity of its queries, and the impact it could have on the performance of your other databases. If it is critical to your business and receives a lot of traffic, it may be best to isolate it in a separate instance to ensure optimal performance. However, if it is not heavily used or is not likely to impact the performance of your other databases, it may be fine to keep it in the same instance and simply increase the memory allocation.

Always try to have the Database of latest generation. For you, If the load is normal, then t4g.medium or db.m6g.large should work well. (As I am considering a normal load pattern). You might want to do the performance testing and then take a final call on the DB Instance size.

profile picture
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions