Jun 17, 2019

Upgrade or Migrate Your PostgreSQL Database Through a Lowest Possible Downtime

Avinash Vallarapu (Percona) delivers the talk, "Upgrade or Migrate Your PostgreSQL Database Through a Lowest Possible Downtime", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

PostgreSQL performance varies between different releases. Every new version comes with added features and performance improvements that help the growing adoption of PostgreSQL. All these continuous These ongoing...

Percona Live SessionsPostgreSQL


Jun 17, 2019

HA PostgreSQL on Kubernetes by Demo

Josh Berkus (Red Hat) delivers the talk, "HA PostgreSQL on Kubernetes by Demo", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

You can have fully automated high availability PostgreSQL on your Kubernetes cluster ... today. The Patroni system for automating PostgreSQL deployment, failover, and migration is ready to use and in production in several places. In this live demo session, we will...

Percona Live SessionsPostgreSQLHigh AvailabilityMigration


Jun 17, 2019

Building a Kubernetes Operator for Percona XtraDB Cluster

Tyler Duzan (Percona) delivers the talk, "Building a Kubernetes Operator for Percona XtraDB Cluster", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

This talk covers some of the challenges we sought to address by creating a Kubernetes Operator for Percona XtraDB Cluster, as well as a look into the current state of the Operator, a brief demonstration of its capabilities, and a preview of...

Percona Live SessionsOpen Source DatabasePostgreSQLPercona XtraDB Cluster


Jun 17, 2019

Zheap: The Next Generation Storage Engine for Postgres

Ken Rugg (Enterprise DB) delivers the talk, "Zheap: The Next Generation Storage Engine for Postgres", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

In the past few years, Postgres has advanced a lot in terms of features, performance, and scalability for many core systems. However, one of the problems that many enterprises still complain of is that its size increases over time which is...

Percona Live SessionsBusiness / Case StudyOpen Source DatabasePostgreSQL


Jun 17, 2019

Getting Started with PostgreSQL

Kevin Markwardt (Pythian) delivers the talk, "Getting Started with PostgreSQL", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

PostgreSQL is undoubtedly the second most popular open source RDBMS and it is within the top five most popular DB engines as per db-engines.com. Why not take a rest from your favorite database server for a while, start learning some more about it, and aim for...

Percona Live SessionsOpen Source DatabasePostgreSQL


Jun 17, 2019

Gonymizer: A PostgreSQL Tool for Anonymizing Protected Health for HIPAA Compliant Test Infrastructure

Levi Junkert (SmithRx) delivers the talk, "Gonymizer: A PostgreSQL Tool for Anonymizing Protected Health for HIPAA Compliant Test Infrastructure", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.
With the advent of the Health Insurance Portability and Accountability Act (HIPAA) of 1996 all entities that handle health information are required by law to secure all data which contains personally...

Percona Live SessionsOpen Source DatabasePostgreSQL


Jun 17, 2019

MySQL Group Replication vs PostgreSQL Bi-Directional Replication

Mariella DI Giacomo (ViaSat) delivers the talk, "MySQL Group Replication vs PostgreSQL Bi-Directional Replication", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Integrating the most suitable highly available multi-master, non clustered, freely accessible
relational database management system (RDBMS)
solution for large scale environments is a challenging task; it
...

Percona Live SessionsOpen Source DatabasePostgreSQLMariaDBMySQL


Jun 17, 2019

NoSQL to PostgreSQL - Adventures in Migrations

Philip Hildebrand (Moz) delivers the talk, "NoSQL to PostgreSQL - Adventures in Migrations", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Considering a move to PostgreSQL? Here's a chance to learn from all the fun adventures we had moving one of our services from RethinkDB to PostgreSQL.

From materialized view refreshes, to system view queries, to torn page analysis, there's never...

Percona Live SessionsPostgreSQL


Jun 17, 2019

A Deep Dive Into PostgreSQL Indexing

Ibrar Ahmed (Percona) delivers the talk, "A Deep Dive Into PostgreSQL Indexing", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index...

Percona Live SessionsPostgreSQL


Jun 17, 2019

Future of Postgres

Ken Rugg (Enterprise DB) delivers the talk, "Future of Postgres", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Ken will share insights on the Future of Postgres - what's new, what's next, and what we are aspiring toward. He will cover:

* Roadmap for PostgreSQL 12 and beyond
* Community updates
* New ways Postgres is being used in the market

Percona Live SessionsPostgreSQL


Pages