Author: Przemysław Malkowski

How to Quickly Add a Node to an InnoDB Cluster or Group Replication

Quickly Add a Node in InnoDB Cluster or Group ReplicationIn this blog, we’ll look at how to quickly add a node to an InnoDB Cluster or Group Replication using Percona XtraBackup. Adding nodes to a Group Replication cluster can be easy (documented here), but it only works if the existing nodes have retained all the binary logs since the creation of the cluster. Obviously, […]

Instrumenting Read Only Transactions in InnoDB

Instrumenting read only transactions MySQLProbably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction. Now, as a […]

MyRocks Disk Full Edge Case

problem in MyRocks

RocksDB engine—and it’s MySQL implementation MyRocks—is a very good alternative engine for MySQL. It has proven to be very efficient and stable for many workloads, including those of large scale. However, it is still a relative newborn in the MySQL ecosystem, and has only a small fraction of the adoption rate of InnoDB. That means […]

The post MyRocks Disk Full Edge Case appeared first on Percona Database Performance Blog.

How to Handle pt-table-checksum Errors

pt-table-checksum Errors

In this blog post, we’ll look at how to approach pt-table-checksum errors. pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support Engineers we have customers often asking questions related to the pt-table-checksum errors and warnings produced. […]

The post How to Handle pt-table-checksum Errors appeared first on Percona Database Performance Blog.

Quest for Better Replication in MySQL: Galera vs. Group Replication

Group ReplicationUPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “virtually synchronous.” This term is more accurate and already used by both […]

WAN Synchronous Clusters: Dealing with Latency Using Concurrency

WAN LatencyIn this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN deployments is having the primary site in one data center, and stand-by backup site in […]

TEL/電話+86 13764045638
QQ 47079569