René Cannaò

Modern database infrastructure increasingly spans multiple database engines, deployment models, and operational environments. The ProxySQL ecosystem is evolving to address this broader landscape, bringing together database connectivity, traffic management, high availability, testing, and...

This presentation compares key tools in the PostgreSQL ecosystem that address database high availability, connection management, and load balancing — and shows how ProxySQL stacks up as a compelling alternative.

ProxySQL is a MySQL protocol aware, high-performance reverse proxy commonly used in MySQL compatible cloud databases. Thanks to these features, ProxySQL offers an extra layer of flexibility and control otherwise very challenging to achieve when designing and adapting your infrastructure to different workloads.

As a reverse proxy for MySQL databases, ProxySQL is being used in various infrastructure sizes, and it is not surprising to see deployments with thousands of nodes running. Such large deployments introduce some interesting challenges because nodes can be initialized or destroyed at any time.This...

As a reverse proxy for MySQL databases, ProxySQL is being used in various infrastructure sizes and it is not surprising to see deployments with thousands of nodes running. Such large deployments introduce some interesting challenges because nodes can be initialized or destroyed at any time.

There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL. In this tutorial we will not only explain how ProxySQL can make...

ProxySQL, the high performance, high availability, protocol-aware proxy for MySQL is now GA in version 2.0.This version introduces several new features, like causal reads using GTID, better support for AWS Aurora, native support for Galera Cluster, LDAP authentication and SSL for client connections.

Handling tens of thousands of database connections poses seriously performance issues on any database system because resources are poorly utilized. ProxySQL, a MySQL protocol aware, reverse proxy for database servers using the MySQL protocol, is able to track connections statuses and utilize very few connections to MySQL server to serve traffic from thousands of client connections.