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
1answer
110 views

T-SQL for starting Log Reader Agent

I am facing a problem regarding SQL Log Reader Agent. Whenever, I start SQL Server Agent, Log Reader Agent does not start. I have to start manually. Do I have start Log Reader Agent manually every ...
0
votes
1answer
42 views

MySQL Replication using GTID

I want to create MySQL replication using GTID. According to MySQL Manual I need the following settings in my.cnf (for the master) server-id = 1 log_bin = /var/log/mysql/mysql-bin.log ...
-1
votes
1answer
78 views

What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]

A 3 member replica set has the same fault tolerance if all 3 members contain a copy of the data or if one is an arbiter so why would I ever want all 3 members to have a copy of the data? What is a ...
0
votes
1answer
29 views

Error on PostgreSQL streaming replication

I have the exact same problem as Wal segment still exists on master, but logs on slave and master say it's been removed except that it is in Production ! PostgreSQL 9.4 / Debian Jessie ...
0
votes
0answers
76 views

Physical and logical replication slots on Postgres (same time)

I wonder if it's possible to have a setup when changes from a single Postgres master streamed to two (or more) replicas same time, but some replicas to use streaming (logical) replication and some to ...
1
vote
0answers
119 views

PostgreSQL logical replication and partition table

We have a large database and we want a copy of the database in our company for faster access. we are going to achieve this copy by logical replication on PostgreSQL 11. But we have a big problem. We ...
0
votes
1answer
20 views

MYSQL Read Replica Bottle Neck

If my MySQL master has heavy writes, my read replicas will in-turn gets bogged down by the replication logs & executing them. Then could it serve the reads? Assume MYSQL master is executing at ...
0
votes
1answer
32 views

when is it necessary to create aliases in the SQL Configuration Manager?

I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager I see there are aliases. I was wonder why ...
0
votes
1answer
25 views

Recommended replication strategy for fast global access to MySQL DB

The app i'm working on has users from all over the world and due to the nature of the app, i need to minimize all delays. My application servers are located in different data centers across the world ...
0
votes
0answers
16 views

Replicate a db containing encrypted fields

We've been using aes-256-cbc in our code for some table fields and storing the encrypted strings in our DB to make sure that the data at rest is encrypted. Just a peep into what we do for the ...
0
votes
1answer
63 views

Master Master replication rows not sync properly

I have a wordpress website that run on 3 machines Machine1 | Machine 2 {nginx+lsyncd+mysql} visitor > cloudflare > haproxy ------ ...
0
votes
2answers
66 views

SQL Server Replication, is it possible to have “upload only” syncronization on some articles?

Within SQL Server's merge replication, I know how to make publication's article download-only (either with update restrictions on subscriber database or not) - @subscriber_upload_options parameter in ...
0
votes
0answers
40 views

SQL Server Merge Replication, dealing with existing tables

I have publisher and subscriber databases with identical schema, while some of the tables participate in replication and some don't. In some cases it is possible to have tables that have referential ...
1
vote
1answer
79 views

How to read/write from replicated slave in case master went down in SQL Server?

I've created a transactional publication in SQL Server, now my requirement is to write on master and read from subscriber and in case of master going down for some reason, the subscriber should act as ...
1
vote
1answer
47 views

MySQL - applying same binary log

Quick question - if I apply same binary log multiple times via: mysqlbinlog --start-position=xxx mysql-bin.xxxx | mysql will the server understand and omit previously applied changes or further ...
1
vote
1answer
103 views

Only SQL Server Enterprise Edition supports compression - how to work around that?

I have a script that needs to create a temp table and in that temp table I create an index. I noticed in some of my servers, the script would go on forever, and when checking from a different session ...
1
vote
0answers
259 views

MongoDB ReplicaSet instance re-join after Kubernetes POD restart

I have simple MongoDB deployment in Kubernetes with PersistentVolumeClaims. Roughly like this: apiVersion: v1 kind: Service metadata: annotations: service.alpha.kubernetes.io/tolerate-unready-...
0
votes
1answer
120 views

Multi-master (NoSQL) database solutions with cloud and no-premise option

