I am trying to set up a database environment with Ubuntu and PostgreSQL (I didn't want to use RDS because I'm a Ubuntu person).
I looked at description for the
R3 instance type:
High performance databases, data mining & analysis, in-memory databases, distributed web scale in-memory caches, applications performing real-time processing of unstructured big data, Hadoop/Spark clusters, and other enterprise applications. R3
R3 instances are optimized for memory-intensive applications and offer lower price per GiB of RAM.
High Frequency Intel Xeon E5-2670 v2 (Ivy Bridge) Processors SSD Storage Support for Enhanced Networking
So, I went for the SSD Storage, and thought I can somehow utilize it for fast database operations.
Now when I begin to launch a Ubuntu instance, e.g. :
Ubuntu Server 16.04 LTS (HVM), SSD Volume Type - ami-da05a4a0
I realize that I cannot use the SSD storage for the root device hosting PostgreSQL and all the system software. Moreover, the instance store is said to be ephemeral and data are lost if the AWS EC2 instance is stopped. The only use case I was able to find to use the instance store as Linux swap space.
I'm very new to AWS EC2. I'd just like to ask how should the SSD instance store be utilized in a database server (other than as swap)?
So far, the use case I can think of (swap, mount as
/tmp) seems to be a waste of the money spent on reserving the SSD storage.