Are you tired of MySQL bottlenecks slowing down your application? Then, it's time your organization uses a database proxy. ProxySQL is a high-performance op
The internet surrounds us in today’s digital world, so much so that not a single task is complete without a simple Google search. We lean on the internet for va
Introduction Admin credentials serve as the gateway to ProxySQL's configuration, granting users unparalleled control over its functionalities. However, the imp
In the realm of database management, optimizing performance is paramount to ensuring smooth operations and preventing potential disruptions. One tool that has e
Enhancing Database Security with ProxySQL 2.6.0: Introducing caching_sha2_password Authentication In the digital age, where data breaches are increasingly comm
Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And ho
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!
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
cat < proxysql.cnf ################################################################################ #
This post is the first of a series of blogposts on how to easily use ProxySQL to scale-out your application's database workload on a Galera cluster. This series
ProxySQL Firewall Overview ProxySQL's flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This
A selection of the companies we have helped scale
The latest enhancement in ProxySQL v2.0.0 is the native support of Galera Cluster. No more need to use an external script within the scheduler like explained al
One of the more popular solutions for a DBaaS in today's market is Amazon's RDS / Aurora service. Historically Amazon RDS was quite popular however Aurora has b
This topic has been up in the air for a long time. What would be the best approach: get less large boxes or smaller for the same price? What would be pros and c
MySQL, ProxySQL & SSL As we all know, MySQL supports using SSL to secure connections by encrypting the data in transit and protecting it from snooping on the w
ClickHouse and MySQL do not have the same SQL syntax and functions ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQ
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
ProxySQL's new routing algorithm to handle hundreds of thousands of schemas/shards ProxySQL is a service designed to scale and handle traffic in very large setups. In the past we already showed examples of how ProxySQL can handle thousands of MySQL servers, and millions (yes, millions!) of distinct...
Comparing ProxySQL 1.4.3 vs. 1.4.4 ProxySQL 1.4.4 has recently been released (GA on Dec 20, 2017) which naturally leads to the question “What performance gains
Showing 21–40 of 55 posts