Jun 19, 2019

A Deep Dive Into PostgreSQL Indexing

Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his talk "A Deep Dive Into PostgreSQL Indexing".

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

PostgreSQLCloudPercona MySQL Webinars


Jun 19, 2019

Using Ansible to Manage MySQL at DigitalOcean

Ben Mildren (DigitalOcean), Andrew Moore (DigitalOcean), Dan Kowalewski (DigitalOcean) deliver the talk, "Using Ansible to Manage MySQL at DigitalOcean", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

In this session we'll discuss how we use Ansible to manage the internal MySQL services at DigitalOcean, where this has worked well for us, as well as some of the issues we've experienced...

Percona Live SessionsContainers and AutomationMySQL


Jun 19, 2019

Operations -> SRE -> AIOps For Data Professionals

David Murphy delivers the talk, "Operations - SRE - AIOps For Data Professionals", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Our world is moving fast, and data is piling up. There was a time when DBA managed a few machines, then a few hundred, and now each DBA needs to handle thousands. To enable this, we are going to talk about how we used to monitor, then how SRE has changed the...

Percona Live SessionsContainers and AutomationOpen Source Database


Jun 19, 2019

Percona Server for MySQL 8.0

Laurynas Biveinis (Percona) delivers the talk, "Percona Server for MySQL 8.0", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

We will discuss the state of Percona Server for MySQL 8.0, now GA, and current developments around it.

Percona Live SessionsMySQLPercona Server


Jun 19, 2019

Scaling MySQL at Venmo

Dong Wang (PayPal Holdings Inc), Heidi Wang (PayPal Holdings Inc), Van Pham (Venmo) deliver the talk, "Scaling MySQL at Venmo", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

In this presentation, we'll cover the following areas:

- MySQL architecture and application eco system in Venmo
- Scalability challenges of MySQL for Venmo applications for Super Bowl peak traffic...

Percona Live SessionsMySQL


Jun 19, 2019

Immutable Database Infrastructure with Percona XtraDB Cluster

Satoshi Mitani (Yahoo Japan Corporation) delivers the talk, "Immutable Database Infrastructure with Percona XtraDB Cluster", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

In this session, we will discuss how we build Immutable infrastructure for databases.
Yahoo! JAPAN is the largest web portal in Japan. We have about 90 million unique browser accesses per month.

We have...

Percona Live SessionsOpen Source DatabaseMySQL


Jun 19, 2019

In-depth Percona Server/MySQL Encryption

Robert Golebiowski (Percona) delivers the talk, "In-depth Percona Server/MySQL Encryption", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

1) Keyrings
- General concepts
- what happens when keyring plugin is loaded
- where keys are stored
- troubleshooting
keyring initialization failures
taking care of core dumps
- keyring_vault
-...

Percona Live SessionsMySQL


Jun 19, 2019

Too Much Data?

Yves Trudeau (Percona) delivers the talk, "Too Much Data?", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Are you struggling with too much data? Are your MySQL databases able to ingest the influx of new data? Are you considering an alternate database but modifying your application would be challenging? Are you able to query efficiently your data once ingested?

All those questions...

Percona Live SessionsMySQL


Jun 19, 2019

Billion Goods in Few Categories: How Histograms Save a Life?

Sveta Smirnova (Percona) delivers the talk, "Billion Goods in Few Categories: How Histograms Save a Life?", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

We store data with an intention to use it: search, retrieve, group, sort... To do it effectively, the MySQL Optimizer uses index statistics when it compiles the query execution plan. This approach works excellently unless your data...

Percona Live SessionsMariaDBMySQL


Jun 19, 2019

Clickhouse Features to Blow your Mind

Aleksei Milovidov (Yandex) delivers the talk, "Clickhouse Features to Blow your Mind", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

I will present a subset of the most notable ClickHouse features over the last half of year:
- data skipping indices, including full text indices (with performance evaluation and insights on implementation);
- custom compression codecs for time...

Percona Live SessionsOpen Source Database


Pages