Avinash Vallarapu

Avinash Vallarapu

Avinash Vallarapu

PostgreSQL Support Tech Lead, Percona

Biography:

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.


All Sessions

High Availability and Automatic Failover in PostgreSQL using Open Source Solutions

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.

Introduction to PostgreSQL for MySQL and Oracle DBAs

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
Streaming replication

Building an enterprise level PostgreSQL deployment from open source tools

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 101

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.

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