← All posts

#mysql

12 posts

Making MySQL AI-Ready: How MyVector and ProxySQL Work Together
February 11, 2026 Recap Tech

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.

#myvector #genai #rag #mysql
Read more
Bringing GenAI to Every MySQL Instance: ProxySQL v4.0
February 8, 2026 Recap Tech

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.

#genai #mcp #mysql #proxysql #rag
Read more
January 20, 2026 Release

ProxySQL 3.0.5: Security hardening, protocol fixes, and smoother operations

We’re excited to announce ProxySQL 3.0.5, our first release of 2026. As always, thank you to everyone who tested, reported issues, sent patches, and shar

#release #proxysql #postgresql #mysql
Read more
MySQL High Availability: Techniques to Ensure Uptime in Critical Systems
December 4, 2024 Tech

MySQL High Availability: Techniques to Ensure Uptime in Critical Systems

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

#high-availability #mysql #failover
Read more
Database Security: Best Practices to Protect Your MySQL Infrastructure
November 20, 2024 Tech

Database Security: Best Practices to Protect Your MySQL Infrastructure

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

#security #mysql
Read more
Top 10 Ways to Optimize MySQL Performance with ProxySQL
September 18, 2024 Tech

Top 10 Ways to Optimize MySQL Performance with ProxySQL

MySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging.  Thankfully

#high-performance #mysql
Read more
March 26, 2024 Tech

Enhancing Database Security with ProxySQL 2.6.0: caching_sha2_password

Enhancing Database Security with ProxySQL 2.6.0: Introducing caching_sha2_password Authentication In the digital age, where data breaches are increasingly comm

#security #mysql #proxysql
Read more
Unadventurous Amazon RDS Upgrades with ProxySQL
February 4, 2021 Tech

Unadventurous Amazon RDS Upgrades with ProxySQL

If you're still running RDS 5.5 you have reached the end of the line, its time to upgrade... heck, if you're running RDS 5.6 an upgrade is just as mandatory!

#rds #amazon-aurora #upgrade #mysql
Read more
February 1, 2021 Tech

How MySQL Bug #102266 affects ProxySQL

Overview If you are using ProxySQL 2.0.16 in front of MySQL 5.7/5.6 servers or even in front of MySQL 8.0.0, please check your ProxySQL error logs for the message below to ensure that you are not experiencing the MySQL bug #102266: 2021-06-23 02:38:18 MySQL_Session.cpp:2798:handler_again___status_CHANGING_USER_SERVER(): Error during change user: 1045, Access denied for user 'mary'@'172.21 If

#102266 #mysql-bug #mysql
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
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
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
Read more