Tag: replication

Feed: Recent Announcements. Amazon EFS Replication provides you with an easy way to keep an up-to-date copy of your file system in a second AWS Region or within the same Region. Amazon EFS Replication enables you to replicate file data in a few clicks and without requiring you to manually provision additional infrastructure or a custom process to monitor and synchronize data changes. Amazon EFS Replication is designed to meet a recovery point objective (RPO) and recovery time objective (RTO) of minutes, enabling you to meet your business continuity and compliance requirements. Amazon EFS provides a simple, serverless, set-and-forget, elastic ... Read More

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 PostgreSQL. Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents. The stake and impact were so high that many organizations had to discard their plans around logical replication, and it affected many plans for migrations to PostgreSQL. It was painful to see that many had to opt for proprietary/vendor-specific solutions instead. At Percona, we have written about this in the past: Missing Piece: Failover of the Logical Replication Slot.  In ... Read More

Feed: AWS Architecture Blog. In Part 1 of this blog series, we looked at how to use AWS compute, networking, and security services to create a foundation for a multi-Region application. Data is at the center of many applications. In this post, Part 2, we will look at AWS data services that offer native features to help get your data where it needs to be. In Part 3, we’ll look at AWS application management and monitoring services to help you build, monitor, and maintain a multi-Region application. Considerations with replicating data Data replication across the AWS network can happen quickly, ... Read More

Feed: Planet MySQL; Author: Marco Tusa; Last April 2021 I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.  Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL. This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.  Before going ahead, let ... Read More

Feed: Recent Announcements. AWS Storage Gateway now supports Dell EMC NetWorker 19.5 and Veeam Backup & Replication 11A on Tape Gateway, enabling you to backup and archive data from Dell EMC NetWorker and Veeam Backup & Replication to AWS without changing your backup workflows. With this announcement, Tape Gateway supports Dell EMC NetWorker 19.5 and Veeam Backup & Replication 11A running on Microsoft Windows Server 2019 ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Klaas Stijnen. By Klaas Stijnen, Chief Product Officer and Co-Founder – MontouxBy Ben Meyvin, Principal Partner Solutions Architect – AWS Montoux The technology challenges facing life and health insurers’ actuarial teams are neither new nor a secret. Decades-old legacy software is directly responsible for wasteful expenditure, risks, and opportunity costs, forcing carriers to search for modern alternatives to reduce costs and improve business performance. Montoux’s next-generation decision science platform uniquely combines both actuarial and data science in its software. It provides a modern, flexible, and sophisticated alternative to legacy actuarial software. However, the ... Read More

Feed: Recent Announcements. AWS Application Migration Service (AWS MGN) now supports agentless replication from VMware vCenter versions 6.7 and 7.0 to the AWS Cloud. AWS Application Migration Service is the primary service for lift-and-shift migrations to AWS. The new agentless replication feature is intended for users who want to rehost their applications to AWS but cannot install the AWS Replication Agent on individual servers due to company policies or technical restrictions. You can perform agentless snapshot replication from your vCenter source environment to AWS by installing the AWS MGN vCenter Client in your vCenter environment. AWS Application Migration Service minimizes time-intensive, ... Read More

Feed: DB-Engines.com Blog. Author: Konstantin Nazarov, Tarantool. Blog > Postby , 9 November 2021Tags: Replication, TarantoolDespite the current difficult economic climate, large companies continue digitalizing their businesses. Mobile apps and personal dashboards have become indispensable service and communication channels, significantly increasing the load on IT infrastructure. There are many ways to deal with this load by improving system performance. One of the options is to use in-memory technology. But can it guarantee sufficient reliability? About ten years ago, the capacity of 1,000 queries per second was enough to process all card-related operations in a bank. Today, only investment deals in ... Read More

Feed: Recent Announcements. Along with this minor version, we’ve added support for Global Transaction Identifiers (GTIDs) and Delayed Replication to MySQL version 8.0. These two features were previously unavailable in Amazon RDS for MySQL version 8.0, and are now available for MySQL version 8.0.26 and higher. Global transaction identifiers (GTIDs) are unique identifiers generated for committed MySQL transactions. You can use GTID-based replication to make binlog replication simpler and easier to troubleshoot when using Amazon RDS for MySQL read replicas or with an external MySQL database. For more details see Using GTID-based Replication for MySQL in the Amazon RDS User ... Read More