December 2, 2023
São Paulo, Brazil
Join us in São Paulo on MySQL Meetup on December 2nd. It is a free database event that Oracle co-organize with Percona.
We will have a full day of talks on the most diverse topics about MySQL, ranging from open source tools to the Oracle cloud, and networking. And at the end of the day, all attendees will be able to visit the Oracle data center.
Speakers from Percona will present the following talks:
- ProxySQL on MySQL: Just a load balancer? by Roberto Garcia de Bem (Support Engineer, Percona)
ProxySQL is an open source proxy designed for MySQL, capable of communicating through the MySQL protocol, most often used as a load balancer. In addition to its functionalities as a load balancer, ProxySQL offers a large number of features (Multiplexing, Query Rules, Query Rewriting, Failover detection, ProxySQL Cluster, among others) that can be of great use in our daily activities. During the presentation, we will show some of its capabilities and potential uses, exploring its architecture and configuration layers. Furthermore, Roberto will demonstrate the installation and configuration process in different possible architectures (Simple Replica, PXC/Galera, Group Replication).
- Tools and methods for performance analysis in MySQL by Leonardo Bacchi Fernandes (Senior Support Engineer, Percona)
In this presentation, we will discuss where to start and what we have at our disposal to carry out a performance analysis in MySQL. Using real cases as a basis, we will review some key Linux commands (vmstat, iostat, top, etc.) and how to use resources in the operating system directs our analysis of the database. We will see some commands and tools that MySQL has for analysis (SHOW PROCESSLIST, SHOW ENGINE INNODB STATUS, mysqladmin, pt-stalk, slow query log, etc.), and when to use them. Finally, we will discuss some more advanced tools that we can use for complex problems, when MySQL commands are not enough to understand the problem (perf, flamegraphs, pt-pmp, coredumps).
Register here to save your spot! The attendance is free for everyone.
