2

Is AWS RDS billing purely based on RAM/IO and storage? or is there any additional per database charges?

For my RDS deploy, If I have 1 PostgreSQL DB that has all my data but only receives 2000 queries per day vs if I have 4 PostgreSQL DBs that have the same relations as the 1 DB but those relations are split up on the 4 DBs and the 4 DBs will collectively receive the same 2000 queries per day... will the bill between the two different setups be essentially the same amount? The assumption being that the "size" of the data in 1DB vs 4DBs is exactly the same.

I want to split the data across multiple databases to make reporting for different modules in my system easier.

enansi
  • 23
  • 2
  • To be clear, my question is about having multiple databases in the same instance and NOT on spinning up 4 instances vs 1 instance for the DB/DBs/ – enansi Jun 11 '21 at 15:28

2 Answers2

3

You are billed based on instance size and some additional criteria (disk size, outbound traffic, etc.) If these are the same, the number of databases doesn't matter. So you can split your application across multiple databases within an instance without impact to the billing.

In the future - this is a question better suited to Server Exchange than to Stack Overflow.

Felix
  • 9,248
  • 10
  • 57
  • 89
  • 1
    Thanks, I'll use ServerExchange for those types of questions, i.e. those that are more admin/server related rather than a programming question. – enansi Jun 11 '21 at 15:29
0

AWS RDS charges based on size, Data Transfer, backup, Storage etc. In your case if you are going to keep the size of the instance same then it is better to have only one instance as the costing for instance is more than the Data Transfer and storage. It makes no sense to have 4 same size of instances as the base billing will be 4 times. If you use small instance size then it may make some difference.

I would request you to refer to the below links: https://aws.amazon.com/rds/postgresql/pricing/ https://calculator.aws/#/

With this you can understand how much you are billed for instances based on your usage also instance size. Also you can choose different options to reduce the billing like Reserved instance.

Since there will be only one instance I think the charges will be the same, as long as the parameters on which it charges is the same.

Muzaffar Shaikh
  • 630
  • 4
  • 14
  • OP's question is not about multiple instances, but about multiple databases within instance – Felix Jun 11 '21 at 14:29
  • You can create multiple databases in the same instance. AWS will charge based on the above categories and those categories are for an instance and not for a database. So you can have many databases in the same instance but AWS will charge based on the usage of the instance. – Muzaffar Shaikh Jun 11 '21 at 14:45