Tag: replication

Feed: Planet MySQL; Author: Oracle MySQL Group; High availability and replication is a must for any production environment in order to have a back-up process in place with minimum interruption in case of failure. In this article, I'll explain how to configure this architecture for MySQL HeatWave on OCI ... Read More

Feed: Planet PostgreSQL. In my previous blog post, I’ve written about the logical replication conflict and one mechanism introduced to avoid it - pg_replication_origin_advance.In this post, I’ll explain another measure to handle conflicts, using ALTER SUBSCRIPTION SKIP command This feature has a set of internal safeguards and inspections specific to the conflict handling. As a result, we don’t have the risk to skip non-failing transactions on conflict. Before we start My previous blog post has described what logical replication conflict is, how it happens, and how useful PostgreSQL 15 new features developed by the community are for its resolution. In ... Read More

Feed: AWS Architecture Blog. Enterprises frequently begin their journey by re-hosting (lift-and-shift) their on-premises workloads into AWS and running Amazon Elastic Compute Cloud (Amazon EC2) instances. A simpler way to re-host is by using AWS Application Migration Service (Application Migration Service), a cloud-native migration service. To streamline and expedite migrations, automate reusable migration patterns that work for a wide range of applications. Application Migration Service is the recommended migration service to lift-and-shift your applications to AWS. In this blog post, we explore key variables that contribute to server replication speed when using Application Migration Service. We will also look at ... Read More

Feed: Planet PostgreSQL. While physical replication copies whole clusters and accepts read-only queries on the standby if required, logical replication gives more fine-grained and flexible control over data replication. Logical replication is a method of selective data replication. While physical replication copies whole clusters and accepts read-only queries on the standby if required1, logical replication gives more fine-grained and flexible control over data replication. Some of the capabilities available in logical replication are:In logical replication, data is applied on the subscriber by subscription worker process, which operates in a similar way to conduct DML operations on the node. So, if ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; I am currently working on a script to auto-enable parallel replication / multi-threaded replication (MTR) when there is replication lag.  For testing this script, I need to trigger replication lag that would disappear after enabling MTR.  I came-up with a simple solution for that, and I thought it could be useful to more people, so I am writing this blog post about it.  Read-on for the details. Before explaining how to trigger replication lag, a few words about this Auto-MTR script.  It could seem uselessly complex to run a script enabling MTR when there ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; The binary logging format in MySQL has been ROW by default since MySQL 5.7, yet there are still many users sticking with STATEMENT or MIXED formats for various reasons. In some cases, there is just simple hesitation from changing something that has worked for years on legacy applications. But in others, there may be serious blockers, most typically missing primary keys in badly designed schemas, which would lead to serious performance issues on the replicas. As a Support Engineer, I can still see quite a few customers using STATEMENT or MIXED formats, even ... Read More

Feed: Planet PostgreSQL. PostgreSQL 14 already added the framework and decoder-side infrastructure to allow decoding of two-phase commits at PREPARE TRANSACTION time. PostgreSQL 14 also modified the test_decoding plugin to use this framework.The functionality was however not directly accessible to clients that used PUBLICATION/SUBSCRIPTION for logical replication. This meant that in PostgreSQL 14, prepared transactions were not sent to the subscriber while decoding the PREPARE TRANSACTION, but instead were sent to the subscriber only when decoding the corresponding COMMIT PREPARED. 1 Publisher side postgres=# CREATE TABLE test (col1 INT, col2 TEXT, PRIMARY KEY(col1));CREATE TABLEpostgres=# CREATE PUBLICATION pub FOR TABLE test; ... Read More

Feed: Planet MySQL; Author: Marco Tusa; 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 levels of data consistency between nodes.  The whole solution is composed as: Additionally, Orchestrator (https://github.com/openark/orchestrator) is used to manage the topology and the settings to enable on the replica nodes, the semi-synchronous flag if required. While we have not too much to say when using standard Asynchronous replication, I want to write a ... Read More

Feed: Planet MySQL; Author: Marco Tusa; Last month I performed a review of the Percona Operator for MySQL Server (https://www.percona.com/doc/kubernetes-operator-for-mysql/ps/index.html) which is still Alpha.  That operator is based on Percona Server and uses standard asynchronous replication, with the option to activate semi-synchronous  replication to gain higher levels of data consistency between nodes.  The whole solution is composed as: Additionally, Orchestrator (https://github.com/openark/orchestrator) is used to manage the topology and the settings to enable on the replica nodes, the semi-synchronous flag if required.While we have not too much to say when using standard Asynchronous replication, I want to spend two ... Read More

Feed: Recent Announcements. The Multi-AZ deployment option provides enhanced availability and data durability by automatically replicating databases between two AWS Availability Zones (in the same AWS Region). These Availability Zones offer you an easier and more effective way to design and operate applications and databases, making them more highly available, fault tolerant, and scalable than traditional single-datacenter infrastructures or multi-datacenter infrastructures ... Read More