Running Highly Available Postgres in AWS RDS - Sushant Mahesh Pawar - FOSSASIA Summit 2017
Channel: FOSSASIA
Date: 18/03/2017

Speaker(s): Sushant Mahesh Pawar (Mumbai)

Abstract:
If we look back and see the changes that have happened in last few years, we will realize that how things have changed very rapidly. A decade back, most of the organizations either would have their in-house database servers running on certain hardware and storage configuration. Over the period, when the servers become obsolete, then server/storage migration would itself become separate project and the procurement process for new hardware in any organization is usually time consuming process. In last two years, there has been rise in adoption of Cloud that tries to address this and many other issues. Now you do not have to worry about the underlying hardware and storage, once you know CPU, RAM and storage requirement, you can customize the server and build your own server in cloud. Also, migrating Postgres cluster to cloud is a viable option for safety (no data loss, including if rollback), minimal downtime (switchover and rollback), minimal effort for the team.Considering one of the above reasons for moving to cloud, one of our client’s in FinTech space decided to move their PostgreSQL instance to AWS RDS since RDS offered some of the following benefits like:•        Automated failover of primary in case of failure •        Automated creation of replicas•        Automated updates•        A purely declarative setup, via Cloud formationHere I will talk about how technical aspects of moving PostgreSQL server to AWS RDS.•        How to configure, tune the parameters in config file while moving onto RDS. •        How you can select the storage depending upon growth estimate and IOPS requirement•        How you can configure HA setup in RDS.•        How you can distribute your reporting workload.•        How to monitor Postgres instance and alert configuration

(Type:  | Track: Database - PGDay | Room: Curie & Hershel (Floor 2))

Event Page: http://2017.fossasia.org

Produced by Engineers.SG