Couldn’t make it to Austin this year for Percona Live? Don’t worry! We got you covered.
This year’s show included 80+ sessions by leading open source database experts alongside big names like Shopify, Hubspot, Venmo, Amazon, and Facebook. And every session is available right now, on demand.
Here are just a few of the sessions you can access right now.
Database Incident Management: When Everything Goes Wrong
Speaker: Joshua Varner, Shopify
When database systems go down, the consequences are usually severe. And who’s the last line of defense protecting a company’s data? Database professionals. During this talk, Joshua Varner of Shopify discusses incident management practices that can help any DBA/DRE work as a team through the toughest of issues – even when the pressure is high. Joshua shares important tips that span the various stages of an incident – detection, alerting, response, postmortem, and prevention – as well as the unique challenges database teams face as compared to other disciplines.
Migrating Facebook/Meta to MySQL 8.0
Speakers: Herman Lee and Pradeep Nayak, FaceBook/Meta
MySQL powers some of Facebook/Meta’s most important workloads. Because the Facebook/Meta team actively develops new features in MySQL to support their evolving requirements, migrating workloads to majors versions requires significant time and effort. Their upgrade to version 5.6 took more than a year, and moving to 5.7 would have been no faster, as they were in the middle of developing their MyRocks storage engine. By MySQL 8.0, they had finished MyRocks and were ready to take advantage of that version’s compelling new features, like atomic DDL support. Even so, the migration would come with some tough challenges. In this talk, Herman Lee and Pradeep Nayak share how Facebook/Meta tackled their 8.0 migration project and some of the surprises they discovered along the way.
Percona Monitoring and Measuring (PMM) For Novices
Speaker: Dave Stokes, Percona
The use of open source databases comes with huge benefits like greater innovation, lower costs, liberal licensing, data portability, and the ability to extend the code. But how can you effectively monitor and manage your databases in the face of increasing complexity? Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB. In this session, open source database expert Dave Stokes walks you through how to install PMM, how to register databases with it, and how to use it to simplify operations, optimize performance, and improve the security of your database services. Tune into this session to see how Dave starts at zero to make you a hero at monitoring your databases.
Simplifying the Top Complexities While Migrating From Oracle to PostgreSQL
Speaker: Avinash Vallarapu, MigOps
Migrating from Oracle to PostgreSQL is complex and can seem like a risky and daunting task. It doesn’t have to be. In this talk, Avinash Vallarapu shows you how to simplify some of the major complexities that may occur when moving from Oracle to PostgreSQL. Specifically, he discusses and demos:
- Converting sysdate from Oracle to PostgreSQL. Among a variety of options available in Postgres, which one is correct?
- Converting Hierarchical Queries from Oracle to PostgreSQL. Is Recursive CTE a correct alternative?
- Understanding Internals of the available solutions.
- Implementing Associative Arrays in PostgreSQL.
- Understanding the correct alternatives for Oracle Array Indexes and other complexities.
Big Data…Or Just Too Much Data?
Speaker: Marcos Albe, Percona
Has your multi-terabyte MySQL instance become unmanageable? Are reporting queries taking longer and longer? Do backup storage costs keep increasing? Do simple queries take seconds to run? In this talk, Marcos Albe discusses the practical limits of MySQL, how to tame your data, and what the alternatives to MySQL are.
The Future of Percona Products
Speaker: Donnie Berkholz, Percona
Percona has long been a leader in the global open source community. As we head into the future, we’re excited to unveil our plans to help even more companies harness the benefits of open source databases. In this session, Donnie Berkholtz shares the Percona product roadmap for the next few years and makes a major announcement about Percona Platform. Whether you’re already using Percona software or services or considering it, you don’t want to miss this session.
MySQL Parallel Replication: All the 5.7 and 8.0 Details 9 (LOGICAL_CLOCK)
Speaker: Jean-François Gagné, HubSpot
Parallel Replication is an effective feature for achieving faster replication and reducing lag. While MySQL implements Parallel Replication through LOGICAL_CLOCK, fully benefiting from this mechanism requires more than just enabling it. In this talk, Jean-François Gagné covers important things you need to know about MySQL 5.7 and 8.0 Parallel Replication. He explains in detail how LOGICAL_CLOCK works and provides expert advice on how to optimize Parallel Replication in MySQL. He also discusses changes made in MySQL 8.0, and back-ported in 5.7, that greatly improve the potential for parallel execution on replicas.
Deploying MongoDB Sharded Clusters Easily With Terraform and Ansible
Speaker : Ivan Groenewold, Percona
Installing big clusters can be a time-consuming task. In this talk, you’ll learn how to develop a complete pipeline to deploy MongoDB sharded clusters. By combining Terraform for the hardware provisioning and Ansible for the software installation, we can save time and provide a standardized reusable solution.
Sign up to see all Percona Live sessions
Learn from the best and brightest in the open source database industry. Watch these and other Percona Live 2022 sessions now.
