Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Slides from Percona Live

Redis enables your MySQL or MongoDB environment to grow in scale and complexity without compromising on your applications’ real-time needs. Redis is an ultra-high performing in-memory, NoSQL database platform commonly used as a database, cache, and message broker. In this session, you will learn how to program your applications to use Redis, and how to leverage it for use cases such as session store, content cache, real-time transactions,...
We'll start off with an overview of Vitess and will drill down on its newer features: MySQL protocol, bulk statements, 2PC and Messaging. Following this, Robert Navarro from Stitch Labs will talk about their production experience with Vitess & Percona, how they migrated, what they like and what they'd like to see going forward.
If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants / customers / accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database. As these tables grow however, you need to think about ways to scale your multi-tenant database...
Warp 10 is an Open Source solution for managing and analyzing time series data in multiple environments. Warp 10 offers an ingestion and storage layer based on LevelDB or HBase, and a data manipulation environment built around a custom language called WarpScript designed from the ground up for time series data analysis. WarpScript can be leveraged on data residing in Warp 10 or any other other datasource. WarpScript can also be...
As a TAM at Percona I have seen multiple environments with managed services of just MySQL, just MongoDB and with hybrid deployments of MongoDB and MySQL. I'd like to familiarize potential users of both open source databases to the best practices of having a hybrid environment. Discuss what will be the best tool for the job in what scenario, and how to move data between environments without worries for consistency.
MongoDB Security is regularly in the news but what they don’t say is it’s all been avoidable. Simple mistakes add up to giant headaches and loss of management and customer confidence in you the DBA. We will cut through the marketing and hype and give your a real world playbook on what to do how to do it for securing your system. This will include, enabling authentications, understand and building custom roles and users, knowing how to...
In MongoDB you normally have the choice of WiredTiger or MMAPv1, and with Percona Server we have added two more engines( MongoRocks and In Memory). How do you know which to use? How do you know which to tell developers to not use. How do these affect how you might design you data access functions and your schema? This are all areas we will touch on to help make sure you're picking the right engine for your workload, and in some...
Sharding is a large and complex topic but in this talk we will focus on helping you planning if you do shard, then what is a good attack plan for when you do want to shard. In understanding how you plan for sharding, you will learn what restrictions does this put on your data, what functions no longer work, what functions are bottlenecks when shard and more. Then will talk about how to you determine what your shard key should be with...
MongoDB Replication Tags, hidden notes, priority, votes and more are some of the least understood parts of MongoDB. We will talk about these how to consider using them or not using them, and even how this plays into your engine choices at times.
MongoDB has 12 index types. Do you know how each works, or when each should be used. This talk is about arming you with this knowledge as well as understanding how the index impact performance, storage, and even sharding of your data. We will also talk about what are some solid index operational practices, and some settings around things like TTL you might not know exist but will make you a Rock Star!
Every good DBA wants to be a master of the shell for the DB. In this session we will help you understand how to structure commands, and discuss all the advanced functions and ways to chain command in the mongo shell. We will touch on CRUD functions, but much more time will be spent on the other areas as we have provide a dedicated session to master CRUD operations in MongoDB. An example of knowledge you will have is how to compare data...
MongoDB has its own commands and structure of functions to ask the database to do work. In this talk we will discuss how the query, update, delete, and inserts work. However we will go beyond that talking about operators you should and shouldn’t use, and how this might actually drive your schema choices. Then we will talk about operationally sound ways for bulk deleting and inserting when you want to limit the impact on production and...
In this session we will explain what trade offs both MySQL and MongoDB make in their document models. We will look into what use cases will do better in which style and why. Leaving the talk you should have a good foundation to help weigh the technologies against each other based on what database features your application really needs.
MySQL and MariaDB Server are providing many new features that can help with security and encryption, things that are becoming extremely important in today's world. Learn how to benefit from the usage of roles, to at-rest-encryption. At the end of this, you should have a securely configured MySQL instance!
The MySQL storage engine landscape is wide and varied (and for a very long time, it was the only database server to support this concept) - it started with MyISAM, and it became a solid database with the popular and default InnoDB storage engine. However there are many contenders and depending on the type of use case you might benefit from TokuDB or MyRocks, engines that are included in Percona Server for MySQL. Learn when to use the right...
When it comes to High Availability, Percona has spent time developing the Percona XtraDB Cluster product, based on Galera Cluster, and integrating it with ProxySQL to have a great out-of-the-box synchronous replication setup. Learn when its right to use this solution, and which deployments you would consider it for.
Percona Server 5.7 takes MySQL 5.7 as a base and adds new and interesting features like column encryption, an audit plugin, a high performance threadpool, and many other "enterprise" features made open. Learn about all these features that will help your queries run faster, more consistently, achieve higher uptimes, and take the guesswork out of management!
MySQL 5.7 has a lot of new features, and if you've dabbled with something older in the past, it is definitely worth learning what's new and how to use the new features that come with it. Learn about some features such as multi-source replication, global transaction IDs (GTIDs), security improvements, etc.
MySQL is famous for something you can install in less than five minutes and get going in terms of development. But you want to run this in production, at scale, so why not learn the best practices around installation, configuration, deployment, and backups. This is your soup to nuts talk that will have you going from zero to hero in no time, including best practices for installation, configuration, taking backups, monitoring, etc.
The MySQL world is full of tradeoffs and choosing a High Availability (HA) solution is no exception. Learn to think about High Availability the Percona way, and use the solutions that we deploy on a regular basis.