Buy Percona ServicesBuy Now!

Leveraging ProxySQL with AWS Aurora to Improve Performance, Or How ProxySQL Out-performs Native Aurora Cluster Endpoints

 | April 3, 2018 |  Posted In: Amazon Aurora, Amazon RDS, MySQL, ProxySQL

ProxySQL with AWS Aurora

In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance. My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should do that. It is important to understand that aside from the basic optimization […]

Read More

ProxySQL Firewalling

 | January 15, 2018 |  Posted In: Database Monitoring, MySQL, ProxySQL, Security

ProxySQL Firewalling

In this blog post, we’ll look at ProxySQL firewalling (how to use ProxySQL as a firewall). Not long ago we had an internal discussion about security, and how to enforce a stricter set of rules to prevent malicious acts and block other undesired queries. ProxySQL came up as a possible tool that could help us in achieving […]

Read More

Group Replication: The Sweet and the Sour

 | August 1, 2017 |  Posted In: GTID, High-availability, InnoDB, MySQL, Percona XtraDB Cluster, PMM

Group Replication

In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.  Overview In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).  While I have extensively covered the first, my last serious work on […]

Read More

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

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

ProxySQL and Percona XtraDB Cluster (Galera) Integration

 | September 15, 2016 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, ProxySQL

In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers. ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it uses an event scheduler to extend functionalities and cover any special needs. Given that specialized products […]

Read More

ProxySQL and MHA Integration

 | September 13, 2016 |  Posted In: High-availability, MySQL, ProxySQL

MHA

This blog post discusses ProxySQL and MHA integration, and how they work together. MHA (Master High Availability Manager and tools for MySQL) is almost fully integrated with the ProxySQL process. This means you can count on the MHA standard feature to manage failover, and ProxySQL to manage the traffic and shift from one server to another. This […]

Read More