Building PostgreSQL as an Enterprise Grade Setup Using Open Source Tools

Wednesday 2:55 PM - 3:55 PM

@ Foothills 1

PostgreSQL

50 minutes conference

Beginner

Tracks:
PostgreSQL

"I migrated from a proprietary database software to PostgreSQL. I am curious to know whether I can get the same features I used to have in the proprietary database software."

The market coined the term "enterprise grade" or "enterprise ready" to differentiate products and service offerings for licensed database software. For example, there may be a standard database software or an entry-level package that delivers the core functionality and basic features. Likewise, there may be an enterprise version, a more advanced package which goes beyond the essentials to include features and tools indispensable for running critical solutions in production. With such a differentiation found in commercial software, we may wonder whether a solution built on top of an open source database like PostgreSQL can satisfy all the enterprise requirements.

So, in this talk, we shall discuss how you can build an Enterprise Grade PostgreSQL using open source solutions.

We'll discuss a list of Enterprise-grade features that include -
1. Securing your PostgreSQL database cluster
2. High Availability for your PostgreSQL setup
3. Preparing a Backup strategy and the tools available to achieve it
4. Scaling PostgreSQL using connection poolers and load balancers
5. Tools/extensions available for your daily DBA life and detailed logging in PostgreSQL.
6. Monitoring your PostgreSQL and real-time analysis.


Speakers

Avinash Vallarapu

Avinash Vallarapu (Percona)

PostgreSQL Support Tech Lead

Biography:

* Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB. He is an avid Python and Golang developer. He has co-authored a book on PostgreSQL : Beginning PostgreSQL on Cloud and another book on MySQL is in progress.

* He spoke at various PostgreSQL Conferences in the past including -
* PGCONF India - 2017 - Bengaluru, India.
* PGCON 2018 - Ottawa, Canada.
* Percona Live - PostgreSQL Track (2018) - Frankfurt, Germany.
* PGCONF India - 2019 - Bengaluru, India.

* His areas of expertise are PostgreSQL Training, Consulting and Migrations.


Slides



  Download Slides  


Video

Please sign in for 15 day access

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863