Questions tagged [replication]

Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

How to set up Postgres High availability cluster with load balancing and replication

My requirements: Set up Postgres server(s) on AWS EC2 instance Set up replication Set up failover to ensure high availability I have a raw machine image having postgres with no database installed. ...
2
votes
0answers
23 views

Postgres difference between restart_lsn and confirmed_flush

According to the documentation, restart_lsn is The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints... ...
-1
votes
1answer
60 views

Relational database with Kafka-like durability/caching implementation

When reading about Kafka I found it really interesting how they are providing durability, especially in comparison to databases: Kafka - never writes synchronously to disk, provides durability by ...
0
votes
1answer
16 views

mysql/mariadb replication with proxy

I have a standard master-slave replication for MariaDB to sync one database (master) to multiple slaves. One of the slaves lives behind a proxy, so I need to proxy the replication request to the proxy ...
1
vote
3answers
32 views

SQL Server replication additional subscriber

I have a publisher with the distributor on the same server which is transactional replication. There is also an active subscriber using push method. I need to set a new subscriber up going to a ...
0
votes
1answer
10 views

How to organize MongoDB replicaset backup and alerting

I have a running MongoDb replicaset consisting of 2 replicas and 1 master nodes. Recently I noticed that my master gone and automatic failover took action and changed master, however I wasn't aware of ...
0
votes
1answer
18 views

postgres: reset pg_last_xact_replay_timestamp()

We have a pg10 replica that got promoted to master and have monitoring around the following query to monitor replication SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp())) as lag ...
0
votes
1answer
47 views

What options we have today to extend Availability Groups (for Read Only)?

Is there any other way to extend availability groups cluster (for Reading) except by adding Read Only replicas to the Availability Group (adding Enterprise edition instances) or by introducing ...
1
vote
1answer
50 views

MS-SQL transactional replication - How to figure out how much data is being pushed per day in replicated databases

We use MS SQL Server transactional replication in our environment. I would like to know if there is a way or script to figure out how much data is being pushed per day to replicated databases? How to ...
0
votes
1answer
5 views

Sql server transactional replication latency

I'm analyzing the distribution database to see if there any latency in the replication between publisher and subscriber The architecture is one publisher, 1 distrubution db (on publisher server) and ...
1
vote
0answers
30 views

Mysql 5.6 tmpdir change deletes some users

We have a Percona-mysql 5.6 setup with one master and one replica. After trying to do a big ALTER TABLE on it, it failed because the tmpdir was inside of the memory and therefore wasn't big enough. ...
1
vote
1answer
11 views

Does Azure Mariadb/Mysql data-in replication support certificate chains?

I would like to migrate from AWS RDS Mysql to Azure Mariadb managed database. For this purpose, I would set up data-in replication using TLS, roughly following the provided guide. AWS provides ...
0
votes
0answers
14 views

display the transaction for a given GTID in MySQL

is there a way to show the statements of a transaction for a given GTID ? I know the binlog, if the correspond binlog file was not purged, can be used, but I'd like to know if I could see any ...
0
votes
0answers
24 views

PostgreSQL- replication server lags behind the master - memory usage too high

we have a classic physical replication with primary and secondary nodes. The two nodes are also monitored by software. There are always lags between the primary server and secondary server when there ...
0
votes
1answer
38 views

oracle goldengate replication

