Question

A company needs a massive postgresql database and the engineering team would like to retain control over managing the patches, version upgrades for the database, and consistent performance with high iops. the team wants to install the database on an amazon ec2 instance with the optimal storage type on the attached amazon ebs volume. as a solutions architect, which of the following configurations would you suggest to the engineering team?

a. Amazon EC2 with EBS volume of Provisioned IOPS SSD (io1) type (Correct)
b. Amazon EC2 with EBS volume of General Purpose SSD (gp2) type
c. Amazon EC2 with EBS volume of Throughput Optimized HDD (st1) type
d. Amazon EC2 with EBS volume of cold HDD (sc1) type

Answer 1

• Final answer:
• I would suggest the configuration of Amazon EC2 with an EBS volume of Provisioned IOPS SSD (io1) type to the engineering team.
• Step-by-step explanation:
• I would suggest the configuration of Amazon EC2 with an EBS volume of Provisioned IOPS SSD (io1) type to the engineering team.
• The Provisioned IOPS SSD (io1) type is designed for applications that require consistently high performance with low latency. It provides predictable performance, making it ideal for a massive PostgreSQL database.
• This configuration allows the engineering team to retain control over managing the patches, version upgrades, and ensure consistent performance with high IOPS (Input/Output Operations Per Second).
• By using the optimal storage type, the team can achieve optimized throughput and low latency, resulting in improved database performance.