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
ProxySQL 1.4.2 now supports Native Clustering!!! ProxySQL enters the club of the software associated with the buzz word "Cluster". This blog post is the first
How to run multiple ProxySQL instances Some time ago I wrote about the ability of running multiple ProxySQL instances listening on the same port(s). This capa
MySQL Query Cache Before writing about ProxySQL Query Cache, let's see what MySQL Query Cache is. MySQL Query Cache is a very interesting feature that, quot
In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers: start sending all traffic to MySQL master identify what queries can be routed to the MySQL
While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to ob
Showing 21–40 of 50 posts