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
2,819
questions
0
votes
0answers
3 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
14 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
10 views
How to change the replication user in Pglogical without breaking the replication?
if_id | if_name | if_nodeid | if_dsn
-----------+---------------------+-----------+--------------------------------------------------------------
440218642 | ...
0
votes
1answer
31 views
Accessing Administrative share using Listen 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
15 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
33 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
21 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
39 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
21 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
63 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
11 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
40 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
9 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
32 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
37 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 ...
2
votes
0answers
22 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
72 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
26 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
53 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
1answer
27 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
34 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 ...
0
votes
0answers
10 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
15 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
18 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, ...
0
votes
1answer
27 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
26 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
22 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
19 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 ...
0
votes
0answers
32 views
Replicate SQL Server 2008 across domains
I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, ...
1
vote
2answers
32 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
20 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
28 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
26 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
1answer
46 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
242 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
18 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
12 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
21 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
15 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
24 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
12 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
77 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
19 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
37 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
38 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
28 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 ...
0
votes
1answer
22 views
Can replicated commands be forced to follow each other in transactional replication?
We have transactional replication setup between an SQL Server 2012 box and a SQL Server 2016 box.
Every half an hour the source table articles are altered by DELETE then INSERT sequence. This ...
0
votes
1answer
47 views
mongodb - Replica set creation error: Quorum check failed because not enough voting nodes responded
I am configuring a mongodb replica set. From my current primary node, when rs.add('host1:27017'), it yields this error
Quorum check failed because not enough voting nodes responded; required 2 but ...
0
votes
1answer
33 views
Multi Master replication vs Single-Master performance
I'm trying to wrap my head around a hypothetical scenario.
Imagine we have a very write-heavy distributed database and sharding is not an option.
I wonder if / how is multi-leader replication (...
0
votes
1answer
30 views
Questions around migrating to a live replicated database from an existing log shipping database in SQL Server 2016 SP1
I have two large databases, one on my production server named S1 and the other on my reporting server named S2.
S1 is the live database used for our customer orders and accounting, and S2 is the ...
