Buy Percona ServicesBuy Now!

Unexpected slow ALTER TABLE in MySQL 5.7

and  | April 23, 2020 |  Posted In: Intermediate Level, MySQL, Percona Server for MySQL

Usually one would expect that ALTER TABLE with ALGORITHM=COPY will be slower than the default ALGORITHM=INPLACE. In this blog post we describe the case when this is not so. One of the reasons for such behavior is the lesser known limitation of ALTER TABLE (with default ALGORITHM=INPLACE) that avoids REDO operations. As a result, all […]

Read More

Disk of Yesteryear Compared to Today’s SSD Drives

 | January 17, 2020 |  Posted In: MySQL, Open Source Databases, Percona Server for MySQL

In my last blog post I showed you how to get the entire Percona “Stack” up and running on a Raspberry Pi. This time around, I would like to show the impact on performance between using an SSD hard disk and a standard hard disk. Disk performance is a key factor in Percona Server for MySQL […]

Read More

Percona Server for MySQL 8.0 – New Data Masking Feature

 | December 13, 2019 |  Posted In: Intermediate Level, MySQL, Percona Server for MySQL

Data Masking in Percona Server for MySQL 8.0.17

Database administrators are responsible for maintaining the privacy and integrity of data. When the data contains confidential information, your company has a legal obligation to ensure that privacy is maintained. Even so, being able to access the information contained in that dataset, for example for testing or reporting purposes, has great value so what to […]

Read More

Deploying MySQL on Kubernetes with a Percona-based Operator

 | October 11, 2018 |  Posted In: Advanced Level, DevOps, MySQL, Percona Server for MySQL

Kubernetes MySQL Operator

In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model, as we call it. The workloads are mostly reads, so we need to efficiently scale that. The MySQL® asynchronous replication model fits the bill very well, allowing us to scale horizontally […]

Read More