A Beginner's Guide to Database Sharding: How to Scale Your Database Effectively
As businesses grow, so do their data needs. A small application that once handled a few users can quickly evolve into a system that supports thousands—or even m
As businesses grow, so do their data needs. A small application that once handled a few users can quickly evolve into a system that supports thousands—or even m
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
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
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
Showing 21–40 of 61 posts