Tag - insight for DBAs

Using MySQL 8 Persisted System Variables

MySQL 8 Persisted System Variables

This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not persistent and are reset upon restart. These variables can be changed […]

Read more

MySQL 8.0.22: Asynchronous Replication Automatic Connection (IO Thread) Failover

MySQL 8.0.22 Asynchronous Replication Automatic Connection

MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, you can configure your async replica to choose the new source in case the existing source connection (IO thread) fails. In this blog, I am going to explain the entire process involved in this […]

Read more

Community Contributors Invited to Update Percona Monitoring and Management Documentation

Percona Monitoring and Management Documentation

Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more welcoming for community members to contribute to our documentation.
Percona Monitoring and Management (PMM) is a free, open-source database monitoring tool. It ‘mind-melds’ with your MySQL, MongoDB, or PostgreSQL servers and tells you what’s going […]

Read more

MySQL New Releases and Percona XtraBackup Incompatibilities

MySQL Percona Backup Incompatibilities

Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0:
MySQL 5.7.32
While our QA team was performing an extensive test on it,  we found out this version introduced a new compression format […]

Read more

Using Volume Snapshot/Clone in Kubernetes

Volume snapshot and clone Kubernetes

One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This feature also brings Kubernetes deployments close to cloud providers, […]

Read more