by Przemysław Malkowski | Jun 25, 2024 | Insight for DBAs, MySQL
Replication has been the core functionality, allowing high availability in MySQL for decades already. However, you may still encounter replication errors that keep you awake at night. One of the most common and challenging to deal with starts with: “Got fatal...
by Matthew Boehm | May 29, 2024 | Insight for DBAs, Percona Software, Valkey
In most database systems, like MySQL, PostgreSQL, and MongoDB, replication of some kind is used to create a highly available architecture. Valkey/Redis is no different in this regard. Replication is native functionality to Valkey, supporting multiple replicas, and...
by Brijesh Chauhan | Apr 11, 2024 | Insight for DBAs, MariaDB, MySQL
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not...
by Bhargav Kamineni | Dec 14, 2023 | Insight for DBAs, PostgreSQL
While a hallmark feature of PostgreSQL is streaming replication, sometimes data demands a more refined and adaptable replication approach to address different requirements. Logical replication offers a distinct advantage over traditional streaming replication by...
by Fernando Mattera | Oct 31, 2023 | Insight for DBAs, MySQL, Percona Services
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time. This time, I’m going to tell you about a particular case: a client with a...
by Kedar Vaijanapurkar | Sep 20, 2023 | Insight for DBAs, MySQL
As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding...
by Anil Joshi | Aug 17, 2023 | Insight for DBAs, MySQL
by Dimitri Vanoverbeke | Aug 15, 2023 | Insight for DBAs, MySQL
This blog was originally published in February 2017 and was updated in September 2023. In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works, its benefits and challenges, as well as reviewing some of the MySQL...
by Mughees Ahmed | Jan 23, 2023 | Insight for DBAs, MySQL
A couple of days ago I was creating an index on the source and when I checked the replica side it was not replicated, so I just wanted to explain how the replication filter may increase the complexity of your DBA operations. Replication occurs by reading events from...
by Mughees Ahmed | Dec 6, 2022 | Insight for DBAs, MySQL, Percona Software
What is a Delay Replica and how does it help? MySQL Replication is useful, easy to set up, and used for very different purposes. For example: split reads and writes run data mining or reporting processes on them disaster recovery To learn more, check out How Does...
by Sveta Smirnova | Jul 29, 2022 | Benchmarks, Insight for DBAs, MySQL, Percona Software
In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include: sysbench – https://github.com/akopytov/sysbench BMK-kit –...
by Marco Tusa | Apr 12, 2022 | Cloud, MySQL, Percona Software
Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha. That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher...
by Sveta Smirnova | Jul 28, 2020 | MySQL, Percona Software
I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post. Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster? Answer for...
by Vadim Tkachenko | Apr 10, 2020 | Benchmarks, MySQL
In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. While this setup is identical to that in my post “Evaluating Group Replication Scaling Capabilities in...
by Vadim Tkachenko | Apr 9, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write connection is established to multiple nodes, and in this case, two nodes. This setup is identical to my previous post, Evaluating Group...
by Vadim Tkachenko | Apr 8, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual...
by Nickolay Ihalainen | Apr 9, 2019 | Insight for DBAs, PostgreSQL
Native streaming replication in PostgreSQL works only between servers running the same major version. We discussed about logical replication in our previous blog post. In that post, we saw how logical replication could help us set up migration between two different...
by Avinash Vallarapu | Apr 4, 2019 | PostgreSQL
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a...
by Vinicius Grippa | Mar 13, 2019 | MySQL, Percona Software
Recently, we had an edge case where a MySQL slave went out-of-sync but it couldn’t be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended,...
by Tibor Korocz | Oct 17, 2018 | Insight for DBAs, MySQL
Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it...