We are currently investigating database options for distributed database (possibly globally distributed) where the data in general is stored in "cloud" (this would not be a special requirement). The ...
1
vote
1answer
239 views

Replicaton - The current transaction cannot be committed and cannot be rolled back to a savepoint

After creating a replication publication, I go ahead and create a subscription using the script below: -----------------BEGIN: Script to be run at Publisher 'MY_PUBLISHER_SERVER'-------------- use [...
1
vote
0answers
46 views

SQL Server replication - Could not add new article to publication

I have following script for replication that I am running in source database (subscription is not added yet, target database does not exist yet in target server): use [myDatabase] exec ...
0
votes
1answer
134 views

mysql - can a slave have a different primary key than the master?

I have a table with PRIMARY KEY (`id`) and I want to change it to PRIMARY KEY (`username`, `id`). These columns are defined as: `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` ...
0
votes
0answers
75 views

How to reset Maintenance User password in Replication Server version 15.7.1

I am going to reset a Sybase ID (abc) in my primary data server (pubs1). This ID abc@pubs1 is used as my maintenance user when I setup Replication Agent for pubs1 in my replication server. If I am ...
0
votes
1answer
35 views

Are Snapshot files created during MS SQL replication one time use only?

I added a new article in an existing publication. I saw that it generated a new snapshot folder (E:\Database\Snapshots\unc\S749TCAPDB01_NFS_XXXX_XXXX_PUBLICATION\20190417114556). But this folder ...
0
votes
1answer
38 views

AlwaysOn availability group and Replication - expected behaviour

I'm currently doing a bit of testing with alwayson and replication. I currently have the below: Fully working cluster and Always on environment; DCTEST1, DCTEST2 and the listener name DCTEST_L. The ...
0
votes
0answers
6 views

WebSync Replication over HTTPS URL between SQL Servers on Cloud and on Intranet behind Proxy

I have a SQL Server instance running on company intranet behind a web proxy server. On cloud, I have an other SQL Server instance. I tried to implement WebSync method using replication between these ...
0
votes
0answers
96 views

ERROR: cannot update table “pg_enum” because it does not have a replica identity and publishes updates

I was trying to update the enum label using the following SQL query UPDATE pg_enum SET enumlabel = 'Cash Recivied' WHERE enumtypid = '1203702' AND enumlabel = 'Cash'; but it throws an error ERROR: ...
1
vote
0answers
46 views

MariaDB Galera slave thinks it's replicating, but it isn't

I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases. SHOW ALL ...
0
votes
0answers
32 views

Synchronizing for reporting, SSIS job vs Transactional replication or other options?

We're faced with a fun challenge. A server has 60+ databases to segment data due to privacy and security. We have 7 tables in each of these databases that need to be merged into a master dataset for ...
0
votes
2answers
40 views

Mongodb users in replica

1) I have mongo instances A, B and C, each having a different set of users with different roles. I have used mongo shell to connect with A through an Admin user. Now, to create a replica and add B and ...
0
votes
1answer
463 views

PostgreSQL + Citus - multi master - replication of data

I have a question, I have found a Citus extension which is recommended for a replication of data between multi-master nodes (I was using Galera Cluster prior to PostgreSQL). However I cannot find any ...
2
votes
1answer
183 views

Microsoft Sql Server - How to replicate a table from Linked Server?

I have an Origin Database - #1 with very restrictive access due to security. I provisioned a new Windows desktop machine with Microsoft Sql Server Management where I created a local database with all ...
1
vote
2answers
214 views

Parallel replication is not working on a 5.7 slave from a 5.7 master

Note: Following are the parameters that we turned ON on the 5.7 replica for parallel replication to happen: slave_preserve_commit_order = 1 slave_parallel_type = LOGICAL_CLOCK slave_parallel_workers =...
0
votes
0answers
28 views

Configure Availability Group in SQL Server 2016

Can you tell me how you add the second node as the replica to the AG? I am using this feature on AWS instances, I have followed all the steps as shown in different videos, but when I try to add the ...
0
votes
1answer
160 views

Added New Subscriber but Replication Not working

