May 26, 2020

OpenSource cost-efficiency in action: analyzing 500B rows - Alexander Zaitsev - Percona Live Online

OpenSource cost-efficiency in action: analyzing 500B rows on a single ClickHouse server

Percona Live SessionsOperations


May 26, 2020

Percona Monitoring and Management 2.6 - Security Threat Tool - Percona Live Online 2020

Steve Hoffman, Daniel GB In this presentation, we will talk about Uber's journey from using Cassandra as one of the primary databases to an in-house scalable and consistent replacement built on top of MySQL. We will talk about some of the challenges related to reliability, developer productivity and efficiency that we faced when using Cassandra. We will go over the architecture of the in-house replacement, the design principles that we...

Percona Live SessionsPercona Monitoring and Management


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 2

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

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 - P

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


Pages