In this article you will learn how to retrieve the size of a transaction, DML or DQL in MySQL.

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region MySQL HeatWave on AWS is now available in Japan Tokyo region. The new region enables customers with applications deployed in the Tokyo region to: Minimize network latency between the application and database, enhancing the user experience on the application Reduce the high […]

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region

Some times it’s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster. Today we will see the different possibilities to have an idea of the size of transactions. First we […]

When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn’t connect directly to the back-end server(s). The proxy usually understands the protocol used and can eventually take some decisions or even change the request.

The problem when using such proxy (like HA Proxy, ProxySQL and MySQL Router) is that the server doesn’t really know from where the client is connecting. The server sees the IP address of the proxy/router as the source IP of the client.

HA Proxy initially designed the Proxy Protocol, a simple protocol that allows a TCP connection to transport proxy-related information between the client, the proxy server and the destination server. The main purpose of the Proxy Protocol is then to preserve the client’s original IP address (with some others metadata). See …

When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn’t connect directly to the back-end server(s). The proxy usually understands the protocol used and can eventually take some decisions or even change […]

In this article you learn how to retrieve the original client's IP when using MySQL Router to connect to MySQL Server.

Table of contents:

1. Introduction
2. Common reasons for switching the primary node
3. Primary Promotion and its importance
4. Methods for switching the primary node
5. …

One of the most frustrating experiences when dealing with databases is when you've designed the perfect index, but MySQL still doesn't use it. There are several reasons why this could be the case, and in this article, we'll explore some of the most common ones. Throughout this article, we'll be working with a very simple people table that looks like this:CREATE TABLE `people` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `state` char(2) NOT NULL, PRIMARY KEY (`id`), KEY `first_name` (`first_name`), KEY `state` (`state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

We'll be adding and dropping keys throughout to show different scenarios, but this is a good starting place. Determining what index is being used Before you can determine why your index isn't being used, you must first determine that your index isn't being used. You can run an EXPLAIN on …

There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.