EmergencyEMERGENCY? Get 24/7 Help Now!

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

Consul Architecture

 | October 10, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

consul

In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

Read More

Consul, ProxySQL and MySQL HA

 | September 16, 2016 |  Posted In: MySQL

ProxySQL

When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load Balancing?” “Should I be deploying this proxy tool on my application servers or on a […]

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

MySQL Sharding with ProxySQL

 | August 30, 2016 |  Posted In: MySQL

MySQL Sharding with ProxySQL

This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s sharding functionalities, and help people out there better understand how to use it. ProxySQL is […]

Read More

How to stop offending queries with ProxySQL

 | August 23, 2016 |  Posted In: MySQL, ProxySQL

This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! 😉 But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie, who just joined the company […]

Read More

Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes

 | June 16, 2016 |  Posted In: MySQL

wsrep-stages

How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes? In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment. There are already some existing posts from Patrick Galbraith […]

Read More

ProxySQL versus MaxScale for OLTP RO workloads

 | May 12, 2016 |  Posted In: MySQL

ProxySQL versus MaxScale for OLTP RO workloads

In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads. Continuing my series of READ-ONLY benchmarks (you can find the other posts here: https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster), in this post I want to see how much overhead a proxy adds. At this In my opinion, there are only two solid proxy software options for MySQL […]

Read More