Taming 100+ PostgreSQL instances on the Cloud
Schedule

Presented by:

149c8dcf58a2622008b0d52619a22d6c

Krishnaswamy Subramanian

from ThoughtWorks

Krishnaswamy Subramanian

Lead Consultant, ThoughtWorks.

I am passionate about solving / crafting technical problems through code.

With 13+ years in custom software development, I have worked across technologies which includes full-stack, mobile and DevOps.

4ee8317d5a274a3e7a6be5267e74a85c

Nithya Natarajan

from ThoughtWorks

Nithya Natarajan

Senior Consultant, ThoughtWorks.

I'm a passionate developer who likes challenges, especially the ones difficult to solve or not solved by many.

In my 7+ years with ThoughtWorks, I have got opportunities to work on various things like developing micro-services, re-architecture and re-designing systems, building infrastructure platform, data analysis and what not.

I find it exciting to learn and solve something new everyday at work.

Checkout the slides

Kubernetes lets you deploy applications in ways that are highly available and resilient, and can utilize the underlying resources more efficiently. This can bring huge cost savings to the business, especially when you’re entrusted with running PostgreSQL clusters on Kubernetes, rather than over traditional VMs.

In this talk, we share our experiences of running and managing 100+ PostgreSQL instances across multiple use cases and environments, for a leading technology start-up business. We take you through some of the challenges we faced, and the various tools techniques we adopted to work around them. Join us if you’d like to understand how we addressed the following issues:

  1. How to handle the ephemeral nature of Kubernetes?
  2. How to resize disks with zero downtime?
  3. How to change disk type from standard to SSD with minimal downtime?
  4. How to upgrade PostgreSQL servers with minimal downtime?
  5. How to redirect the read-only queries to slaves?

and more...

Date:
2020 February 27 - 11:00
Duration:
40 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2020
Language:
Track:
Case Study
Difficulty:
Medium

Happening at the same time:

  1. Avoiding, Detecting, and Recovering From Data Corruption
    2. Start Time:
    2020 February 27 11:00

    Room:
    Grand Victoria 1

  2. Full Text Search in PG12
    3. Start Time:
    2020 February 27 11:00

    Room:
    Grand Victoria 2