Tag - Replication

Replication Between Two Percona XtraDB Clusters, GTIDs and Schema Changes

Replication Between Two Percona XtraDB Clusters

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 this: yes and no.
Galera assigns its own GTID for the operations, […]

Read more

Evaluating Group Replication Scaling for I/O Bound Workloads

Group Replication Scaling I:O Workload

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 MySQL”,  in this case, I will use an I/O bound workload.
For this test, I […]

Read more

Evaluating Group Replication with Multiple Writers in MySQL

Group Replication Multiple Writers 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 Replication Scaling Capabilities in MySQL.
For this test, I deploy multi-node bare metal […]

Read more

Evaluating Group Replication Scaling Capabilities in MySQL

Group Replication Scaling Capabilities in 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 server and connected between themselves by a 10Gb network.
Also, I will use […]

Read more

Continuous Replication From a Legacy PostgreSQL Version to a Newer Version Using Slony

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 PostgreSQL versions. However, logical replication works only for the currently supported versions of […]

Read more