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.
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.
First blog post of a series about ProxySQL for PostgreSQL and how it handles failover
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
ProxySQL 3.0.7 adds native zstd compression for the MySQL protocol, offering better compression ratios and lower CPU overhead compared to zlib.
A preview of the features we're shipping — from InnoDB Cluster to PostgreSQL support. This is just the beginning.
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.
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.
In this guide, we will walk you through the process of decrypting SSL/TLS traffic to and from ProxySQL using Wireshark. By enabling the SSLKEYLOG feature in Pro
This blogpost dives into the latest advancements in ProxySQL's monitoring capabilities, specifically about the recently added monitoring support for PostgreSQL,
Businesses often turn to caching solutions to improve database performance. It speeds up read and write operations by storing frequently accessed data in memory
High-traffic databases present significant challenges, especially when managing and optimizing performance across large, distributed environments. According to
When was the last time your database experienced an unexpected failover? If it was seamless, consider yourself lucky, as most organizations struggle with signif
As cloud applications grow in scale and complexity, multi-tenant architecture has become essential for organizations prioritizing cost efficiency, scalability,
Optimizing database interactions is critical to maintaining operational efficiency. According to Gartner, the global Database Management Systems (DBMS) market i
As businesses grow, so do their data needs. A small application that once handled a few users can quickly evolve into a system that supports thousands—or even m
A single hour of downtime costs companies an average of $300,000, with critical systems like databases bearing the brunt of this risk. MySQL, widely used for ma
As of 2024, MySQL ranks as the second most popular database management system globally. MySQL has become a go-to choice for database management due to its de
The efficiency of a company's database systems is not just an IT concern but a central business issue. Slow databases can drag down the entire user experience,
Are you facing challenges managing your MySQL database as user traffic increases? As more users and applications connect, performance can slow down, leading to
MySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging. Thankfully
Showing 1–20 of 55 posts