MySQL

Category to track posts in PlanetMySQL

Multiplexing (Mux) in ProxySQL: Use Case

Multiplexing (Mux) in ProxySQL

Multiplexing Background
Historically it’s a technique used in networking to integrate multiple analog and digital signals via a shared medium. The goal of multiplexing over the network was to enable signals to be transmitted more efficiently for a given communication channel, thus achieving cost efficiency. 
Since the term Multiplexing comes from telecommunications, the industry has heavily […]

Read more

Running Percona XtraDB Cluster on Raspberry PI 3

Percona XtraDB Cluster on Raspberry PI 3

In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26.
We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external SSD drive to compile and […]

Read more

Why Database Schema Optimization Matters

Schema Optimization

If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks.  A few years back at Percona Live 2016, I gave an introductory talk on schema review and optimization. Here’s the video:
 
I was thinking about that […]

Read more

Percona Kubernetes Operator for Percona XtraDB Cluster 1.2.0 Now Available

Kubernetes Operator for XtraDB Cluster

We are glad to announce the 1.2.0 release of the  Percona Kubernetes Operator for Percona XtraDB Cluster.
The Percona Kubernetes Operator for Percona XtraDB Cluster automates the lifecycle and provides a consistent Percona XtraDB Cluster instance. The Operator can be used to create a Percona XtraDB Cluster, or scale an existing Cluster, and contains the […]

Read more

Percona XtraDB Cluster 5.7.27-31.39 Is Now Available

Percona XtraDB Cluster

Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the following:

Percona Server for MySQL 5.7.27-30
Codership WSREP API release 5.7.27
Codership Galera library 3.28

All Percona software is open-source and […]

Read more