The latest from the MySQL community

MySQL Advent Calendar 2022 - Day 7: how to use a backup as source for a new OCI MySQL Database Service instance with Terraform.

Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview.

A description of the existing plugin features and usage instructions are available in the earlier blog post introducing the LDAP simple plugin, and in the Percona Server for MySQL documentation.

SASL connections

We introduced a new plugin similar to the MySQL …

What is a Delay Replica and how does it help?

MySQL Replication is useful, easy to set up, and used for very different purposes. For example:

• split reads and writes
• run data mining or reporting processes on them
• disaster recovery

To learn more, check out How Does MySQL Replication Work?

It’s important to mention that a replication server is not a backup by itself. A mistake on the source, for example, a DROP DATABASE or an UPDATE without a WHERE clause will be replicated nearly instantly to all replica servers. Simply having a replica is not going to be helpful here. How can we avoid that kind of mistake? By having a replica server that intentionally lags behind.

We can never avoid human error in database infrastructure operations. But …

Let’s continue our journey of deploying the MySQL Database System on OCI with Terraform. This time we will see how we can use a backup (see [1] and [2]) as a source (initial data) for a new instance. Within the oci_mysql_mysql_db_system it’s possible to define a source detailing how to provision the initial data of […]

Background In databases, rows are persisted on disk and for every row, columns’ value are stored on disk. Now, if a new column is to be added or an old column is to be dropped from a table, the contents of existing rows should be changed to reflect the correct values of columns present in […]

MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections.

Web-Konseil, is a web and digital agency based in Lyon, France.  The agency supports companies in the development of websites and e-commerce applications. Its business keeps growing with constant innovation and introduction of new services. Thanks to a partnership with Oracle, Web-Konseil already offers a hosting service for its customers on Oracle Cloud Infrastructure (OCI). […]

Web-Konseil is a web and digital agency based in Lyon, France. It develops websites and e-commerce applications for its clients using MySQL HeatWave in local Oracle data centers located in Paris and Marseille. MySQL HeatWave on OCI gives Web-Konseil a clear competitive advantage by offering their customers real time data insight.

Get it from the download page

3rd party updates:

• Update plink binaries to latest v0.78. Closes issue #1430

New stuff:

• Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026
• Issue #1705: Add new network type "MySQL on RDS", to support its different query for killing a process. New icon provided by …

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it.

Explanation

How do we know where the memory is getting used?

Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning.

This post mostly talks about stats in MySQL query digest in ProxySQL.

Memory used by query digest can grow unlimited, and you can query the memory usage with the below query with an admin login. The memory usage is shown in bytes. 

MySQL [(none)]> select * from …