Avinash Vallarapu joined Percona in the month of May 2018. Before joining Percona, Avi worked as a Database Architect at OpenSCG for 2 Years and as a DBA Lead at Dell for 10 Years in Database technologies such as PostgreSQL, Oracle, MySQL and MongoDB. He has given several talks and trainings on PostgreSQL. He has good experience in performing Architectural Health Checks, Performance Tuning and Migrations to PostgreSQL Environments.
PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while maintaining a secondary focus on Oracle compatibility gave PostgreSQL a great market penetration. When a database server is deployed in production we often wish to achieve several 9's of availability. Is that even possible with PostgreSQL? What is the combination of tools that you could combine and implement to achieve High Availability (HA) and automatic failover in PostgreSQL? How can we avoid data loss during such failover's? We'll address these questions and then some more in this talk.
This tutorial is focused on teaching PostgreSQL to professionals that are already experienced with MySQL or Oracle. Relational databases share a lot of similar concepts. You may find it easier if we help you relate the concepts of PostgreSQL with Oracle/MySQL. Thus, we would start with PostgreSQL Architecture for Oracle/MySQL DBAs. As we discuss from basics, even a beginner may adapt the concepts easily. Thus, the approach we take with this tutorial is to present an overview of the PostgreSQL architecture and operation in view of MySQL's and Oracle's. We'll mix lecture with hands-on work, having the audience apply the concepts we present in practice in a lab format before covering new ones, starting with a simple and quick installation of PostgreSQL and going all the way to setup and maintain a stand by replica. By the end of the day attendees shall walk away from this tutorial with a good understanding of how PostgreSQL works and feel confident enough about it.
Following are the main points being discussed in this tutorial :
Brief history of PostgreSQL and its features
PostgreSQL Architecture for MySQL/Oracle DBAs and beginners.
Installation of PostgreSQL
Creating/Start/Stop a PostgreSQL Cluster and the components of a Data Directory
PostgreSQL parameters/settings you need to know
PostgreSQL User Management
MVCC in PostgreSQL
VACUUM and Transaction ID Wraparound in PostgreSQL
Types of Indexes
EXPLAIN in PostgreSQL
Logical and Physical Backups and PITR
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.
PostgreSQL is an advanced open source database software that is completely community driven.
It is also important to understand how different it is from MySQL conceptually and where is it different from MySQL.
This talk starts with a brief overview on PostgreSQL and conceptual differences between PostgreSQL and MySQL.