Don’t miss these talks on the Google community track at Percona Live Online
Join us in the Google community track at Percona Live Online on May 12–13, 2021 for talks on topics ranging from using databases with Kubernetes to database migration to observability and troubleshooting. Percona Live is a community-focused event for database developers, administrators, and decision-makers to network with peers and technology professionals.
Here’s a preview of some of the talks we’ll be presenting at the event.
How to choose the right solution when lifting and shifting your database to the cloud
Shachar Guz, Product Manager
Database migrations can be complex, time-consuming, and costly, increasing the risk of moving to the cloud. Enterprises need effective and reliable database migration tools that help automate this process for seamless cloud adoption.
In this session we will elaborate on the considerations to take into account when choosing database migration methods and technology, and the different aspects that can impact risk such as migration fidelity and downtime. You’ll leave knowing how to take into consideration critical aspects of the migration journey such as preparation, connectivity, and downtime, and how to leverage Database Migration Service for migration success.
Deploying highly available PostgreSQL with GKE
Christoph Bussler, Solutions Architect and Shashank Agarwal, Database Migration Engineer
When you have an application running in Google Kubernetes Engine, there are multiple options and considerations for how to deploy a database. In this session, you’ll learn some of the architectural considerations for choosing a database deployment option in GKE. We will demonstrate one of these options, as you learn how to configure PostgreSQL as a container in GKE based on regional persistent disks and PersistentVolumeClaims. Running PostgreSQL on regional persistent disks provides a RPO of zero in case of a zone outage and we will demonstrate how a failover takes place.
Demystifying database performance issues with SQL Commenter and Cloud SQL Insights
Jan Kleinert, Developer Advocate
Have you ever tried to troubleshoot a database performance issue in an application that was built using an ORM? ORMs can simplify development of applications that communicate with databases, but since the ORMs are generating the SQL statements, it can be difficult to determine which application code is resulting in slow queries.
SQL Commenter is an open source library that enables ORMs to augment SQL statements with comments about the code that caused its execution, making it easier to correlate your application code with the SQL statements that were generated by the ORM.
In this session, we will demonstrate how to set up and use SQL Commenter with an application that uses Knex to diagnose query performance. We’ll also touch on the other frameworks and ORMs that SQL Commenter supports as well as how you can view this data in database logs and observability tools, including Cloud SQL Insights.
Working effectively with Cloud SQL on Kubernetes
Eno Compton, Developer Relations Engineer
There’s a lot to like about Kubernetes and Cloud SQL, but it’s not always clear how to use them together. This talk will be a deep-dive into Cloud SQL and how to run it effectively on Kubernetes. The talk will be developer-centric and will start with the basics of connecting to Cloud SQL from Kubernetes. It will include how to run load tests and then size an instance. And, it will end with how to enable connection pooling to get the most out of Cloud SQL while having some fun along the way.
We hope you’ll join us for the sessions and Q&A to learn about these topics and technologies in more detail. The speakers will be available in Q&A chat during the event. The Google community track sessions take place on May 13, but be sure to check out the entire schedule and register today!
