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


Jun 19, 2019

Building Kubernetes Operator for Percona Server for MongoDB

Doug Duncan (Percona) delivers the talk, "Building Kubernetes Operator for Percona Server for MongoDB", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Doug will discuss the basic knowledge needed to understand the complications of running MongoDB inside of a containerized environment and then to go over the specifics of how Percona solved these challenges in the PSMDB Operator. It also...

Percona Live SessionsMongoDB


Jun 19, 2019

Fast, Reliable, Secure and Affordable: MongoDB on AWS EC2

Paul Marcelin delivers the talk, "Fast, Reliable, Secure and Affordable: MongoDB on AWS EC2", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Self-managing MongoDB on AWS EC2 gives you the best of a leading open-source database and a leading cloud computing platform. I will explain the AWS concepts you need to know to set up and maintain a fast, reliable, secure and affordable MongoDB...

Percona Live SessionsPostgreSQLMongoDBCloud Solutions


Jun 19, 2019

Managing Data and Operation Distribution In MongoDB

Jason Terpko (ObjectRocket), Antonios Giannopoulos (ObjectRocket) deliver the talk, "Managing Data and Operation Distribution In MongoDB", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

In a sharded MongoDB cluster, scale and data distribution are defined by your shard keys. Even when choosing the correct shards key, ongoing maintenance and review can still be required to maintain optimal...

Percona Live SessionsMongoDB


Pages