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
3,057
questions
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 ...