Register Now!
Zalando, Europe’s leading online fashion platform, trusts PostgreSQL to manage more than 15TB of data in total. While PostgreSQL is rock-solid and robust, it doesn't have built-in failover capabilities. In order to rapidly deploy and reliably run numerous PostgreSQL clusters on Amazon cloud and in existing data centers we've developed Patroni, a daemon to manage PostgreSQL.
Open Source Database Sessions
The Percona Live Open Source Database Conference Europe 2016 is the premier event for the rich and diverse open source database ecosystem in Europe.
There are more than 100 open source databases in the world, each with their own design and use case sweet spots. Learn about some of the most popular open source databases, their design use cases, user stories as well as how they work with together with MySQL and MongoDB.
Percona Live provides in-depth discussions for your open source database high availability, IoT, cloud, big data and other changing business needs by tackling subjects such as analytics, architecture and design, security, operations, scalability and performance.
Below are the talks and tutorials covering open source databases at this year’s conference.
11:20am to 12:10pm
Winterthur
- OSDBMS
- PostgreSQL
Oleksii Kliukin,
Alexander Kukushkin
Devops
High Availability
Replication
12:20pm to 1:10pm
Lausanne
- OSDBMS
- MongoDB
Álvaro Hernández
What if you could seamlessly replicate all your MongoDB data to a native SQL database?
With NoSQL you can scale out, you don’t need to pre-define your schema, and it maps naturally to the OO world. But how do you perform data discovery? How do you interact with the vast SQL ecosystem, specially the BI tools?
MongoDB
Java
NoSQL
2:10pm to 3:00pm
2:10pm to 3:00pm
Matterhorn 1
- OSDBMS
- Development
Markus Winand
SQL has evolved beyond the relational model over the past decades and can now solve many problems more easily as compared to good old SQL-92. However, due to the limited support in open source databases, this revolution has been largely unnoticed in the open source scene. Until now. At the moment, many open source databases are adding these new features to their portfolio.
MySQL
Programming
Fundamentals
2:10pm to 3:00pm
St. Gallen
- OSDBMS
Kris Köhntopp
Abstract: While MySQL is big at Booking, it can't do everything. We are also running Hadoop, HBase, Cassandra, Riak, Postgres and even MongoDB in some places, with Kafka becoming the emergent data bus connecting everything together.
Tools and Techniques
Programming
Data in the Cloud
3:10pm to 4:00pm
Winterthur
- OSDBMS
- PostgreSQL
Ilya Kosmodemiansky
This talk is prepared as a bunch of slides, where each slide describes a really bad way people can screw up their PostgreSQL database and provides a weight - how frequently I saw that kind of problem. Right before the talk I will reshuffle the deck to draw ten random slides and explain you why such practices are bad and how to avoid running into them.
MySQL
Other
Fundamentals
4:20pm to 5:10pm
4:20pm to 5:10pm
Matterhorn 1
- OSDBMS
- Analytics
Alexey Vladishev
Zabbix, Free and Open Source monitoring solution, is designed to monitor the entire stack of IT infrastructure from hardware to business services. However, during my talk I would like to focus particularly on Zabbix capabilities in regard to monitoring of performance, availability and consistency of database engines.
Metrics
Monitoring
4:20pm to 5:10pm
Winterthur
- OSDBMS
- PostgreSQL
Sveta Smirnova,
Alexander Korotkov
It's widespread belief that SQL DBMSes are doomed to be hulking because of burden of backward compatibility. This belief is frequently used by marketing of various NoSQL DBMSes. However, this is not necessary true. Development in Open Source community makes product development flexible enough to meet needs of the times.
MySQL
Other
5:20pm to 6:10pm
Winterthur
- OSDBMS
- PostgreSQL
Ilya Kosmodemiansky
Linux operating system has lots of tuning options which can change performance of your PostgreSQL installation drastically.
Other
Optimization
9:15am to 9:25am
None
- OSDBMS
9:30am to 9:55am
None
- OSDBMS
Peter Zaitsev
Percona Contributions to the Open Source Database Ecosystem
MySQL
MongoDB
Other
10:00am to 10:20am
None
- OSDBMS
Otto Kekäläinen
In recent years MariaDB has gained a lot of interest and we are seeing
it being adopted by many well known entities like Wikipedia, Alibaba,
Google and Amazon. It has been embraced by most Linux distributions and
other open source projects.
Other
11:20am to 12:10pm
11:20am to 12:10pm
Matterhorn 1
- OSDBMS
- Analytics
Victor Tarnavsky
Yandex team has built one of the best databases for analytics. It's fast, capable for storing petabytes of data and supports SQL.
Now it goes open-source.
During the session we will review ClickHouse most interesting features and advantages.
Metrics
Business Intelligence
11:20am to 12:10pm
St. Gallen
- OSDBMS
- MySQL
Taco Scargo,
Karan Singh
OpenStack is getting popularity among various industry segments for providing both internal and external IT services. Counting on OpenStack user survey, Ceph is the #1 and the most loved storage backend for providing persistent block storage service through OpenStack Cinder.
MySQL
OpenStack
Data in the Cloud
12:20pm to 1:10pm
12:20pm to 1:10pm
Matterhorn 1
- OSDBMS
- Scalability/Performance
Christos Erotocritou
Join Christos Erotocritou, Principal Solution Architect EMEA at GridGain Systems to learn how to boost performance 1,000x and scale to over 1 billion transactions per second with in-memory storage of hundreds of TBs of data for your SQL-based applications.
Christos will show how Apache Ignite handles auto-loading of SQL schema and data, SQL indexes, compound indexes support, and various forms o
Java
Data as a Service
High Availability
12:20pm to 1:10pm
Zürich 2
- OSDBMS
- Development
Sergei Golubchik
New MariaDB major release is out of the door. It comes with new unique features, fixes old historical MariaDB/MySQL limitations, implements performance enhancements, and has better compatibility with latest MySQL versions.
MySQL
Programming
Fundamentals
12:20pm to 1:10pm
Winterthur
- OSDBMS
- Development
Ilya Verbitskiy
Description:
RethinkDB is an open source nosql scalable database built for real-time applications. It is a good data storage. You should give it a try if you are looking a flexible data store for rapid development or you need to scale an application with a very little effort.
Abstract:
Time to market has been an important challenge for all startups for years.
Programming
NoSQL
2:10pm to 2:35pm
2:10pm to 2:35pm
Matterhorn 1
- OSDBMS
- Development
Konstantin Osipov
Dynamic random access memory is getting cheaper every day, and
ever growing set of applications is becoming fully RAM-resident.
In this talk I'll state the case for in-memory technology
in purely engineering terms: how memory-focused algorithms
and data structures create a performance and
efficiency edge over traditional systems, significant enough to
justify an own product family:
Tools and Techniques
Other
2:10pm to 2:35pm
Matterhorn 2
- OSDBMS
- New and Trending Topics
2:10pm to 2:35pm
Winterthur
- OSDBMS
- Development
Laurent Doguin
In today’s world of agile business, developers and organizations benefit when JSON-based NoSQL databases and SQL-based querying come together. NoSQL provides schema flexibility, high performance, and elastic scaling. SQL provides expressive, independent data access.
Developers need to deliver apps that readily evolve, perform, and scale, all to match changing business needs.
Couchbase
NoSQL
2:40pm to 3:05pm
Winterthur
- OSDBMS
- Architecture/Design
Alexander Krasheninnikov
Most of contemporary information systems have a stream of some events (payments, likes, votes, messages etc.).
Without being able to measure this information flow, it is useless. And there is no problem, if event rate is not very high, or event stream should be measured in short-term windows, e.g. there is no need in distributed information processing.
Hadoop
Spark
Tools and Techniques
3:10pm to 3:35pm
3:10pm to 3:35pm
Matterhorn 1
- OSDBMS
- Operations and Management
Marc Berhault
This talk takes a deep dive into CockroachDB, a database whose “survive and thrive” model aims to bring the best aspects of Google's next generation database, Spanner, to the rest of the world via open source.
Data in the Cloud
High Availability
Replication
3:10pm to 3:35pm
Zürich 1
- OSDBMS
- MySQL
Abbas Ahmed
The shift to a Microservices oriented architecture for a large organization presents a challenge to manage scale, changes in replication topology and keeping the applications requiring to follow these changes pointing to the correct data sources for reading and writing data.
I would like to present a design pattern for Micro Service data layer discovery that we have successfully deployed at Ren
MySQL
Tools and Techniques
Web Services
3:10pm to 3:35pm
Zürich 2
- OSDBMS
- Operations and Management
Duy Hai Doan
Since the introduction of its Query Language (CQL), Cassandra is getting closer to the RDBMS world in term of features but sticking to its core distributed nature Not only does Cassandra pick the good ideas from RDBMS to adapt them to the distributed architecture but it also introduces distinct features you cannot find in the RDBMS world.
Cassandra
3:10pm to 3:35pm
St. Gallen
- OSDBMS
Konstantin Osipov
Dynamic random access memory is getting cheaper every day, and
ever growing set of applications is becoming fully RAM-resident.
In this talk I'll state the case for in-memory technology
in purely engineering terms: how memory-focused algorithms
and data structures create a performance and
efficiency edge over traditional systems, significant enough to
justify an own product family:
Tools and Techniques
Other
3:10pm to 3:35pm
Lausanne
- OSDBMS
- MySQL
Rachid Zarouali
Percona Monitoring and Management is a very powerful set of tools.
Built on top of prometheus and grafana, it comes bundled with major parts of a wide range monitoring system (not only database).
As most of IT systems already have a monitoring platform, How to integrate PMM within an existing system ?
what kind of customization should be made to ease the process ?
How to stay as close as possi
MySQL
Docker
Monitoring
3:10pm to 3:35pm
Winterthur
- OSDBMS
- New and Trending Topics
Itamar Haber
The next version of Redis will support modules. Redis Modules are pluggable libraries for extending its functionality and introducing new functionality and data types. Anyone can develop modules for themselves, or for others to use. Redis Modules are the greatest leap ever made by Redis towards unlimited versatility. The Modules API will go live soon, but you can develop new modules right now.
Redis
Tools and Techniques
Programming
3:40pm to 4:05pm
3:40pm to 4:05pm
Matterhorn 1
- OSDBMS
- Operations and Management
Peter Zaitsev
This is a high-level presentation that discusses the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this presentation, we will look at how to address such concerns to help get a migration commitment.
MySQL
Other
3:40pm to 4:05pm
Zürich 1
- OSDBMS
- New and Trending Topics
Marco "The Grinch" Tusa
After some years, MySQL with Galera became the most common solution for synchronous replication. The cloud (and EC2 in particular) was one of the platforms that most successfully employed MySQL/Galera installations.
MySQL
AWS
Data in the Cloud
4:25pm to 5:15pm
4:25pm to 5:15pm
Zürich 1
- OSDBMS
- MySQL
Federico Razzoli
MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations.
Their features and limitations are similar, but not identical. The main difference is that only MySQL allows you to build an index on a non-persistent column.
In this talk we'll present some use cases for virtual columns, such as query simplification and UNIQUE constraints based on an SQL expression.
MySQL
Optimization
4:25pm to 5:15pm
St. Gallen
- OSDBMS
Max Liu
This session takes you to the journey of building TiDB, an open source NewSQL database inspired by Google F1 and Spanner. In the battlefield of database solutions, whenever it comes to horizontal scaling and ACID transactions, the infrastructure experts have to compromise and trade off against their own will. TiDB aims to help them kill two birds with one stone.
MySQL
Data in the Cloud
4:25pm to 5:15pm
Lausanne
- OSDBMS
- MySQL
Ivan Zoratti
ScaleDB is a clustered, distributed storage engine for MariaDB, optimised for high volume, high velocity structured data.
MySQL
Fundamentals
Sharding
5:25pm to 6:15pm
5:25pm to 6:15pm
Matterhorn 1
- OSDBMS
- Scalability/Performance
Johan De Gelas
Intel’s Xeon has been sitting on the mighty throne of server hardware for seven fat years now and gathered many riches from this dominant position.
However, two new great houses have emerged: the house of “ARMv8 SoCs” and the house of “OpenPOWER”.
MySQL
Spark
5:25pm to 6:15pm
Zürich 2
- OSDBMS
- MySQL
Jeremy Tinley
A look at how Etsy expanded MySQL capacity, reduced power and improved query speed by switching to SSD storage. The talk will include a short overview of the database architecture at Etsy and the rationale for making a hardware change.
MySQL
Tools and Techniques
Sharding
5:25pm to 6:15pm
St. Gallen
- OSDBMS
- MySQL
VAROQUI Stephane,
Kayoko GOTO,
Kentoku SHIBA
When your database is growing, you definitely need to think about other techniques like database sharding. SPIDER is a MariaDB Server / MySQL storage engine for database sharding. Using SPIDER, you can access your data efficiently across multiple database backends.
In this time we will introduce the following things.
1. why SPIDER? what SPIDER can do for you?
2. when SPIDER is right for you?
MySQL
Tools and Techniques
Sharding