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


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


May 25, 2020

How Safe is Asynchronous Master-Master Setup in MySQL?

It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.

While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active...

MySQLOperationsHigh Availability


May 22, 2020

MariaDB 10.4 and the Competition - Kaj Arno - Percona Live Online 2020

There are many good databases out there. Picking the right database for your project is never easy. There are technical criteria, business criteria, perhaps even ethical criteria. In this keynote, MariaDB Foundation CEO Kaj Arnö will present his – obviously completely impartial – view of the process.

Should you pick a database in the cloud or on-premise? Should you pick a relational database or a NoSQL database? Should you pick...

Percona Live SessionsMariaDB


Pages