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
1
vote
1answer
84 views

Selecting specific table for each subscriber when using merge replication in SQL Server with multiple subscribers

I am using merge replication with SQL Server 2017. I have one publisher, and two subscribers (all in all 3 database servers). I need to replicate different tables to each subscriber. Is this ...
0
votes
0answers
20 views

Database synchronization 2 times a day -MariaDB

I have 2 different servers. The first one is server1 and the other is server2. On servers, one works for websites (server1) and the other for mobile applications (server2) for security purposes. I ...
10
votes
1answer
202 views

What is a “hashed transaction” in SQL Server Replication terminology?

sys.dm_repl_tranhash contains information about the hashing of transactions, but I have difficulties understanding the terminology. What is a "hashed transaction"?
0
votes
0answers
24 views

Is it a good idea to have a read connection point to both write database and read replica?

In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
1
vote
1answer
36 views

SQL Server 2016 Standard Edition Replication

I have a single database running on SQL Server 2016 Standard edition in our primary datacenter. I would like to keep a live copy as close to realtime (1-2 minutes) in our disaster recovery datacenter ...
0
votes
1answer
20 views

Relay log read fail, relay or master log currupt ,How to repair?

I am running mysql InnoDB cluster 8.0.17(group replication) During the repication the slave disk gets full and no space left at all the thread waits for the disk space to be freed at the same time ...
0
votes
0answers
24 views

Migrate a legacy application that uses MySQL replication

I have been working on the migration of a legacy ecommerce web application to a new server with far hardened security. I have found an aspect with the MySQL server that I am not acquainted with and I ...
0
votes
0answers
15 views

How to change the replication user in Pglogical without breaking the replication?

if_id | if_name | if_nodeid | if_dsn -----------+---------------------+-----------+-------------------------------------------------------------- 440218642 | ...
1
vote
1answer
44 views

Accessing Administrative Share Using Listener Name

Can a SQL Server AG listener name be used to access an administrative share i.e \\DB-listener\c$\Somefolder? I can RDP using the listener name but can't use the listener name to access the $ ...
0
votes
0answers
67 views

PostgreSQL 10 logical Replication not working !!! slots blocking calls not sending wal events back to client

Postgres logical replication not working we have created logical replication slot on pg 10 using below command select * from pg_create_logical_replication_slot('slot', 'wal2json'); Above request ...
2
votes
1answer
46 views

Which are the downsides of not deleting the CDC records in change tables?

If I do something like this: USE AdventureWorks2012; GO EXECUTE sys.sp_cdc_change_job @job_type = N'cleanup', @retention = 52494800; -- (100 years) GO The records in the change ...
0
votes
0answers
129 views

logical replication in postgresql - “server closed the connection unexpectedly”

I'm running two postgresql servers and I'm trying to setup logical replication. These are extra bits of configuration I added on master in order to make replication work: wal_level=logical ...
0
votes
2answers
88 views

SQL Server - Log file not shrinking in AlwaysOn group

We have three-node AO setup in SQL Server. Primary node, one secondary node in Sync mode and another secondary node in Async mode. Main Database on Primary node, log file-size is 434GB, Used 99.91%. ...
0
votes
0answers
30 views

Insert Missing Data in Slave Database

We have a master slave replication [MySQL 5.6]. However In slave database 2 rows is missing in one table. I've tried to solve this using Percona Toolkit as suggested here. But pt-table-checksum ...
-1
votes
3answers
89 views

SQL Server Always On Availability Group [closed]