Please I need help. Actually i am working on oracle 19c to perform a data base replication using the goldengate. I created two data bases (source and destination) the 3 processes (extract, pump and ...
0
votes
1answer
39 views

What does it mean when slave status shows SQL running but IO not running?

What exactly does this mean, when the SQL is running but the IO is not running on the Slave in a Master-Master replication setup? There are no other errors showing when running show slave status\G ...
2
votes
0answers
22 views

mySQL cluster with Active Active DC

Let me give you a bit of background before jumping into the discussion. Our company is running two DC's in active active scenario, we spent a lot of money on getting specialized hardware to be ...
1
vote
1answer
28 views

Postgres schema based replication

I have setup streaming replication in postgresql V10 in the production environment. Now for a typical scenario, I would like to know if I can configure replication in such a way that only specified ...
2
votes
0answers
39 views

Postgresql 11: terminating walsender process due to replication timeout

I have found some questions about the same error, but didn't find any of them answering my problem. The setup is that I have two Postgres11 clusters (A and B) and they are making use of publication ...
0
votes
1answer
25 views

Is there a way to setup one Alert for all Replication errors?

I have a SQL Server 2016 (Standard) instance, with DatabaseA, who is the Publisher in a Transactional Replication (push subscription) topology. A second SQL Server 2016 (Standard) instance, with ...
0
votes
0answers
24 views

Large number of row locks on a partitioned slave table

I am testing mysql5.7.28 partition. Table in master is not partioned. The table in slave is partitioned. When I start the replication, slave lag keeps on increasing. This is the table schema in master ...
1
vote
1answer
18 views

restarting master and slave machines without breaking master slave MySQL replication

We need to resize the size (CPU and RAM) of two database servers having MySQL server 8: master and slave, but this operation implies that those machines will be restarted, And I think a restart of ...
0
votes
1answer
19 views

Replicating to 3 databases one is web server

I have a customer that is looking for a very unusual replication configuration. I am hoping for some insight on why this is a bad idea, or even the possibility that it can be done. There are two ...
0
votes
0answers
12 views

Replicating multiple unrelated servers

We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
2
votes
0answers
24 views

Issues with failback for logical replication using postgres

I am using PostgreSQL 13 to set up logical replication. When the original active node (A) becomes the secondary, the prior secondary(B) which is now active node needs to sync to the (A) node. To ...
0
votes
0answers
14 views

MSSQL P2P Replication , after add subscription slow on initialization

I am creating a new peer to peer replication. First, I backup my database from master server and restore it into secondary server. Then, I run below script on both of my "master server" and &...
0
votes
0answers
17 views

CDC on secondary from different replication schemas - analysis

We have a mission critical database in Sql Server 2016 (Std) and we are not authorized to alter the schemas because of legal issues with the software provider. We need a way to have CDC in that ...
0
votes
0answers
24 views

Issue with pg_basebackup

I am trying to create postgres replication to another server. But while create base backup., I am getting following error. Pg_basebackup: could not send replication command "IDENTITY_SYSTEM":...
0
votes
1answer
17 views

Limit size of WAL files for PostgreSQL database

I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension. Recently, one of the application migrations has updated the schema of the ...
2
votes
1answer
151 views

RDS Postgres oldest replication lag increases during inactivity even though Fivetran connector keeps synchronizing

I'm in the process of setting-up a datawarehouse using Fivetran as the ETL layer. One of the source databases is a AWS RDS Postgres instance. I've configured the Postgres instance to perform Logical ...
1
vote
0answers
41 views

Sql Server Replication Slow when Downloading to Publisher

I got a very weird problem. On a SQL Server 2017 Standard and with MERGE replication with job run at subscriber. The problem happens in 2 out of 4 of our customers environment. The configuration is as ...
1
vote
0answers
26 views

MySQL Replication stop after a huge amount of transactions on Master

Running MySQL 8 for months now, without much troubles, I still have randomly some problem of replication between the Master and its Slave. Problems means, all works, both instance works, still the ...
0
votes
1answer
18 views

ALTER TABLE statements not replicating in all tested scenarios - MariaDB

Summary Tech: mariadb 10.3 Issue: some attempts to ALTER TABLE to change engine is not replicating. Scenarios tested: command line PHP script running ALTER statements using PDO - did not replicate ...
0
votes
1answer
28 views

Strange replication failure on date field under MySQL 5.7

This problem cropped up yesterday and I'm quite stumped. I have a primary RDS cluster that is running MySQL 5.6 and RDS is forcing everyone to 5.7 soon. I have a smaller standalone replication slave ...
1
vote
1answer
15 views

How do I restore all replicated MySQL servers from a backup?

I've got two MySQL 5.7 servers running with binary log replication. I now need to rollback to an older backup but I'm not sure what effect this will have on the binary log for replication. If I just ...
0
votes
0answers
36 views

SQL Server Replication - accidentally unselected table from snapshot: how do I add it back in again?

Using SQL Server merge replication, one of the tables was accidentally unselected (check box unticked). How do I add it back in to the snapshot again? It was unfortunately a large table with plenty ...
1
vote
2answers
43 views

Is there a mysql feature to allow parallel replication per query?

When adding columns or indexes to big tables in a master salve setup, replication lag occurs. My understanding is that replication occurs in a single thread on the slave, and statements get executed ...
0
votes
0answers
15 views

Timestamp is off by an hour When Migrating from Mysql to Sql server AWS DMS

We are trying to migrate a MySQL database on AWS RDS to SQL Server Database on AWS. Both the Source and Target Database are created in PST Time zone. Replication Instance Version : 3.4.4 Mysql Version:...
0
votes
1answer
26 views

Merge Replication Subscriber does not Expire or cleaned up

I have a merge repliaction with retention period set to 1 day. Allow anonymous Subscriptions is set to False. I Add 2 subscribers. One of the subscriber machine name is wrong, so it is inaccessible. ...
0
votes
1answer
22 views

How Can I Find the Problems Occurred on MySQL-MariadbDB Systems?

I have built a three-node galera cluster, so it is a Master-Master replication structure. But sometimes the first node goes down and I can't find the problem causing this. I am only looking at /var/...
1
vote
1answer
39 views

Is there any way to monitor if all columns in an article is published in replication

In replication, if we add a column in Publisher then it doesnt replicate to Subscriber unless it is done explicitly. I am looking for a way to track or monitor this. I am not able to find any system ...
0
votes
1answer
20 views

Mysql Replication trigger not executing on slave

Mixed replication is enabled. MySQL master has a table Products that has triggers on update and delete. On slave database we have different trigger on same table on update and delete. Master database ...
0
votes
1answer
34 views

Mysql replication, replica not running inserts

I was trying to rebuild a MASTER - MASTER replication after a server reinstall and ran into a replication error after starting the slave. MASTER conf: [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION # ...
0
votes
1answer
21 views

Error on adding an arbiter

Adding 5th node getting an error "Our replica set configuration is invalid or does not include us Presently all 4 nodes are healthy. node arb1 arb2 rs1 m1,m2,m2 a1 when I try to add a2 both ...
0
votes
0answers
101 views

The SQL Server replication subscriber cannot start: 'No agent status information is available.'

I am trying to run merge replication of the database between two servers (both are SQL Server version 15). Both servers are in the domain. On both I am logged using this domain account (all server ...
1
vote
1answer
27 views

PostgreSQL Replication to a Different Schema

I want to consolidate 3 different production databases into a single reporting database. Let's say we have 3 production databases: Prod 1 Prod 2 Prod 3 What I want to do is to replicate data from ...
0
votes
2answers
28 views

Does GTID have only benefits in MySQL over "standard" Replication?

I'm used to setup MySQL replication in the old-fashioned way and notice now there is a method using GTID. From what I read, GTID is presented has an improvement over "standard" replication. ...
5
votes
1answer
87 views

postgresql: Replaying of streaming WAL files is slow on some standby servers

Environment: Postgresql 9.6.21. Multiple standby servers managed by patroni + Cluster: db11 (12345678901234567) ------+---------+-----+-----------+ | Member | Host | Role | ...
0
votes
0answers
20 views

MySQL replication server as proxy/intermediary? [duplicate]

My current infrastructure is composed of a master MySQL server and a number of slaves, all connected via a private network not accessible via Internet. I need to create another slave located outside ...
0
votes
0answers
23 views

Restore the distribution database to production database

I was trying to set up my SQL server for replication. I accidentally added my production database as the distribution database. Is there any way to revert the changes without losing any data in the ...

1
2 3 4 5
64