The Datalogz application uses OLTP and OLAP databases to optimize performance and scalability between the two workloads.
Minimum
Memory Optimized
Compute: 2 vCores, 16 GiB Memory, 3200 IOPS
Storage: 512 GB
Estimated Cost as of 2/1/2023: $500 / mo.
Recommended
Memory Optimized
Compute: 4 vCores, 32 GiB Memory, 6400 IOPS
Storage: 512 GB
Estimated Cost as of 2/1/2023: $850 / mo.
Total Estimated Cost: $500 - $850 / mo.
Minimum/Recommended
Memory Optimized
Compute: 2 vCores, 8 GiB Memory, 3200 IOPS
Storage: 512 GB
Estimated Cost as of 2/1/2023: $200 / mo.
Go to RDS and click Create Database
Choose Standard Create
, Postgres
and choose your desired size
Settings:
Name your database instance
Provide the credentials to your database. Store these credentials somewhere secure. We will come to these credentials later in the Secrets Manager section
Instance configuration:
Leave all the settings as default
Storage:
Set Allocated Storage to 50 GiB
Connectivity:
Select the VPC and the subnets that we created in the VPC deployment section
Select the security group that we created in the Security Group section
Leave the rest as default
Leave all the other sections as default
Click Create database
App DB
Name: datalogz_bi
Warehouse DB
Name: datalogz_wh
App DB
Name: datalogz_bi
BI Warehouse DB (See Snowflake Option Section)
Name: datalogz_wh