Tech

61 posts

August 29, 2018

Scaling from a Dark Ages of Big Data to Brighter Today

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

August 20, 2018

SSL Encryption at ProxySQL Part 1

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

March 31, 2018

ClickHouse and ProxySQL queries rewrite

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

March 21, 2018

GTID consistent reads

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

March 20, 2018

ProxySQL Fast Routing

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...

January 3, 2018

Benchmarking ProxySQL 1.4.4

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

September 8, 2017

Native ProxySQL Clustering now available

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

August 1, 2017

How to run multiple ProxySQL instances

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

May 28, 2017

Scaling with ProxySQL Query Cache

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

April 17, 2017

On demand query routing - how to prevent downtime on your main MySQL server

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

April 16, 2017

Obfuscate data from mysqldump with ProxySQL

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

April 13, 2017

MySQL read/write split with ProxySQL

Query routing is one of the core features of ProxySQL. Read/write split is perhaps one of the most common query routing use, while the other most commonly used

March 19, 2017

Multiple ProxySQL instances on same ports, and seamless upgrade

Since its genesis ProxySQL was designed to be reconfigurable at runtime without restarting it. There are only 2 exceptions: changing the listening ports (work i

February 22, 2017

Comparing Query Cache in ProxySQL and MaxScale

Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the new Query Performance capabilities there is Query Cache Filter. Query Cache was among the very

February 21, 2017

ProxySQL and MaxScale on point select workload

Few days ago MariaDB announced that MaxScale 2.1 is roughly 45% faster than MaxScale 2.0 . I first want to congratulate MaxScale Team: MaxScale 2.1 seems to

February 19, 2017

Conociendo ProxySQL

Last month, January 2017, two DevOps meetups were organized in Spain with the same topic: "Conociendo ProxySQL", presented by txetxu Velayos, @txetxuvel The

February 2, 2017

Testing performance of MySQL Group Replication

MySQL Group Replication is a hot topic in MySQL ecosystem. We have been evaluating it in , and it is now time to evaluate its performance, especially now that i

January 7, 2017

Proxy Wars: comparing ProxySQL to others

MySQL load balancers and proxies are becoming a very hot topic in the last few years. In the near future there will two presentations to compare proxies: T

July 16, 2016

Galera Awareness and ProxySQL Scheduler

One of the most common requests for ProxySQL is to support Galera Cluster. The Issue Support for Galera requires a lot of features to be added to ProxySQL:

June 18, 2016

Query rewrite with ProxySQL: use case scenario

One of ProxySQL most interesting features is query rewrite. This functionality is one of the main reasons to write a proxy that sits between the applicatio

← Previous 1 2 3 4 Next →

Showing 41–60 of 61 posts