May 26, 2020

Unbounded scale: Using Vitess for scaling write intensive workloads - Percona Live Online 2020

Unbounded scale: using Vitess for scaling write intensive workloads by Morgan Tocker, Daniel Guzman Burgos
Scaling very large MySQL applications is the ultimate challenge, and there's no native solution for it. Since vertical scaling is not sustainable in time, horizontal scaling is the smartest move. Sharding issues within MySQL are not trivial but also not imposible. We will discuss thoses issues and how Vitess handle those to...

Percona Live SessionsMySQLScalability

May 26, 2020

Creating an Open Source MySQL Firewall - Alex Rubin - Percona Live Online 2020

Creating an Open Source MySQL Firewall

Percona Live SessionsMySQLPerformance Optimization

May 26, 2020

Declarative Caching with Postgres and Redis - Kyle Davis - Percona Live Online 2020

The concept of caching is not complicated: store the results of a query for a short period of time in a fast storage engine so you touch the slow and/or expensive database less. This simple concept often hides application-level complexity as not all queries should be cached. Deciding what to cache and what not to cache depends on many factors:
Will there be a performance benefit? Already short running queries may have negligible...

Percona Live SessionsPostgreSQLOperations

May 25, 2020

Strategies Used at Box to Protect MySQL at Scale - Priyanka Reddy - Percona Live Online 2020

At Box, the majority of our application data resides in a horizontally sharded MySQL infrastructure, made up of 100s of shards and 1000s of servers. We've built a distributed relational data service whose goal is to provide developers with a uniform, language-agnostic...

Percona Live SessionsMySQLOperations

May 25, 2020

MySQL on Google cloud: War and Peace! - Akshay Suryawanshi & Jeremy Cole - Percona Live Online 2020

Last year Jeremy Cole presented a prequel of this talk MySQL on GoogleCloud: The Good, the Bad and the Ugly. This year let’s take a look at how Shopify matured at living in the Cloud with some war and peace stories. We will present an in-depth look at our experience so far in the cloud: how it was rewarding many times, but also challenging some others.

    Topics covered
  • Retrospective of the past year for MySQL at Shopify in...

Percona Live SessionsCloudMySQL

May 25, 2020

Anti-cheating tool for massive multiplayer games using Amazon Aurora and ML services - Percona Live Online 2020

Yoav Eilat and Yahav Biran talked about the Multiplayer video games are among the most lucrative online services. The overall games industry worldwide generated an estimated $174B in 2019, according to IDC. With this popularity, cheating becomes a common trend. Cheating in multiplayer games negatively impacts the game experience for players who play by the rules, and it becomes a revenue issue for game developers and publishers. According...

Percona Live Sessions

May 25, 2020

Orchestrating Cassandra with Kubernetes Operator and Yelp PaaSTA - Percona Live Online 2020

At Yelp, Cassandra, our NoSQL database of choice, has been deployed on AWS compute (EC2) and AutoScaling Groups (ASG), backed by Block Storage (EBS). This deployment model has been quite robust over the years while presenting its own set of challenges. To make our Cassandra deployment more resilient and reduce the engineering toil associated with our constantly growing infrastructure, we are abstracting Cassandra deployments further...

Percona Live SessionsNoSQLOperations

May 25, 2020

Migrate from MongoDB Replica-Set to a Sharded Cluster - Antonios Giannopoulos & Jason Terpko - Percona Live Online 2020

When deploying a MongoDB instance, there is a couple of important decision that has to be made. An important one is a decision whether the instance is going to be a Replica-set or a Sharded Cluster. It’s not uncommon to start with a Replica-set, as its easier to deploy and simpler to operate. For some workload, the Replica-set instance may not be the best option, mainly performance-wise, and the migration to a sharded cluster is the only...

Percona Live SessionsMongoDBMigration

May 25, 2020

A Step by Step guide to using Databases on Containers - Kathy Gibbs - Percona Live Online 2020

In this session, I will detail in a step by step fashion how to install a database on a Docker container. I will step through how to get Docker loaded for testing, how to configure the containers, how to set up a script to install and start a PostgreSQL database (though the steps will be very similar for MySQL as well). I will then connect and restore the database that we just created. After this session, you will be able to go and set up...

Percona Live SessionsContainers and Automation

May 25, 2020

Profiling MySQL and MariaDB Hash Join Implementations- Jim Tommaney - Percona Live Online 2020

Hash Joins are a foundational join technology, now available in MySQL!

  • No index maintenance overhead.Can be orders of magnitude faster.Available for ad-hoc workloads and ETL.
  • Great complement to index join operations.

However, the underlying implementation is fundamentally different and introduces additional tweaks to optimize performance.
This presentation will give you the tools to learn when to...

Percona Live SessionsMariaDBMySQLOperations