Vlad Fedorkov

Performance consulting for MySQL and Sphinx

One, two, three, MySQLers… OOW 2019, Percona Live, ProxySQL Tech Day!

As people are getting back from vacations and application traffic is going back and hitting database backend hard, it is a good time to think about performance and prepare for the winter holiday spike. Whenever you are on-premise or in the cloud, questions are the same:

  • Are we satisfied with the current MySQL performance?
  • How much traffic are we currently serving?
  • Is there enough capacity to stay stable as traffic increases?
  • What would be the best way to stay cost-effective as we grow?

Unfortunately, the answers are not so obvious and require a thorough performance analysis. However, there is a chance that your problem has already been solved by someone else. I do not mean StackOverflow (which is a beautiful place, by the way), but some higher level questions which people usually discuss at conferences, and we have several of them ongoing or just a couple of weeks away.

Right this moment René Cannào and Peter Boros are preparing to deliver their talk MySQL with ProxySQL at Zuora at Oracle Open World conference, 09:00 AM @ Room 301, Moscone South.

At the same time next door in the Room 312 Oracle’ Frederic Descamps will be talking about MySQL Shell for DBAs.

If you are a developer, than you probably won’t miss Seventeen Things Developers Need to Know About MySQL by Peter Zaitsev 11:15 AM @ Room 3.

But that’s California, and what if you’re in Europe? Please hold on, we’re crossing the Atlantic!

Let’s move to Amsterdam where you might want to attend Percona Live Europe held from September 30th to October 2nd. As you land, you will not even need a taxi to get there as your venue is next to the airport! Besides useful tutorials on the first day, there will be two complete days filled with Database Wisdom. Perconians and their guests will share virtually every aspect of the database performance and operations.

Here is a list of my favorite talks from day one @ Percona Live:

  • MyRocks and RocksDB Advanced Features and Performance by Yoshinori Matsunobu (2:30 PM),
  • ClickHouse Features to Blow Your Mind by  Aleksei Milovidov (6:00 PM),
  • Tracing and Profiling MySQL by Valerii Kravchuk (same 6:00 PM).

The next day is also full of great talks, here’re just some examples:

  • Sveta Smirnova helps you to save life with Histograms (9:00 AM),
  • Marco Tusa will make a deep dive into Using ProxySQL as Firewall (10:00 AM),
  • Morgan Tocker will share his First 90 days experience with Vitess (11:00 AM).
  • And if you are looking for real hardcore stuff, please visit gdb basics for MySQL DBAs  by Valerii Kravchuk (3:30 PM).

That’s a really intense line-up for three days, but that’s not the end, here comes the ProxySQL Tech Day!

Right after Percona Live, on Thursday Oct 3rd, we are going to meet in person at a free event in Ghent, Belgium. We’ll be talking specifically about large-scale MySQL environments and how to serve a really huge amount of transactions with MySQL. Experts from 5 different companies will gather at Co.Station Gent and share their knowledge. Tricky questions, mind-breaking cases, crazy requirements and challenges of all kinds are super welcome! Please use this form and be sure that we’ll tackle your issue.

We’re starting at 5:00 PM, so you will have some time for a walk across the nice City of Ghent!

P.S. The views expressed here are my own and do not necessarily reflect the opinion of my employer.

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 ;)