Vlad Fedorkov

Performance consulting for MySQL and Sphinx

ProxySQL team is coming to Ghent with the Technology Day

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

Hey! Just in case you forgot, ProxySQL and it’s creator René Cannaò are three times in a row MySQL Community Awards winners, so you know it will be worth spending the evening ;)

Sphinx events in New York City this fall

For some of you who situated near New York City I am happy to announce that you could attend two events related to leading Full-Text search engines in open source – Sphinx Search.

First meeting organized by NYPHP meetup on Tuesday, September 25th at IBM, 590 Madison Avenue, New York. I’ll be speaking about search services in cloud environment and distributed search tips and tricks. Event is free, please RSVP.

One week later on October 1st, I’ll be doing tutorial about MySQL and Sphinx “Full-text based services with Sphinx and MySQL” at greatest MySQL event in East Cost, Percona Live NY. Use “FlashSale” code to get exceptional 25% discount (valid until Sept 23rd).

Looking forward to meet you in New York City!