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