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
2
votes
1answer
26 views

Sync MySql Replication from Master2 to Master1 after failover

Due to Disk space issue Master2 server crashed and it was rebuilt again using mysqldump of Master1. Both Master 1 and Master2 are in sync and Master2 is in Read_only mode. During the crash, I stopped ...
1
vote
1answer
180 views

MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica

We have a Source Database of about 1TB, and a Replica on another server (similar architecture). We have setup Master Slave replication and delay between Master and Slave is always growing since. ...
0
votes
0answers
20 views

Should mysql database be replicated in a replication setup

When I do a replication setup I always ask myself should I put mysql and other internal databases (like information_schema) in the binlog_ignore_db option. Documentation about replication I read never ...
1
vote
2answers
25 views

Is there a way to analyze a MySQL query and determine whether it's read-only?

I have a main database and a replica that is automatically kept in sync with the main one. It would be nice, for each query I make, to perform all data- and database-altering queries on the main ...
0
votes
1answer
225 views

Can't restore master/slave replication from Percona backup (slave server)

A slave is restored from a master backup created with Percona xtrabackup On the master binlog is set to expire in 14 days and this backup is less than 24 hours old my.cnf (master) expire_logs_days = ...
0
votes
1answer
37 views

Does a single replica gives any performance improvement?

Consider a case where you have a single PostgreSQL database. Then you add a replica (hot standby) and you send all the reads to that replica. This is what does Rails for example. Does this gives any ...
1
vote
1answer
169 views

SQL Server Transactional Replication between SQL server 2019 Standard and SQL server 2016 Web Edition

We have SQL Server 2016 Web Edition on production currently. Since this edition supports replication as Subscriber only, I set up a new server with SQL Server 2019 Standard edition. I want to ...
0
votes
1answer
42 views

Filter a SQL replication

I'm trying to replicate a SQL database but I want to apply a filter based on date. The database has more than 6000 tables and all of them have a datetime column (stamp) with the same name "...
1
vote
1answer
126 views

Failover in MySQL Chain Replication

We have a 4 server setup, 1 master, 3 daisy-chained slaves, in the following setup: A (master) -> B (slave) -> C (slave) -> D (slave) (the servers B and C and D are running with ...
0
votes
2answers
232 views

Replicating PostgreSQL data into Citus/Greenplum?

I need to integrate data from 3 different PostgreSQL databases (OLTP application backends) in a data warehouse. For the data warehouse itself I consider using Citus or Greenplum. There is a ...
1
vote
1answer
105 views

Incremental encrypted per database backup and Partial restore policy for MySQL 5.7 in replication setup

I will run a replication cluster using MySQL 5.7 and I would like to set up for each database a backup policy that has a full once per day + incremental every N hours with data encrypted (based on the ...
0
votes
0answers
109 views

How to avoid Timeout Error while turning on DB Replication

I recently tried to replicate a database with only one table in it using transactional replication, using GUI of SQL server management studio. But, as soon, the publication is set up, I get this error....
1
vote
2answers
34 views

Is it possible to have 1 slave server with multiple master?

Here is my set of master server: DbServer1 - 10.1.0.1 DbServer2 - 10.1.0.2 DbServer3 - 10.1.0.3 DbServer4 - 10.1.0.4 and my replica server would be on 10.1.0.5 Is this doable if I create 4 instances ...
0
votes
1answer
68 views

Postgres replica tablespace files larger than primary (by about 1.5x)

I have a Postgres 9.6 database system with streaming replication and read-only query access enabled on the replica. I find that the replica tablespace data (not WAL data) is consuming about 1.5x as ...
0
votes
1answer
18 views

mysql master slave replication on same machine - Can log_bin need point to the same location on both instances?

I have been trying to setup a mater-slave replication on the same machine using mysqld_multi and it does appear to be working, but I have a few questions which have never really been an issue before ...
2
votes
2answers
155 views

How to ship new rows from the source to a target server?

Context We have a SQL Server 'source' where daily 10M rows inserted to a table. No updates. I would like to ship the new rows to a 'target' server, then delete those (sooner or later) on the source ...
1
vote
0answers
51 views

Syncing to a database behind a gateway

On our network we have a tunnel to a NAT gateway host. From the gateway host we are able to access a private network. On this network we will be running jobs that log to a database. The database ...
1
vote
3answers
234 views

Why MySQL 5.7 replication is verry slow on my new server

I have a problem with MySQL replication and I wanted to find advice or information on it. Let me show you the infrastructure. Master: This is our main MySQL server. I want to replace it by Slave B. ...
1
vote
1answer
122 views

One-directional database replication without delete on target database?

I have two databases: A small one where data is permanently added and a big one where the data is copied from the small one and is supposed to be stored long term. The small database deletes old data ...
0
votes
0answers
17 views

I'm looking for steps to reset my master-master replication after an error

I'm using mysql 5.7.30 with GTID enabled on two nodes (rhel 7.8) configured for master-master replication. In the event of an error where one or both of my slaves stop running I would like some ...
0
votes
0answers
36 views

sql publication / subscription 2008r2=>2012 Could not locate text information

I have replitation setup from sql 2008r2 publication to 2012 subscriber it was working fine and after 4h i faced error: Error messages: The process could not execute 'sp_replcmds' on 'PB01\PROD'. (...
0
votes
1answer
147 views

Recovery with Postgresql logical replication

I'm using Postgresql 13 on Debian 10.6 and learning about logical replication. I've set up logical replication with one publisher and one subscriber of one table. I'm wondering what my options are for ...
1
vote
1answer
54 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
70 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
42 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 ...
1
vote
1answer
511 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 ...
2
votes
2answers
5k 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
39 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 ...
0
votes
1answer
54 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
39 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
23 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
77 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
414 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
96 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
114 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 ...
3
votes
2answers
2k 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
46 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
568 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 ...
1
vote
1answer
5k 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
94 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/...
1
vote
3answers
2k 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
60 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
98 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
115 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
23 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
121 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
1answer
178 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 ...
3
votes
2answers
2k 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
123 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 ...
3
votes
2answers
371 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
3 4
5
6 7
65