Setting World-Writable File Permissions Prior to Preparing the Backup Can Break It

Setting World-Writable File Permissions

It’s bad practice to provide world-writable access to critical files in Linux, though we’ve seen time and time again that this is done to conveniently share files with other users, applications, or services. But with Xtrabackup, preparing backups could go wrong if the backup configuration has world-writable file permissions.
Say you performed a backup on […]

Read more

InnoDB ALTER TABLE ADD INDEX and INSERT performance

InnoDB ALTER TABLE ADD INDEX

In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.”
Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became “ONLINE”. Meaning, when the ALTER is in progress, there can be concurrent SELECTS and DMLs. See the MySQL documentation […]

Read more

Upcoming Webinar 6/27: Beyond Relational Databases – A Look Into MongoDB, Redis, and ClickHouse

relational databases

Please join Percona’s Principal Support Engineer Marcos Albe as he presents “Beyond Relational Databases: A Look Into MongoDB, Redis, and ClickHouse” on Thursday, June 27th, 2019 at 12:00 PM PDT (UTC-7).
Register Now
We all use and love relational databases… until we use them for purposes for which they are not a good fit: queues, caches, […]

Read more

Percona XtraDB Cluster 5.7.26-31.37 Is Now Available

Percona XtraDB Cluster 5.7

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the following:

Percona Server for MySQL 5.7.26-29
Codership WSREP API release 5.7.25
Codership Galera library 3.26

All Percona software is open-source and […]

Read more