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
4 views

Pgpool create a cluster node with no application traffic

I have a pgpool cluster with 2 standby and 1 primary node. I am trying to create another node which will get replicated but will not handle any request or application traffic. It will solely be use ...
0
votes
1answer
8 views

postgresql crash in master node with streaming replication

We have a master/slave postgresql cluster with streaming replication and pgpool. Versions in both postgresql servers are. postgres: 9.4 OS: Debian GNU/Linux 8 (jessie) PGPOOL server: version pgpool: ...
0
votes
1answer
20 views

Safely shutting down seemingly misconfigured (but working) PostgreSQL replication/archiving

I'm helping administer two PostgreSQL servers (one primary, one replica) plus a separate server running Barman for WAL archiving. I was not originally involved in setting up the replication and ...
0
votes
0answers
5 views

Data is not getting replicated from primary to standby in SAP ASE-ASE replication

2 SAP ASE servers are configured to replicate using SAP RS on a testdb with logical connection as a warm standby. In my case, all the threads and rep agents are running fine but data changes on PDS....
0
votes
0answers
14 views

Make slave has same “general_log” table like master server

Apologize for my English. I'm very new to database administration. I've been trying to set up MariaDB replication server by following this document. The only data that I need to replicate is in a ...
0
votes
0answers
22 views

pg_basebackup: COPY stream ended before last file was finished

I am unable to add a replica member back into the cluster. Setup: Haproxy, patroni, consul, postgresql11 Cluster: Leader, standby, 3 replica(all 3 failed in adding back to cluster) I could see the ...
1
vote
1answer
26 views

How to resolve “logical replication target relation schema.table is missing some replicated columns” error in postgresql logical replication?

I'm getting "logical replication target relation schema.table is missing some replicated columns" error in logical replication. I'm using all table replication. Due to some changes I ...
1
vote
1answer
97 views

AWS DMS Task getting failed after completion with error as AlwaysOn BACKUP-ed data is not available

I have created DMS task for migrating data from one RDS MS SQL Server instance to another RDS MS SQL Server instance with "Full load + ongoing replication", and data copied to target ...
0
votes
1answer
20 views

How to properly replicate and archive at once

I have a 300GB database that is growing around 5GB a day. It stores time-based data, and as such, I currently have around 60 days of data. My main database server has a 450 GB NVMe, so I want to get a ...
1
vote
1answer
17 views

How to configure Oracle traffic director for full site failover to have high availability?

I have two server systems, each server having both Apache Tomcat server (deployed web app) and Oracle 11g database server. The database on the two servers is synchronised by Oracle Data Guard for high ...
0
votes
1answer
22 views

Is it possible to replicate a collection in MongoDB

