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
Percona Live SessionsMySQLPerformance Optimization
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
Percona Live SessionsMySQLOperations
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.
- Retrospective of the past year for MySQL at Shopify in...
Percona Live SessionsCloudMySQL
Anti-cheating tool for massive multiplayer games using Amazon Aurora and ML services - Percona Live Online 2020
Percona Live Sessions
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
Migrate from MongoDB Replica-Set to a Sharded Cluster - Antonios Giannopoulos & Jason Terpko - Percona Live Online 2020
Percona Live SessionsMongoDBMigration
Percona Live SessionsContainers and Automation
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