← All posts

Tech

61 posts

A Beginner's Guide to Database Sharding: How to Scale Your Database Effectively
December 30, 2024

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

Read more
MySQL High Availability: Techniques to Ensure Uptime in Critical Systems
December 4, 2024

MySQL High Availability: Techniques to Ensure Uptime in Critical Systems

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

Read more
Database Security: Best Practices to Protect Your MySQL Infrastructure
November 20, 2024

Database Security: Best Practices to Protect Your MySQL Infrastructure

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

Read more
How Companies Can Improve Database Performance with ProxySQL
November 20, 2024

How Companies Can Improve Database Performance with ProxySQL

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,

Read more
Advanced ProxySQL Features and How to Leverage Them
October 11, 2024

Advanced ProxySQL Features and How to Leverage Them

Are you facing challenges managing your MySQL database as user traffic increases? As more users and applications connect, performance can slow down, leading to

Read more
Top 10 Ways to Optimize MySQL Performance with ProxySQL
September 18, 2024

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

Read more
Understanding ProxySQL: The Ultimate Database Proxy Solution
September 16, 2024

Understanding ProxySQL: The Ultimate Database Proxy Solution

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

Read more
The Ultimate Guide to Database Proxies: What They Are and Why You Need One
August 25, 2024

The Ultimate Guide to Database Proxies: What They Are and Why You Need One

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

Read more
May 6, 2024

Managing ProxySQL Admin Credentials: A Guide to admin-admin_credentials

Introduction Admin credentials serve as the gateway to ProxySQL's configuration, granting users unparalleled control over its functionalities. However, the imp

Read more
May 3, 2024

Optimizing Database Performance with ProxySQL Query Rewrite

In the realm of database management, optimizing performance is paramount to ensuring smooth operations and preventing potential disruptions. One tool that has e

Read more
March 26, 2024

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

Read more
Failover comparison in Aurora MySQL 2.10.0 using proxySQL vs Aurora's cluster endpoint
January 4, 2022

Failover comparison in Aurora MySQL 2.10.0 using proxySQL vs Aurora's cluster endpoint

Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And ho

Read more
Unadventurous Amazon RDS Upgrades with ProxySQL
February 4, 2021

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!

Read more
February 1, 2021

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

Read more
Observability Enhancements in ProxySQL 2.1 with Prometheus & Grafana
January 19, 2021

Observability Enhancements in ProxySQL 2.1 with Prometheus & Grafana

cat < proxysql.cnf ################################################################################ #

Read more
Effortlessly Scaling out Galera Cluster with ProxySQL
September 23, 2020

Effortlessly Scaling out Galera Cluster with ProxySQL

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

Read more
Protect your data using ProxySQL Firewall
July 9, 2020

Protect your data using ProxySQL Firewall

ProxySQL Firewall Overview ProxySQL's flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This

Read more
Architecting MySQL for Scale with ProxySQL
April 6, 2020

Architecting MySQL for Scale with ProxySQL

A selection of the companies we have helped scale

Read more
Native Galera Support In ProxySQL
March 2, 2019

Native Galera Support In ProxySQL

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

Read more
Amazon Aurora - Seamless Planned Failover with ProxySQL
September 10, 2018

Amazon Aurora - Seamless Planned Failover with ProxySQL

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

Read more

Showing 21–40 of 61 posts