Latest Updates

News, technical articles, and announcements from the ProxySQL team.

Benchmarking ProxySQL 1.4.4
January 3, 2018 Tech

Benchmarking ProxySQL 1.4.4

Comparing ProxySQL 1.4.3 vs. 1.4.4 ProxySQL 1.4.4 has recently been released (GA on Dec 20, 2017) which naturally leads to the question “What performance gains

#benchmark #benchmarking #high-performance #sysbench

by Nick Vyzas

Read more
Native ProxySQL Clustering now available
September 8, 2017 Tech

Native ProxySQL Clustering now available

ProxySQL 1.4.2 now supports Native Clustering!!! ProxySQL enters the club of the software associated with the buzz word "Cluster". This blog post is the first

#cluster #high-availability

by Nick Vyzas

Read more
How to run multiple ProxySQL instances
August 1, 2017 Tech

How to run multiple ProxySQL instances

How to run multiple ProxySQL instances Some time ago I wrote about the ability of running multiple ProxySQL instances listening on the same port(s). This capa

#proxysql #upgrade

by Nick Vyzas

Read more
Scaling with ProxySQL Query Cache
May 28, 2017 Tech

Scaling with ProxySQL Query Cache

MySQL Query Cache Before writing about ProxySQL Query Cache, let's see what MySQL Query Cache is. MySQL Query Cache is a very interesting feature that, quot

#caching #scalability #high-performance

by Nick Vyzas

Read more
On demand query routing - how to prevent downtime on your main MySQL server
April 17, 2017 Tech

On demand query routing - how to prevent downtime on your main MySQL server

In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers: start sending all traffic to MySQL master identify what queries can be routed to the MySQL

#routing #query #traffic

by Nick Vyzas

Read more
Obfuscate data from mysqldump with ProxySQL
April 16, 2017 Tech

Obfuscate data from mysqldump with ProxySQL

While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to ob

#mysqldump #obfuscate #datamasking #security

by Nick Vyzas

Read more
MySQL read/write split with ProxySQL
April 13, 2017 Tech

MySQL read/write split with ProxySQL

Query routing is one of the core features of ProxySQL. Read/write split is perhaps one of the most common query routing use, while the other most commonly used

#routing #read #write #split #mysql

by Nick Vyzas

Read more
Multiple ProxySQL instances on same ports, and seamless upgrade
March 19, 2017 Tech

Multiple ProxySQL instances on same ports, and seamless upgrade

Since its genesis ProxySQL was designed to be reconfigurable at runtime without restarting it. There are only 2 exceptions: changing the listening ports (work i

#proxysql #upgrade

by Nick Vyzas

Read more
Comparing Query Cache in ProxySQL and MaxScale
February 22, 2017 Tech

Comparing Query Cache in ProxySQL and MaxScale

Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the new Query Performance capabilities there is Query Cache Filter. Query Cache was among the very

#caching #maxscale #compare

by Nick Vyzas

Read more
ProxySQL and MaxScale on point select workload
February 21, 2017 Tech

ProxySQL and MaxScale on point select workload

Few days ago MariaDB announced that MaxScale 2.1 is roughly 45% faster than MaxScale 2.0 . I first want to congratulate MaxScale Team: MaxScale 2.1 seems to

#benchmark #benchmarking #sysbench #maxscale

by Nick Vyzas

Read more
Conociendo ProxySQL
February 19, 2017 Tech

Conociendo ProxySQL

Last month, January 2017, two DevOps meetups were organized in Spain with the same topic: "Conociendo ProxySQL", presented by txetxu Velayos, @txetxuvel The

#proxysql

by Nick Vyzas

Read more
Releasing ProxySQL 1.3.4
February 18, 2017 Release

Releasing ProxySQL 1.3.4

I am happy to announce the release of the latest stable release of ProxySQL 1.3.4 on 18 February 2017. ProxySQL is a high performance, high availability, pro

#release #proxysql

by Nick Vyzas

Read more
Testing performance of MySQL Group Replication
February 2, 2017 Tech

Testing performance of MySQL Group Replication

MySQL Group Replication is a hot topic in MySQL ecosystem. We have been evaluating it in , and it is now time to evaluate its performance, especially now that i

#group-replication #benchmark #mysql

by Rene Cannao

Read more
Proxy Wars: comparing ProxySQL to others
January 7, 2017 Tech

Proxy Wars: comparing ProxySQL to others

MySQL load balancers and proxies are becoming a very hot topic in the last few years. In the near future there will two presentations to compare proxies: T

#proxy #compare #comparing #maxscale #haproxy #nginx

by Nick Vyzas

Read more
Galera Awareness and ProxySQL Scheduler
July 16, 2016 Tech

Galera Awareness and ProxySQL Scheduler

One of the most common requests for ProxySQL is to support Galera Cluster. The Issue Support for Galera requires a lot of features to be added to ProxySQL:

#galera #galera-cluster

by Nick Vyzas

Read more
Query rewrite with ProxySQL: use case scenario
June 18, 2016 Tech

Query rewrite with ProxySQL: use case scenario

One of ProxySQL most interesting features is query rewrite. This functionality is one of the main reasons to write a proxy that sits between the applicatio

#query-rewrite #query #routing

by Nick Vyzas

Read more
ProxySQL vs MaxScale: Persistent Connection, response time, and bugs
December 29, 2015 Tech

ProxySQL vs MaxScale: Persistent Connection, response time, and bugs

A benchmark comparison of ProxySQL and MaxScale focusing on persistent connections, throughput, response time, and critical session-tracking bugs in MaxScale's implementation.

#maxscale #compare #comparing #benchmark

by Nick Vyzas

Read more

Showing 101–117 of 117 posts