OpenSource cost-efficiency in action: analyzing 500B rows on a single ClickHouse server
Percona Live SessionsOperations
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
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
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