I would like to replicate/synchronize a collection named "CollectionA" from a mongoDB "DataBaseA" to a mongoDB "DatabaseB" in real-time DatabaseB is a normal database (...
0
votes
1answer
11 views

can you setup replication on mirrored SQL database

Just moved to SQL2017 Ent. Currently, do transactional replication for 1.5TB DB. the replicated database is used for data analytics, mainly Power BI reports. Need near real-time data. When I have ...
0
votes
0answers
20 views

Binlog is not being updated in Master

I am using mysql 5.6.19-log MySQL Community Server (GPL). I have done the necessary changes in my.cnf to start Master<->Slave Replication. But binary files are created and but they are empty. ...
0
votes
1answer
26 views

mariadb: replication master and slave have equal MySQL server ids

I'm a novice mariadb user trying to set up a master with multiple slaves using mariadb-10.4.17 on fedora33. I believe at one point I inadvertently ran the "change master" command on the ...
0
votes
2answers
28 views

In which order does a SQL Replication write the data

I use a unidirectional Replication of a database. In the Database I have a column with the datatype "timestamp" (not datetime). When the replication is initiated it writes table after table ...
0
votes
1answer
29 views

Transactional Replication between SQL Server 2017(Publisher+Distributor) and SQL Server 2019(Subscriber) [closed]

So here's the replication scenario that we need to set up. At organization A, We have SQL Server 2017 which is both the publisher and a distributor. At organization B, on a remote server, we have a ...
-1
votes
0answers
24 views

Why PostgreSQL stopped working after replication? [closed]

Here is my replication server's output before replication : [root@localhost bin]# systemctl start postgresql-9.6 [root@localhost bin]# systemctl enable postgresql-9.6 [root@localhost bin]# netstat -...
0
votes
0answers
31 views

SQL Server Transactional Replication: Adding an existing column to an existing publication article

We are using Transactional replication and I've been fighting with it over the past few days trying to add an existing column to an existing article that we now need replicated to the subscriber. I do ...
0
votes
0answers
5 views

How redo log transferred in galera SST

the galera replication can initiate a node with SST(mysql and mariadb) or mariadbbackup(with MariaDB 10.1 and above) . a SST operation works with rsync and transfer data to new node and then apply ...
0
votes
0answers
19 views

RDS PostgreSQL Transaction Logs grow with nightly backups

We have a production RDS for PostgreSQL instance that has a strange pattern of disk usage recurring in a manner consistent with the nightly backup schedule. Nightly, the backup is automatically ...
1
vote
2answers
46 views

Change host IP of master in mysql replication

I have one master and one slave. Suppose IP of master is changed but the physical server is same. Now I want to update the new IP (of the master) at the slave server. At the slave server ...
1
vote
1answer
36 views

SqlServer Database replication in remote datacenter. Which kind of replication? [closed]

Disclaimer: I am a developer, not a DBA. Scenario Currently two servers (Web Edition) in a private cloud in one single datacenter in Europe. 1 DB per client + 1 common DB used by all clients. We are ...
0
votes
1answer
50 views

MySQL cluster Replication and Failover via docker-compose

I am using docker-compose to create MySQL cluster (NDB). After cluster gets created. This is my cluster configuration: ndb_mgm> show Connected to Management Server at: mysql-manager-1:1186 Cluster ...
0
votes
0answers
47 views

Azure SQL Db to DB2 Sync

I need to automatically synchronize changes made in an Azure SQL database to our DB2 system. Whenever a change is made in Azure, DB2 should also be modified. Azure DB creation is not started and ...
0
votes
1answer
143 views

ERROR: canceling statement due to conflict with recovery

I got the error below: ERROR: canceling statement due to conflict with recovery. Detail: User query might have needed to see row versions that must be removed.; nested exception in org.postgresql.util....
0
votes
1answer
24 views

postgresql replication: WAL rotated before segment could be archived?

Using PostgreSQL 10.7 Checking my logs this morning, I'm seeing this error a lot: archive command failed with exit code 1 The failed archive command was: test ! -f /opt/bitnami/postgresql/archive/...
0
votes
3answers
169 views

MySQL V8 replication lagging waiting for handler commit

let me start with some background. We've decided to upgrade our Master DB to a more performant machine. We got a server with 1.5TB of RAM, Quad Intel(R) Xeon(R) Gold 6254 and IO is all NVMe drives. ...
0
votes
1answer
19 views

Is there a better way to add failed node back to postgres cluster?

There are 2 nodes in the cluster: node1(primary) and node2(replica). I will shutdown node1 and promote node2 as primary. I'll add the node1 back to the cluster (as a replica this time), so I am using ...
2
votes
2answers
59 views

SQL Server replication methodology

I have a relatively large production environment (150GB) in SQL Server, and I need to duplicate it somewhere else for querying (specifically: I need to create an environment identical to the ...
0
votes
0answers
26 views

Slave_SQL_Running_State init

I have a master-slave configuration. The slave stopped replicating with no errors. The only thing strange i see is this Slave_SQL_Running_State: init in show slave status; I see enter code ...
1
vote
1answer
22 views

Necessity of a DB-replication as extra security layer

I am confronted with a given infrastructure as following: A "main" DB has a master-slave replication DB, which only contains certain tables. A certain DB-user has read-only access to this ...
0
votes
2answers
24 views

SQL Server Snapshot Replication - Is there an option to clean up the snapshot folder after X amount of time?

We're running snapshots from a 2016 to a 2019 SQL Server. I've looked through Microsoft's documentation and I'm not seeing a clear cut way to have this, and I'm not seeing any jobs on the Publisher/...
0
votes
0answers
27 views

Merge replication between PostgreSQL <-> SQLite

In my app, the database (Postgres) consists of various tables referencing each other in one-to-many and many-to-many relationships, organized in subtrees. Each data subtree has a single parent row at ...
0
votes
1answer
31 views

How to find the table name from the pg_subscription_rel.srrelid (postgres logical replication)

I have postgresql logical replication setup between two servers and it seems to be working for the most part, except for one row when running SELECT * FROM pg_stat_subscription; never changes from ...
0
votes
1answer
233 views

mongodb replication failed with socketexception and listener

I'm trying to set up mongodb replication using two servers in different data center. For the purposes of this question, I'll say their IP address are 1.1.1.1 and 2.2.2.2. I installed a clean version ...
0
votes
1answer
20 views

In Postgresql 12 how to I make the primary server a slave after a deliberate failover

I am using PostgreSQL 12 on Debian 10.6. I have been reading up about replication and I have set up an asynchronous replication between one primary and standby. I wanted to test failover so I stopped ...
0
votes
0answers
9 views

What happens when independent writes are made to a MySQL DB and its writeable read-replica

The problem: I have a production RDS MySQL DB (PROD-DB). Data from it is read and written to by my production API. I would like to deploy migrations to a replica of PROD-DB and have the UAT instance ...
0
votes
0answers
38 views

Real time sync one table from DB (Server A) to DB (Server B)

need some suggestions on syncing data from one table (which get millions of records on a daily basis) from Server A to another database (different server B) in a real time. Whenever any update or ...
3
votes
2answers
108 views

Pre- and Post- Snapshot Replication Scripts Not Executing and No Errors

I have a Snapshot Replication Publication setup on Server 1. Server 2 subscribes to the publication on Server 1. Data is replicating successfully. The Distributor Agent and Agent job for the ...
1
vote
1answer
22 views

Replicate data from multiple tables with same structure to a single destination table with additional columns?

I have a table with say the following structure. This table is in multiple databases. Name varchar(50), Age int I want to replicate the data from this table from multiple databases to a single table. ...
1
vote
1answer
24 views

Can I upgrade MariaDB replication infrastructure gradually?

I have 2 masters and 1 slave (replicating form both masters). M1- MariaDB 10.4.11 M2- MariaDB 10.4.16 S1- MariaDB 10.4.12 I want to upgrade this LIVE system to 10.5 with possibly 0 downtime. The idea ...
0
votes
1answer
24 views

Consistent Prefix Reads

In the book Designing Data-Intensive Applications, the author suggests that replication lag can lead to an anomaly were causality is violated. In the example that the author uses, the system is both ...
1
vote
0answers
23 views

Postgresql Logical Replication Initial Table Sync Stage Restarting

I'm using logical replication on a Postgres 10 DB (Amazon Linux 2) to Aurora Postgres 11 RDS. There are 256 tables that need replicating and a few are pretty large (millions to 100s of millions of ...
0
votes
0answers
18 views

Replication Monitor is not showing correct list of replications

I have one server, in which there are three instances of SQL Server 2019. In one instance, I had configured transactional replications, but all of those replications are currently dropped. But the ...
0
votes
0answers
19 views

Mariadb (v5.5.65) replication unsuccessful. Slave_IO_State stuck at “Waiting for master to send event”

I am trying to configure a master-to-master replication of Mariadb. When I make changes to the master, the slave does not reflect the new changes. This is the guide that I referred to when setting up ...
0
votes
1answer
21 views

MongoDB 2 node cluster

I am trying to understand the implications of setting up a 2 node MongoDB cluster with the following configuration (Documentation does say a minimum of 3 nodes is required). MongoDB Version is 3.2. If ...
0
votes
0answers
6 views

How are GTIDs used to determine what transaction should be executed?

I use MariaDB 10.14 on servers M1, S2, S3. M1 is active master, and servers S2 and S3 replicate from M1. S3 also replicates from S2. All servers have GTID domain ID=1 then M1.server_id=100, S2....
0
votes
2answers
33 views

MongoDB cross datacenter replication without elections or high data availaility

I want to replicate a MongoDB database to another node, located in another datacenter. This is to help guard against data loss in the case of a hardware failure. We don't want/need high availability ...
1
vote
1answer
14 views

MySQL DB as Master for some tables and Slave for others

I have 2 DBs - DB1 (back-office) and DB2 (web application). The data needs to be synced between the 2. I'm happy with the idea of full master-master replication and may have to implement it, but ...
0
votes
0answers
12 views

Why has replication stopped working with “ASN: bad other signature confirmation” error?

We have had replication running for over two years, from a master to a slave, using SSL. Yesterday, it suddenly stopped working. Neither the master or slave have undergone updates and none of the ...

1
2 3 4 5
62