Tech

68 posts

September 30, 2026

MySQL BR Conf 2026 Slides: Managed ProxySQL in Your Own AWS Account

The final slides from René Cannaò and Alkin Tezuysal's session on ProxySQL.Cloud, BYOC architecture, configuration, and day-to-day operations.

September 30, 2026

Nerdearla 2026 Slides: SQL Traffic Routing Without Breaking Consistency

Connection pooling, replica freshness, MySQL GTID routing, and the application contracts behind safe SQL traffic routing.

September 29, 2026

dbdeployer v2.4.2: Faster MariaDB Sandboxes, Better Cluster Checks, and Five Months of Progress

dbdeployer v2.4.2 fixes MariaDB deployment delays and Galera/PXC readiness checks. Catch up on MariaDB downloads, PostgreSQL improvements, and testing since April.

June 4, 2026

PostgreSQL Replication Sandboxes with ProxySQL via dbdeployer

A step-by-step technical walkthrough to reproduce the Percona Live demo — provision a Linux VM on macOS, deploy PostgreSQL 16–18 sandboxes with dbdeployer, wire ProxySQL, run pgbench, and inspect proxy-side stats.

May 26, 2026

Part 4 - PgBouncer to ProxySQL: Extended and Prepared Protocols

Part 4 of the PgBouncer to ProxySQL series. Benchmarks ProxySQL and PgBouncer under PostgreSQL's extended and prepared query protocols. ProxySQL keeps the lead and widens it as worker threads increase.

May 22, 2026

Part 3 - PgBouncer to ProxySQL: Simple-Mode Benchmark

Benchmarking the PostgreSQL middle tier under SSL — PgBouncer vs ProxySQL (1/2/4 workers), same hardware, same 4KB SELECT workload. pgbench simple mode.

May 17, 2026

How ProxySQL 3.0.8 improves MySQL session-variable tracking

ProxySQL 3.0.8 extends session-variable tracking beyond parsed SET statements by consuming MySQL session-state notifications from backend OK packets.

April 29, 2026

Part 2 - PgBouncer to ProxySQL: A Brief Feature Comparison

Part 2 of the PgBouncer to ProxySQL series. A direct comparison of what each tool does, focused on responsibilities PgBouncer deliberately leaves alone and that ProxySQL pulls into the proxy itself. Reflects ProxySQL 3.0.8 and PgBouncer 1.25.1 at time of writing.

April 28, 2026

Part 1 - PgBouncer to ProxySQL: Rethinking the PostgreSQL Middle Tier

Part 1 of the PgBouncer to ProxySQL series. Focus: architecture and operator model, not a full feature matrix. Reflects ProxySQL 3.0.7 and PgBouncer 1.25.1 at time of writing.

April 25, 2026

New Observability Tables in ProxySQL 3.0.7: stats_proxysql_global and stats_tls_certificates

ProxySQL 3.0.7 introduces two new statistics tables for TLS certificate tracking and global proxy metrics.

April 24, 2026

Security Hardening in ProxySQL 3.0.7

A deep dive into the protocol hardening, credential protection, and validation improvements in ProxySQL 3.0.7.

April 22, 2026

Orchestrator for PostgreSQL: the HA brain, now first-party

How ProxySQL for PostgreSQL handles unplanned primary failure

April 21, 2026

ProxySQL for PostgreSQL — Surviving an unplanned primary failure

How ProxySQL for PostgreSQL handles unplanned primary failure

April 19, 2026

The Provider Architecture — How dbdeployer Learned to Speak PostgreSQL

A deep dive into the Provider interface that makes dbdeployer multi-database. How we abstracted MySQL, added PostgreSQL, and made it extensible for any database.

April 18, 2026

ProxySQL for PostgreSQL — the failover model

First blog post of a series about ProxySQL for PostgreSQL and how it handles failover

April 17, 2026

ProxySQL's prepared statement cache refactor, explained

A walk-through of the PostgreSQL prepared-statement cache refactor — what was slow, why, and how the redesign turned a contended path into a contention-free one

April 16, 2026

zstd Compression Support in ProxySQL 3.0.7

ProxySQL 3.0.7 adds native zstd compression for the MySQL protocol, offering better compression ratios and lower CPU overhead compared to zlib.

April 5, 2026

What's Coming to dbdeployer

A preview of the features we're shipping — from InnoDB Cluster to PostgreSQL support. This is just the beginning.

February 11, 2026

Making MySQL AI-Ready: How MyVector and ProxySQL Work Together

As AI workloads become standard in modern applications, engineering teams face a familiar dilemma: MySQL is already the system of record, but vector search typically requires bolting on a separate database. MyVector and ProxySQL solve this without fragmenting your data stack.

February 8, 2026

Bringing GenAI to Every MySQL Instance: ProxySQL v4.0

ProxySQL v4.0 adds a transparent AI layer at the proxy — RAG pipelines, NL2SQL, and an MCP server for AI agents — without touching your database or application code.

1 2 3 4 Next →

Showing 1–20 of 68 posts