We’re counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks. Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry.
10. InnoDB Management and Scalability Improvements in MySQL 8.0 – Sunny Bains (Oracle)
Sunny Bains (Oracle) discusses improvements in MySQL 8 like scalability and InnoDB Management. Oracle’s MySQL 8.0 is a major release of new features and capabilities, including a new data dictionary, hosted in InnoDB, new REDO logs design, new UNDO logs, a new scheduler, descending indexes, and much more! Learn all about the changes in InnoDB delivered with MySQL 8.0 and how they affect the performance and the manageability of your database!
9. MySQL Group Replication: The Magic Explained v2 – Frédéric Descamps (Oracle)
Frédéric Descamps (Oracle) explains how MySQL Group Replication replication works. This is a theoretical talk in which he explains in detail what replication is and how it works, what certification is and how it’s done. Also, what is XCOM and GCS.
8. Using Ansible to Manage MySQL at DigitalOcean – Ben Mildren, Andrew Moore, & Dan Kowalewski (DigitalOcean)
Ben Mildren, Andrew Moore, & Dan Kowalewski (DigitalOcean) discuss how they use Ansible to manage the internal MySQL services at DigitalOcean, where this has worked well for them, as well as some of the issues they have experienced along the way. They’ll dive into how we use Ansible to manage MySQL, ProxySQL & Orchestrator and other related technologies in their environment and discuss topics such as static vs dynamic config management, Ansible performance tuning & anti-patterns, as well as testing strategies.
7. From Scheduled Downtime to Self-Healing in Less Than a Year – Karoly Nagy (Salesforce)
Karoly Nagy (Salesforce) discusses scheduled downtime to self-healing and how you can achieve this in less than a year. Infrastructure automation is not easy, especially for stateful services like MySQL (or any other database for that matter). It goes way beyond the capabilities of Ansible, Chef, SaltStack or other similar tools. In this session, Karoly will show you how he went from fully manual operations to a self-healing system in less than a year at Salesforce.
6. New Features in ProxySQL 2.0 – René Cannaò & Nick Vyzas (ProxySQL)
René Cannaò & Nick Vyzas (ProxySQL) discuss new features in ProxySQL 2.0. ProxySQL, the high performance, high availability, protocol-aware proxy for MySQL is now GA in version 2.0. This version introduces several new features, like causal reads using GTID, better support for AWS Aurora, native support for Galera Cluster, LDAP authentication and SSL for client connections.
5. Vitess: Running Sharded MySQL on Kubernetes – Sugu Sougoumarane & Dan Kozlowski (PlanetScale)
Sugu Sougoumarane & Dan Kozlowski (PlanetScale) discuss how to shard MySQL on Kubernetes in Vitess. Vitess has continued to evolve into a massively scalable sharded solution for the cloud. It’s is now used for storing core business data for companies like Slack, Square, JD.com, and many others. This session will cover the high-level features of Vitess with a focus on what makes it cloud-native.
4. Databases at Scale, at Square – Emily Slocombe (Square)
Emily Slocombe (Square) discusses databases at scale. At Square, they operate thousands of database instances to power a financial network, from payments to payroll. In a word: money. “Mission-critical” isn’t critical enough. Come learn how they operate MySQL and Redis with billions of dollars at stake. They’ll look at everything: configuration, management, monitoring, tooling, security, high-availability, replication and more.
3. MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management – Peter Zaitsev (Percona)
Peter Zaitsev (Percona) will discuss how you can optimize and troubleshoot MySQL performance and demonstrate how Percona Monitoring and Management (PMM) enables you to solve these challenges using free and open source software. We will look at specific, common MySQL problems and review the essential components in PMM that allow you to diagnose and resolve them.
2. New Features in MySQL 8.0 Replication – Luís Soares (Oracle)
Luís Soares (Oracle) highlights the new replication features in MySQL 8.0. Those that were released pre and post-GA. Come and learn, directly from the engineers, how the new features help you operate, sustain, and extend your MySQL Replication infrastructure.
1. The MySQL Query Optimizer Explained Through Optimizer Trace – Øystein Grøvlen (Alibaba Cloud)
Øystein Grøvlen (Alibaba Cloud) introduces you to the inner workings of the MySQL Query Optimizer by showing you examples with Optimizer Trace. Øystein will cover the main phases of the MySQL optimizer and its optimization strategies, including query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization. They will also show how optimizer trace gives you insight into the cost model and how the optimizer does cost estimations.
Thanks to all sponsors, presenters, and attendees for a successful Percona Live Open Source Database Conference 2019! Percona Live Europe 2019 is coming up next, taking place in Amsterdam, Netherlands from September 30 to October 2, 2019. The Call for Papers is now open, and we invite you to submit your speaking proposal for breakouts, tutorials, or lightning talks at any level of expertise, from beginner to expert.