Tag - Percona Server for MySQL

Percona Server for MySQL® is a free, fully compatible, enhanced, open source drop-in replacement for MySQL that provides superior performance, scalability and instrumentation. With over 3,000,000 downloads, Percona Server’s self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability.

Group Replication in Percona Server for MySQL

group replication percona server mysql

Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.
For this I planned to use three bare metal nodes, SSD drives, and a 10Gb network available for in-between nodes […]

Read more

Use MySQL Without a Password (and Still be Secure)

Use MySQL Without a Password

Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.
Neither of these plugins is new, and some words have been written about the auth_socket on this blog before, for example: how to change passwords in MySQL […]

Read more

ProxySQL 2.0.7 and proxysql-admin Tool Now Available

ProxySQL

ProxySQL 2.0.7, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.
This release includesPSQLADM-204: Add support of MariaDB 10.4

Improvements

PSQLADM-157: In some cases, the proxysql-status script used the cat command to display a file without […]

Read more

Percona Server for MySQL 5.7.27-30 Is Now Available

Percona Server for MySQL 5.7

Percona announces the release of Percona Server for MySQL 5.7.27-30 on August 22, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of #5678.
On a server with two million or more tables using foreign keys and AUTOINC columns, the shutdown may take a measurable length of time. Bug fixed #95895).
If large pages […]

Read more

ProxySQL 2.0.6 and proxysql-admin tool Now Available

ProxySQL

ProxySQL 2.0.6, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.
This release includesDocker images for release 2.0.6 are available as well. You can in the wiki format.
ProxySQL is available under Open Source license GPLv3.

Read more