Latest Updates

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

Releasing ProxySQL 2.0.8
November 5, 2019 Release

Releasing ProxySQL 2.0.8

Proudly announcing the release of the latest stable version of ProxySQL 2.0.8 on 5th of November 2019. ProxySQL is a high performance, high availability, pro

#release #proxysql
Read more
Releasing ProxySQL 2.0.7
October 2, 2019 Release

Releasing ProxySQL 2.0.7

Proudly announcing the release of the latest stable version of ProxySQL 2.0.7 on 2nd of October 2019. ProxySQL is a high performance, high availability, prot

#release #proxysql
Read more
ProxySQL Technology Day
August 27, 2019 Event

ProxySQL Technology Day

ProxySQL Technology Day at Ghent, Belgium on Thursday, October 3rd, 2019 We are proud to announce our inaugural free ProxySQL Technology Day held in Ghent, Bel

#proxysql-technology-day #ghent #belgium #events
Read more
Native Galera Support In ProxySQL
March 2, 2019 Tech

Native Galera Support In ProxySQL

The latest enhancement in ProxySQL v2.0.0 is the native support of Galera Cluster. No more need to use an external script within the scheduler like explained al

#galera #galera-cluster #high-availability
Read more
Amazon Aurora - Seamless Planned Failover with ProxySQL
September 10, 2018 Tech

Amazon Aurora - Seamless Planned Failover with ProxySQL

One of the more popular solutions for a DBaaS in today's market is Amazon's RDS / Aurora service. Historically Amazon RDS was quite popular however Aurora has b

#amazon-aurora #aurora #failover #high-availability
Read more
Scaling from a Dark Ages of Big Data to Brighter Today
August 29, 2018 Tech

Scaling from a Dark Ages of Big Data to Brighter Today

This topic has been up in the air for a long time. What would be the best approach: get less large boxes or smaller for the same price? What would be pros and c

#scalability #proxysql
Read more
SSL Encryption at ProxySQL Part 1
August 20, 2018 Tech

SSL Encryption at ProxySQL Part 1

MySQL, ProxySQL & SSL As we all know, MySQL supports using SSL to secure connections by encrypting the data in transit and protecting it from snooping on the w

#ssl #encryption #security
Read more
ClickHouse and ProxySQL queries rewrite
March 31, 2018 Tech

ClickHouse and ProxySQL queries rewrite

ClickHouse and MySQL do not have the same SQL syntax and functions ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQ

#clickhouse #query-rewrite #query
Read more
GTID consistent reads
March 21, 2018 Tech

GTID consistent reads

Adaptive query routing based on GTID tracking ProxySQL is a layer 7 database proxy that understands the MySQL Protocol. It provides high availability and high

#gtid #causal-consistency-reads #mysql
Read more
March 20, 2018 Tech

ProxySQL Fast Routing

ProxySQL's new routing algorithm to handle hundreds of thousands of schemas/shards ProxySQL is a service designed to scale and handle traffic in very large setups. In the past we already showed examples of how ProxySQL can handle thousands of MySQL servers, and millions (yes, millions!) of distinct...

#routing #algorithm #schemas
Read more
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
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
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
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
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
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
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
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
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
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
Read more

Showing 81–100 of 107 posts