Buy Percona ServicesBuy Now!

Webinar Wednesday, April 18, 2018: Percona XtraDB Cluster 5.7 Tutorial

 | April 17, 2018 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Percona XtraDB Cluster Tutorial

Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Never used Percona XtraDB Cluster before? Come join this 45-minute tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster. In this […]

Read More

Plot MySQL Data in Real Time Using Percona Monitoring and Management (PMM)

 | April 2, 2018 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM

Plot MySQL Data in Real Time

In this blog post, we’ll show that you can plot MySQL data in real time using Percona Monitoring and Management (PMM). In my previous blog post, I showed how we could load into any metrics, benchmarks into MySQL and visualize it with PMM. But that’s not all! We can even visualize most any kind of […]

Read More

How to Speed Up Pattern Matching Queries

 | March 19, 2018 |  Posted In: Insight for DBAs, MySQL

pattern matching queries

From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]

Read More

Verifying Query Performance Using ProxySQL

 | March 15, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management, ProxySQL

Query Performance Using ProxySQL

In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]

Read More

Great Metrics Graphs: Percona Monitoring and Management vs. gnuplot

 | February 28, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

Percona Monitoring and Management vs. gnuplot

In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read. Percona Monitoring and Management (PMM) is our free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance, and is […]

Read More

SSL Connections in MySQL 5.7

 | June 27, 2017 |  Posted In: MySQL, Security, SSL

SSL Connections

This blog post looks at SSL connections and how they work in MySQL 5.7. Recently I was working on an SSL implementation with MySQL 5.7, and I made some interesting discoveries. I realized I could connect to the MySQL server without specifying the SSL keys on the client side, and the connection is still secured […]

Read More

ProxySQL Rules: Do I Have Too Many?

 | April 10, 2017 |  Posted In: Benchmarks, MySQL, ProxySQL

In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL is heavily based […]

Read More