← All posts

#mysql

27 posts

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

Showing 21–27 of 27 posts