I have problem with MS SQL Always On Availability. Suppose the connection between primary and secondary replica is broken. The client inserts data to the primary database (replication cannot be done ...
0
votes
0answers
33 views

I'm using Transaction Replication and some commands are deadlocking on the subscriber, do I need to re-initialize replication?

I'm trying to understand the nuts and bolts of transactional replication and I have a few questions: 1) If a subscriber command fails to replicate, where is this logged? 2) How am I notified if a ...
4
votes
1answer
55 views

Generating Error when data size is larger then max text repl size

I recently ran into an issue with where an application tried to do an insert with data over the max text repl size. this time the failed insert was captured by the application log, and I was made ...
0
votes
0answers
41 views

replication & load balancer with postgresql configuration

I configured a master-slave replication server with postgres 9.6 following this doc and all worked fine. When I make changes on master server immediately are replicated to slave server and I cannot ...
2
votes
0answers
37 views

the mystery of the table showing up in the subscription, but not in the publication

TL;DR: This question refer to sql server 2016, transactional replication I've got a table that shows up in the subscription but not in the publication. Here are the details: In one of my servers ...
0
votes
0answers
38 views

How would you move data for only the tables that exist in the destination?

I have Database A (which has Tables a, b, c, d) on Server1 and Database B on Server2 (which has tables c, d, e, f). The tables are added/edited/removed at both locations randomly and may change at any ...
3
votes
1answer
113 views

Is it normal for Snapshot Replication job to be constantly running?

Our SQL Server 2016 already has Merge replication running successfully for some tables in 2 databases. We then needed to restore Snapshot replication for another set of tables between same pair of ...
1
vote
2answers
113 views

Do long-running and locking queries on subscriber databases cause performance issues on the publisher dbs?

One of our servers has a subscriber database. I've not used replication before and cannot find information on how the mechanism works. Does the publisher have to wait on the replication completing ...
0
votes
1answer
77 views

MongoDB Replica Set Sync data by Copying Data Files from Another Member

I used MongoDB 3.6 and was following MongoDB documentation: https://docs.mongodb.com/manual/tutorial/resync-replica-set-member to do a full copy of data from Primary node to another mongod instance....
2
votes
2answers
64 views

Failover strategy for SQL Server 2016 Standard Edition

I am using SQL Server 2016 Standard Edition. I have two database servers, SQL01 and SQL02 with only one database, and I am utilizing transactional replication for bringing data from SQL01 to SQL02. ...
0
votes
2answers
92 views

MongoDB Replica Set InitialSyncOplogSourceMissing error

I am setting up a 3 nodes MongoDB replica set with one node in AWS using Mongo 3.6.12. There are about 400GB data need to sync to secondary nodes. Initial sync starts fine. However, after data sync ...
0
votes
1answer
37 views

NON-Random UUID keys in custom distributed DB

Is there any reason other than security for using random (or even semi-random) UUIDs as primary keys to database records? Is there any reason why I should not WANT to be able to use the UUID to ...
1
vote
0answers
50 views

Do not replicate Delete operations AWS DMS

I am using AWS DMS to replicate ongoing changes with SQL Server as a source and target endpoint. The tasks are running and replicating data with low latency. However, I need the tasks configured not ...
0
votes
1answer
19 views

MySQL replication without baseline data import

I've been reading about MySQL replication and all the resources I've looked at say that a data import (be it a mysqldump, or a raw data dump import) is needed before replication can start. I'm trying ...
0
votes
1answer
35 views

Why pg_wal dir does not clean up while logical replication

my main question - why pg_wal dir is extremely growing up? I have two postgresql instances. The first was set up as master: wal_level: "logical" max_wal_senders: 5 max_replication_slots: 10 Also, ...
-1
votes
1answer
181 views

Connectivity issues in replication process

I've been trying to add a new node to a replica set without success due to these errors: 2019-08-12T06:48:15.031+0200 I ASIO [NetworkInterfaceASIO-RS-0] Ending connection to host mongo03:...
1
vote
1answer
64 views

MariaDB/MySQL SSL Replication Failure

After searching for a solution for the last 6 hours, I have come up dry in my attempt to add SSL to the replication. I managed to get it to connect with SSL via the mysql command line tool without ...
0
votes
1answer
49 views

Add a new node to Mongo Replicaset using Rsync

I have a 3 shard mongo cluster. Each shard has a 3 node replica set. On each shard, the data size is 3 TB. I want to add 1 more node to each replica set. But its taking lot of time. The initial sync ...
1
vote
0answers
26 views

Syncing On Prem SQL Server with Azure SQL

We have a SQL 2016 instance running production systems at a pretty healthy load within AWS. On top of this we host instances of production databases in Azure for PowerBI and analysis usage. At ...
1
vote
2answers
45 views

copy entire PostgreSQL cluster to another (identical) server

I'm looking to clone a PostgreSQL 10 cluster from server1 to server2, which is running the same Postgres version on identical hardware. The purpose is load-balancing and HA. Things to keep in mind: ...
0
votes
0answers
27 views

Oracle Dataguard old sequences

After having set up a dataguard environment with Oracle 12c I notice that when I execute the following command in the primary it shows me the archivelogs: select sequence#, first_time, next_time, ...
0
votes
0answers
52 views

Set slave_exec_mode value for RDS

I am trying to figure out a way to set slave_exec_mode to idempotent on Amazon RDS. I've checked the parameters associated with created DB instance on Amazon Console, but this parameter is not exit ...
0
votes
1answer
36 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
2answers
122 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
1
vote
1answer
613 views

MySQL Replication stuck at 'preparing'

My MariaDB replication stuck at 'preparing'. This happend after an update and restart of the server yesterday. Since then, replication is not working. Setup: 2 MariaDB servers with master-master ...
0
votes
0answers
29 views

Transactional Replication : Issues with Identity Column in Subscriber

I have an Transactional replication set up form Server A to Server B. I have a table which has an Identity column as a primary key. In my publisher ,for the table tb1,the the identity column,Id1 was ...
0
votes
0answers
31 views

How to Un-Break MySQL Master/Slave replication

I had mysql master-slave replication working with mysql Ver 14.14 Distrib 5.7.27 -- totally awesome until it broke. Now, I'm not sure why but I cannot get it to work again. /etc/mysql/my.cnf has: ...
0
votes
2answers
34 views

Oracle 9i to 12c Replication

I have an old Oracle Forms solution that accesses a 9i database and I have been asked if it's possible to replicate to an Oracle 12c database server, with the intention of using Fusion until a new ...
0
votes
0answers
18 views

MariaDB Replication - Missing ^M Characters on Slave

I've got a simple single master->slave replication setup with MIXED binlog format for mariadb 10.2.22-1 on RHEL7. I believe I'm having an issue where '^M' characters in a longtext column are not ...
0
votes
1answer
35 views

Does a read replica help if the problem are heavy queries?

The application that our team is responsible for is having ever more often DB performance problems. The application querying it doesn't throw lots of concurrent queries, the problem we have are rather ...
0
votes
0answers
15 views

In Mysql 8 user creation statements replicating on slave even after using replicate-ignore-db=mysql

Description: ` Normally in mysql replication Data Control Language (DCL) statements won’t replicate into slave if we are configuring replication with replicate-ignore-db=mysql or replicate-wild-...
1
vote
2answers
115 views

Log Shipping Alternative [closed]

In our current environment we have about 40 databases on one instance all being log shipped and configured as Standby/Read Only. About 90% of those are for reporting purposes and others for read only. ...
0
votes
1answer
83 views

Converting MongoDB instance from Standalone to Replica Set and Backing Up

I want to convert my MongoDB 3.6 standalone server to a replica set so I can watch a collection using change streams, which requires an oplog. I only want to use change streams so will keep this as a ...
1
vote
1answer
197 views

SQL Server transactional replication is out of sync

I have setup transactional replication in SQL Server and I am using PULL to retrieve the data from the subscriber. Recently, I noticed that the data in my subscriber is not synced up with the ...
0
votes
0answers
98 views

Errors reading and writing communications packets

After an outage that had us down for 4 days I am attempting to establish replication between 2 of our servers in order to have a "hot" backup available should the need arise. After dumping all of the ...
0
votes
1answer
33 views

Adding subscription for replication in sql server

when i am trying to add subscription on subscriber part in SQL server. error be like : This database is not enabled for publication. Can you please suggest me how to solve this issue.. Note:IS ...