Buy Percona ServicesBuy Now!

What About ProxySQL and Mirroring?

 | May 25, 2017 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, ProxySQL, Replication

ProxySQL and Mirroring

In this blog post, we’ll look at how ProxySQL and mirroring go together. Overview Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling […]

Read More

Percona XtraDB Cluster 5.6.35-26.20-3 is now available

 | April 19, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20-3 on April 13, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.35-26.20-3 is now the current release, based on the following: Percona Server 5.6.35-81.0 Galera Replication library 3.20 wsrep API version 26 All Percona software is open-source and free. NOTE: Due […]

Read More

Percona XtraDB Cluster 5.7.17-29.20 is now available

 | April 19, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.17-29.20 on April 19, 2017. Binaries are available from the downloads section or our software repositories. NOTE: You can also run Docker containers from the images in the Docker Hub repository. Percona XtraDB Cluster 5.7.17-29.20 is now the current release, based on the following: Percona Server 5.7.17-13 Galera […]

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

Percona Live Featured Tutorial with Derek Downey, David Turner and René Cannaò — ProxySQL Tutorial

 | February 3, 2017 |  Posted In: MySQL

Percona Live

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

ProxySQL Admin Configuration

and  | January 25, 2017 |  Posted In: Percona Software, Percona XtraDB Cluster, ProxySQL

ProxySQL Admin

ProxySQL Admin (proxysql-admin) is a powerful tool for configuring Percona XtraDB Cluster nodes into ProxySQL. The proxysql-admin tool comes with the ProxySQL package from Percona apt/yum repositories. ProxySQL 1.3.2-1 is now available from the Percona repositories. This release is based on ProxySQL v1.3.2a and introduces the following new changes: proxysql-admin_v1.3.2a.md. Installing on Red Hat or CentOS […]

Read More

Setup ProxySQL for High Availability (not a Single Point of Failure)

 | January 19, 2017 |  Posted In: High-availability, Keepalived, MySQL, open source databases, OpenSource Databases on big machines, Percona Live, Percona MySQL Consulting, Percona Software, Percona XtraDB Cluster, ProxySQL

ProxySQL for High Availability

In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting MySQL: ProxySQL. ProxySQL is becoming more flexible, solid, performant and used […]

Read More

Percona XtraDB Cluster 5.7.16-27.19 is now available

 | December 15, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.16-27.19 on December 15, 2016. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.16-27.19 is now the current release, based on the following: Percona Server 5.7.16-10 Galera Replication library 3.19 wsrep API version 26 All Percona software is open-source and free. […]

Read More

Orchestrator and ProxySQL

 | November 9, 2016 |  Posted In: MySQL, Orchestrator, ProxySQL

Orchestrator and ProxySQL

In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not, you can find the installation steps here. In the case of […]

Read More