EmergencyEMERGENCY? Get 24/7 Help Now!

SSL Connections in MySQL 5.7

 | June 27, 2017 |  Posted In: MySQL, Security, SSL

SSL Connections

This blog post looks at SSL connections and how they work in MySQL 5.7. Recently I was working on an SSL implementation with MySQL 5.7, and I made some interesting discoveries. I realized I could connect to the MySQL server without specifying the SSL keys on the client side, and the connection is still secured […]

Read More

ProxySQL Rules: Do I Have Too Many?

 | April 10, 2017 |  Posted In: Benchmarks, MySQL, ProxySQL

In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL is heavily based […]

Read More

Is Your Query Cache Really Disabled?

and  | November 11, 2016 |  Posted In: MySQL

Query Cache

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

 | November 9, 2016 |  Posted In: MySQL, Orchestrator, 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 […]

Read More

Orchestrator: Moving VIPs During Failover

 | November 3, 2016 |  Posted In: High-availability, MySQL

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

Thoughts on MySQL 8.0 Invisible Indexes

 | October 27, 2016 |  Posted In: MySQL

Invisible Indexes

MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us? There are a couple of use cases. One of them is if you want to […]

Read More

Upgrading to MySQL 5.7, focusing on temporal types

 | April 27, 2016 |  Posted In: MySQL, Percona Server for MySQL

temporal types

In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why […]

Read More

Orchestrator-agent: How to recover a MySQL database

 | April 13, 2016 |  Posted In: MySQL, Orchestrator

orchestrator-agent

In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems. Please be aware that the following scripts and settings in this post are not production ready (missing error handling, etc.) […]

Read More

Orchestrator: MySQL Replication Topology Manager

and  | March 8, 2016 |  Posted In: MySQL, Orchestrator, Replication

Orchestrator MySQL topology manager

This blog post discusses Orchestrator: MySQL Replication Topology Manager. What is Orchestrator? Orchestrator is a replication topology manager for MySQL. It has many great features: The topology and status of the replication tree is automatically detected and monitored Either a GUI, CLI or API can be used to check the status and perform operations Supports automatic […]

Read More