Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Slides from Percona Live

MongoDB is quickly becoming one of the NoSQL standards, but represents a very different way of thinking from traditional RDBMSs. Many database users tend to think of things from the perspective of the transactional DBs that they know and love, but there are other ways of doing things. Let the Percona Solutions Engineering team help you fill out your database resume and become a more knowledgeable user by showing you the basics. No...
The next version of MySQL will be a major release of new features and capabilities including a new data dictionary hosted in InnoDB. Learn all about the changes coming in the next version of InnoDB.
Cloud competition is heating up and the real winner is going to be you! Run your workloads wherever the price is right and avoid the dreaded cloud lock-in. The real trick is finding a way to co-exist in multiple clouds or even cloud and data center. Having a reliable and consistent data isn’t an easy problem to solve but I can show how to do it. Apache Cassandra was purpose built for the cloud with replication as a first principle and...
Skeema (http://skeema.net) is a new open source CLI tool for managing MySQL schemas and migrations. It allows you to easily track your schemas in a repo, supporting a pull-request-based workflow for schema change submission, review, and execution. This session will introduce Skeema, walking through its functionality and usage. Attendees will learn how to: * Get started by exporting schemas to a Git repo * Diff changes in the schema...
The goal of the talk is to review the GIS improvements in MySQL 5.7 and new additions in MySQL 8.0 (new this year!), provide some general review of the functionality, as well as some working demos. We'll also have a high-level review of MongoDB's GIS functionality, and discuss the pros/cons between MySQL and MongoDB and how you can use them in conjunction. Attendee takeaway: - Overview of GIS functionality in MySQL (5.7...
Sitecore is a very popular .Net CMS which relies on MongoDB for several key components. This presentation will review all Sitecore elements as they relate to MongoDB, and consider the broader lessons one can learn for any application with parallel types of usage. We’ll share how to optimize MongoDB for Sitecore workload patterns, such as for managing various categories of HTTP Session state, Sitecore “xDB” write-heavy analytics, and for...
In this session, I will describe the new features that have all ready been announced for MySQL 8.0. In addition to Data Dictionnary, CTEs and windows function the session is covering: * Move to utf8(mb4) as MySQL's default character set * Language specific case insensitive collation for 21 languages (utf8) * Invisible index * Descending indexes * Improve usability of UUID and IPV6 manipulations * SQL roles * SET PERSIST...
A new data dictionary based on transactional tables is being developed for MySQL Server. People could already play with it in the 8.0.0 dmr. This project is a huge step forward, improving many aspects of the server even Information_Schema! The transactional data dictionary provides a new way of accessing metadata for use both by server and plug-in developers. This session examines the data dictionary, discussing its purpose, design goals,...
To operate MongoDB efficiently, you need to have insight into database performance. And with that in mind, we’ll dive into monitoring in this talk. MongoDB offers many metrics through various status overviews and commands, but which ones really matter to you? How do you trend and alert on them? What is the meaning behind the metrics? We’ll discuss the most important ones and describe them in ordinary plain MySQL DBA language. Finally we...
MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. It provides shared-nothing clustering and auto-sharding for MySQL, accessed via SQL and NoSQL interfaces. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability. MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL...
Load balancing MySQL connections and queries using HAProxy has been popular in the past years. Recently however, we have seen the arrival of MaxScale, MySQL Router, ProxySQL and now also Nginx as a reverse proxy. For which use cases do you use them and how well do they integrate in your environment? This session aims to give a solid grounding in load balancer technologies for MySQL and MariaDB. We will review the wide variety of...
Two new SQL features in MySQL 8.0 are presented in this session; Common Table Expressions (CTE) and Window Functions.In their simplest form, CTEs are a way of creating a view/temporary table for usage in a single query. However, they have many more use cases. In particular, when using the RECURSIVE form of CTEs, it is possible to perform advanced tasks with few lines of code. This session will present several examples on how you can...
Performance of SQL queries plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. This tutorial covers query processing, optimization methods, and how the MySQL optimizer chooses a specific plan to execute SQL. It demonstrates how to use tools such as EXPLAIN (including Structured and Visual EXPLAIN), Optimizer Trace, and Performance Schema to analyze query plans...
The most popular High Availability (HA) techniques deployed are based on making services redundant, in particular by means of replication. This fits quite naturally in the MySQL universe as the MySQL server has provided a mature replication solution for over a decade now. Moreover, the new replication developments and its roadmap show that it is also catering for the requirements posed by popular environments such as the cloud....
MySQL Group Replication is a new plugin that implements an exciting extension to the proven and long standing MySQL Replication technology. It leverages advanced distributed protocols to ultimately provide to the end user features such as data replication, high availability, split brain protection and automation. It can be deployed in single-primary mode (default), in which primary fail-over is handled gracefully and automatically...
Starting with MySQL 5.7 a new Document Store feature has been introduced that makes working with JSON documents an integral part of the MySQL experience. The new X DevAPI gives MySQL users the best of both worlds - SQL and NoSQL - and allows an entirely new category of use cases for managing data. It is constantly evolving based on the community feedback and can be run on top of the brand new MySQL InnoDB Cluster feature. This session...
Many users who follow MySQL development are aware that recent versions introduce a number of improvements to query execution (via the addition of new execution strategies, and an improved cost model). But what is not talked about enough, is that the diagnostic features are also significantly better. For example, since EXPLAIN FORMAT=JSON shows cost information, it is possible to have an x-ray view of how decisions are being made...
This tutorial will guide you through the many considerations when deploying a sharded cluster. We will cover the services that make up a sharded cluster, configuration recommendations for these services, shard key selection, use cases, and how data is managed within a sharded cluster. Maintaining a sharded cluster also has its challenges. We will review these challenges and how you can prevent them with proper design or ways to resolve...
This presentation will demonstrate how you can use the aggregation pipeline with MongoDB similar to how you would use GROUP BY in SQL and the new stage operators coming 3.4. MongoDB’s Aggregation Framework has many operators that give you the ability to get more value out of your data, discover usage patterns within your data, or use the Aggregation Framework to power your application. Considerations regarding version, indexing, operators...
Seznam.cz is the largest and the most visited web portal and search engine in the Czech Republic. It is one of a few search engines in the World which successfully competes with Google in the field of local full-text search. Besides the Search engine, Seznam runs over 40 different web services such as News portals, Map portal, Email service and many more. Thanks to various services we have many projects where we need different data...