Tag: Percona Server

Feed: Planet MySQL; Author: MySQL Performance Blog; In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well. A word of disclaimer here, at the moment, by macOS we still understand macOS for Intel x86_64 architecture (the most recent ARM versions with Apple M1 / M2 processors are out of the scope of this blog post). Moreover, Percona does not provide official macOS packages for ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this component. The feature is similar to the AWS keyring plugin included in MySQL Enterprise, but it is implemented as a component instead, and because of that, it requires a different configuration. Configuring AWS KMS The component uses a single Master Key on KMS, which has to be created manually before configuring the component. This key ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; KMIP (Key Management Interoperability Protocol) is an open standard developed by OASIS (Organization for Advancement of Structured Information Standards) for the encryption of stored data and cryptographic key management. Percona Server for MySQL 8.0.27 and Percona XtraBackup 8.0.27 now include a KMIP keyring plugin to enable the exchange of cryptographic keys between a key management server and the database for encryption purposes. The procedure to use them with HashiCorp Vault Enterprise is described below. Install Hashicorp Vault Enterprise We will first install Hashicorp Vault Enterprise on Ubuntu Linux “Bionic” and then enable the ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; The most common issue when using row-based replication (RBR) is replication lag due to the lack of Primary keys. The problem is that any replicated DML will do a full table scan for each modified row on the replica. This bug report explains it more in-depth: https://bugs.mysql.com/bug.php?id=53375 For example, if a delete is executed on the following table definition: CREATE TABLE `joinit` (   `i` int NOT NULL,   `s` varchar(64) DEFAULT NULL,   `t` time NOT NULL,   `g` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `joinit` (  `i` int NOT NULL,  `s` varchar(64) DEFAULT NULL,  `t` ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Security will always be a main focal point of a company’s data. A common question I get from clients is, “how do I enable encryption?” Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary of the different options available for encryption in Percona Server for MySQL. Different certifications require different levels of encryption. For example, PCI requires both encryptions of data at rest and in transit. Here are the main facets of encryption for MySQL: Data at Rest Full disk encryption (at ... Read More

Feed: Planet MySQL; Author: Lenz Grimmer; As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona Server for MySQL 8.0.26, the storage engine will still be included in the binary builds and packages but will be disabled by default. If you are upgrading from a previous version, the TokuDB Storage Engine plugin will fail with an error message at server startup if it ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C to be a replica of B, i.e: You can follow the next steps: Note: log_replica_updates should be enabled on the soon-to-be primary as it is a prerequisite for chain replication. Note: It is assumed that both replicas only stream from Server A and there are no ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; With the CentOS project switching its focus to CentOS Stream, one of the alternatives that aim to function as a downstream build (building and releasing packages after they’re released by Red Hat) is Rocky Linux. This how-to shows how to install Percona Server for MySQL 8.0 on the Rocky Linux distribution. You can get the information on the distribution release version by checking the /etc/redhat-release file: [root@rocky ~]# cat /etc/redhat-release Rocky Linux release 8.4 (Green Obsidian) [root@rocky ~]# cat /etc/redhat-releaseRocky Linux release 8.4 (Green Obsidian) Installing and Setting up the Percona ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This quickstart shows you how to use the Azure portal to deploy a dedicated Percona Server for MySQL 8.0 drop-in replacement for MySQL that provides superior performance, scalability, and instrumentation. It also shows you how to connect to the server. Prerequisites Existing Azure subscription. If you don’t have a subscription, create a free Azure account before starting. Create Percona Server for MySQL 8.0 Azure Instance Go to the Azure portal to create a MySQL database using Percona Server for MySQL 8.0 image. Search for and select Percona Server for MySQL 8.0: On the Percona ... Read More

Feed: Planet MySQL; Author: Lenz Grimmer; After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly afterward on May 11, 2021, to fix a critical bug that we also observed during our initial testing and reported back to them. Therefore, we have decided to skip releasing Percona Server for MySQL 8.0.24 both as a standalone product and a distribution as well as the matching Percona XtraDB Cluster release. Our next public ... Read More