When it All Goes Wrong - Incident Response in Large Postgres Databases
Presented by:
Christopher Travers
Chris Travers works in Berlin as a database administrator, in a distributed PostgreSQL environment involving hundreds of TB of data in PostgreSQL. He has experience working with PostgreSQL in many areas from scientific computing in the life sciences, to ERP, from high-velocity ad-tech analytics to geo-spacial databases. He is the author of a number of extensions on pgxn.
His current experience involves mobile advertisement analytics over 400TB data sets and more short-terms log management environments handling PBs of data in PostgreSQL.
When things go wrong with large, heavily loaded systems, it can take a significant amount of time to recover. For this reason, the same response patterns with other critical systems (nuclear power plants, jumbo jets) apply to disaster management here as well.
This talk is a story of how we at Adjust managed one such disaster and what you can learn from it. The talk will also include what we learned from it as well.
In this presentation, you will learn:
- Techniques and factors for disaster preparedness
- Communication strategies between responders for improving outcomes in emergency situations
- Communication strategies to other stakeholders during emergency situations
Please note, this will draw parallels to airplane and other disasters. The focus is on the human factors in the response, but technical details will be discussed also.
- Date:
- 2021 June 15 13:00 EDT
- Duration:
- 1 h
- Room:
- Online
- Conference:
- 2021 Postgres Conference Webinars
- Language:
- Track:
- Ops
- Difficulty:
- Easy
- Requires Registration:
- Yes (Registered: 65)