I have one Merge Replication setup with one Publisher and 5 to 6 Subscribers. We have added one additional subscriber to this replication and when we try to sync it's giving the following error. ...
0
votes
1answer
160 views

Logical Replication: Schema does not exist while subscription

PostgreSQL logical replication. I am trying to replicate the tables from server 1 to server 2. In Server 1 create publication locale for table code.locale_cd; CREATE PUBLICATION In Server 2 ...
0
votes
0answers
63 views

Postgres replication delay with inserts into large table

I have a large table (over 35 million rows, most rows contain TOAST'd columns) that I've isolated as the source of growing replication delays in my Postgres instance. When I'm doing inserts into this ...
1
vote
0answers
139 views

MongoDB SECONDARY replica keeps failing on STARTUP2

I'm converting standalone existing MongoDB instance to a replica set for backing up without affecting primary instance. To test minimal replica deployment I've set up two MongoDB instances on the same ...
3
votes
0answers
305 views

MySQL RDS Incompatible Restore while creating read replica

We have multiple m5 generation MySQL RDS instance. The problem we are facing is that while creating read replica for these instances we are repeatedly getting 'incompatible-restore' error. In the ...
0
votes
0answers
99 views

Transactional replication from Oracle PL/SQL to MS SQL Server broke from the data in a Date column but previous records with same date are ok?

I have a heterogenous transactional replication subscription setup between PL/SQL (12C 12.1.0.1.0) and SQL Server (2008 R2), where the Oracle PL/SQL server is the publisher and the MS SQL server is ...
3
votes
1answer
130 views

how to prevent replication to stop if there is no activity for some time?

On one of my transaction replication publications, when there is no any activity, after some time, the replication stops. Where can I see these replication settings? what to put in place to prevent ...
1
vote
1answer
70 views

Much slower replication on Innodb compared to myisam

Good morning. I wanted to test how InnoDB will work on my servers and for this I made a slave and connected it to my master with myisam. The problem is that when the slave works on innodb, replication ...
0
votes
1answer
37 views

Mongodb creating historical cluster replicaset

I've a use case which I'm trying to implement.. There is a replicaset(3 nodes) which is primary production cluster, I want to set up a historical cluster another replicaset(3 nodes) which replicates ...
1
vote
1answer
441 views

PostgreSQL: pg_rewind complains about wal_log_hints = on not been set, it is

I'm rather new to pg so please bear with me. I've set up two hosts and installed pg10 on both. Then I configured log streaming replication between them. This worked fine. I wanted to test fail over,...
0
votes
3answers
214 views

Best solution for PostgreSQL partial table replication

We have the following architecture of our system (PostgreSQL 9.6 is used on all servers): 1. there is a bunch of little servers ("sensors") storing data in some table 2. there is a big server ("...
0
votes
1answer
199 views

Create publication is not working in PostgreSQL

I am trying to create a publication (for logical replication) in PostgreSQL database but it throws an error: indsolv_dev=# CREATE PUBLICATION my_publication; ERROR: syntax error at or near "...
0
votes
1answer
49 views

Maximum number subscribers node in PostgreSQL logical replication?

Does anyone know what is the maximum of subscriber nodes with PostgreSQL 11 logical replication ?
1
vote
1answer
25 views

Do postgres autovacuum properties persist for DB replications?

I would like to understand postgres replication options more, and as I am doing my research, I have come across a concept of autovacuuming in efforts to create routine DB maintenance. My question is ...
2
votes
1answer
146 views

Logical replication - Manually triggering update of data on destination tables (after schema change)

I'm testing out Logical replication on Postgresql (10.4 at the moment) with a quite specific use case. I have some central DB (publisher) from where I need to replicate few tables to distributed DB's ...
0
votes
1answer
286 views

Replication or Sharding (MongoDB)

I understand each of the terms but I do not understand very well if they can work simultaneously. In my case, for example, I have a machine with 20GB and I would like to know which is the best ...
0
votes
1answer
35 views

Different CREATE_TIME for tables in Master and Slave

We have found that the value of CREATE_TIME column in information_schema.tables for many tables was different in MASTER and SLAVE. Upon going through the logs, it was found that the CREATE_TIME value ...