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


Jun 19, 2019

Embedding SQL Engine to Your Application

Iwo Panowicz (Percona) delivers the talk, "Embedding SQL Engine to Your Application", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Embedded databases, tightly integrated with application software, are a great alternative to standalone database systems for small applications. This talk will cover:

- Comparison of popular embedded databases engines (Berkeley DB, SQLite, Firebird...

Percona Live SessionsOpen Source Database


Jun 19, 2019

Solving Everyday Data Problems with FoundationDB

Ryan Worl (Consultant) delivers the talk, "Solving Everyday Data Problems with FoundationDB", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Ryan will demonstrate how FoundationDB can be applied to solve real business problems today and how to map common infrastructure components like logs, tables, and indexes into a cohesive system within FoundationDB. His example applies these techniques...

Percona Live SessionsOpen Source Database


Jun 19, 2019

Storing Time Series in 2019: Modern Database Performance, Scalability, and Reliability Comparison

Evgeny Potapov (ITSumma) delivers the talk, "Storing Time Series in 2019: Modern Database Performance, Scalability, and Reliability Comparison", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

At ITSumma, we provide 24/7 site reliability engineering for more than 300 clients with 10,000+ servers in total, collecting over 200 thousand metrics per second.

In 2010, we realized that...

Percona Live SessionsBusiness / Case StudyOpen Source DatabaseMonitoring and Operations


Jun 19, 2019

Tarantool. No-SQL DBMS Now With SQL

Kirill Yukhin (MailRU), Konstantin Osipov (MailRU) deliver the talk, "Tarantool. No-SQL DBMS Now With SQL", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Kirill & Kostja will present an overview of Tarantool, an open source in-memory DBMS. They will explain why it is cool to have a DBMS in the same address space as your application server, why Tarantool is in fact single threaded and...

Percona Live SessionsOpen Source Database


Jun 19, 2019

ClickHouse Data Warehouse 101: The First Billion Rows

Alexander Zaitsev (Altinity), Robert Hodges (Altinity LTD) deliver the talk, "ClickHouse Data Warehouse 101: The First Billion Rows", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Columnar stores like ClickHouse enable users to pull insights from big data in seconds, but only if you set things up correctly. This talk will walk through how to implement a data warehouse that contains 1.3...

Percona Live SessionsBusiness / Case StudyOpen Source Database


Pages