ProxySQL Technology Day in Ghent, Belgium
As a part of the ProxySQL team I am happy to announce my trip to Ghent to ProxySQL Technology Day. With great pleasure, I will join the experts from Oracle, Percona, and Pythian to talk about various things that ProxySQL can do for a user. We are going to meet at 5PM at Ghent’s Co.Station co-working on Thursday, October 3rd to walk through key features that ProxySQL is adding to MySQL ecosystem. Join me and others for five talks and a round table about building MySQL infrastructure to serve hundreds of thousands of queries per second.
What am I going to talk about?
In my 30 minutes “Introduction to High Performance for MySQL” talk at 5PM, I’m going to walk through the needs of today’s high-performance setups. These days you can’t just be a DBA, looking after your MySQL server. You have to work closely with development teams to prepare new code to work with production-sized datasets, deal with potential load spikes and be able to fix certain things on the fly without even changing the code. In this case, ProxySQL is acting as a bridge between application and database backend and so adding required flexibility.
In my second talk “ProxySQL: Traffic management and Performance Troubleshooting” at 6:10 PM I’m going to dive into details of MySQL traffic management and metrics that ProxySQL provides to identify bottlenecks and time-consuming queries. I’ll show you some real-life use cases like read/write split, query-based and user-based query routing and some advanced techniques for high loaded environments.
What else are we going to discuss?
- Fault-tolerant infrastructure with ProxySQL: MySQL InnoDB Cluster, PXC, Orchestrator, etc
- Load balancing and advanced MySQL traffic management
- Application troubleshooting: real-time queries and connection pool statistics