Tag: Percona Server

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

Feed: Planet MySQL; Author: Lenz Grimmer; Back in December 2018, when we announced the general availability of Percona Server for MySQL 8.0, we also announced that the TokuDB Storage Engine has been marked as “deprecated” in this release, recommending to use the MyRocks Storage Engine as an alternative. We believe that MyRocks provides similar benefits for the majority of workloads and is better optimized for modern hardware. Since then, we have continued maintaining the storage engine in the 8.0 release, e.g. by incorporating bug fixes. However, the ongoing amount of changes that are still occurring in the upstream MySQL 8.0 ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were introduced by the Oracle MySQL team (and to which Percona also contributed). Hashicorp Vault Plugin Support for KV Secrets Engine – Version 2 (PS-5364) As of Percona Server for MySQL 8.0.23-14, the Hashicorp Vault plugin can be configured to specifically use either V1 or V2 Secrets ... Read More

Feed: Planet MySQL; Author: Marco Tusa; While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL are executed inside a Group Replication cluster. The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Checking the Group Replication (GR) official documentation I was trying to identify if any limitation exists, but the only thing I have found was: "Concurrent DDL versus DML Operations.  Concurrent data definition statements and data manipulation statements executing against the same object but on different servers is ... Read More