This repository was archived by the owner on Mar 20, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 312
Example
Bohan Zhang edited this page Jan 14, 2019
·
7 revisions
We use m5d.xlarge instance on AWS, which has 4 CPUs, 16GB RAM, and 150GB local storage SSD. We use local SSD to store the target database data since it does not have IOPS limits compared to EBS. However, you will lose your local data once stop/restart/terminate the instance (more info). We use Ubuntu Server 16.04 LTS (HVM) AMI.
We choose Postgres 9.6 as the target database, i.e. the database we will tune on the client side. On the server side, we use MySQL to store the website data. We set up both client side and server side on the same machine, since we find that it has little effect on the performance. Follow the instruction on the Linux Quick Start Wiki to install the packages on the bare-metal instance.