Author - Tibor Korocz

ProxySQL Rules: Applying and Chaining the Rules

ProxySQL Rules

In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse.
Apply Test
In my previous post, we could see the effect of the rules on ProxySQL performance. As we could also see, the “apply” option does not help with 1000 tables. Are we sure […]

Read more

How to Fully Disable Query Cache in MySQL

disable query cache in MySQL.

This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL.
According to the manual, we should be able to disable “Query Cache” on the fly by changing
query_cache_type to 0, but as we will show this is not fully true. This blog will show you how to properly disable “query […]

Read more

Orchestrator and ProxySQL

Orchestrator and ProxySQL

In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together.
In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not, you can find the installation steps here.
In the case of a […]

Read more

Orchestrator: Moving VIPs During Failover

autotokubackup

In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator.
In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and […]

Read more