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
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
Showing 21–40 of 58 posts