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
0
votes
0answers
7 views
add new dc to existing cassandra cluster
I have added a new DC to my existing cluster following cassandra document https://docs.datastax.com/en/cassandra/3.0/cassandra/operations/opsAddDCToCluster.html.
When ı run nodetool status keyspace, ...
1
vote
1answer
15 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
25 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
37 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
17 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
12 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
20 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
5 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
8 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
38 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
21 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
26 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
31 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
27 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
44 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
26 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
32 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
33 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
26 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
27 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
81 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
44 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
87 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
33 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
31 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
42 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
58 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
18 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
22 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
19 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
30 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
58 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
0answers
16 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 ...
0
votes
0answers
51 views
Automate Replication Scripts
In SSMS, one can "Generate Scripts..." to Create or Drop Publications and Subscriptions and Distributor configurations. Is there any way to do this automatically?
We have several people on the DBA ...
2
votes
0answers
53 views
Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?
Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle?
What if the publisher database is in PostgreSQL?
If ...
0
votes
1answer
21 views
MySQL replication with no connection
I configured MySQL replication between a Master and a Slave throught VPN.
Everything works fine, when connection between them is down, and i make some changes to the Master (like insert a row), then ...
1
vote
0answers
32 views
Mongodb won't start after adding 2nd net option to mongod.conf file
I try to add another net with the its corresponding bind ip and port to my AMI ec2 mongod.conf file so I will be able to create a 2 node replica set but when I run the command "sudo service mongos ...
1
vote
0answers
25 views
Changing Postmaster File Name in PostgreSQL
I have two instances of PostgreSQL with master-slave replication between them and want to use GlusterFS. Everything works fine until the second instance wants to store the data in the GlusterFS. ...
0
votes
0answers
17 views
Replicate multiple server databases to single slave server
I have several databases in several locations running with MySQL 5.7.25. Now i want to replicate all these databases to single server.
Master database servers (All databases are with same name)
...
0
votes
1answer
12 views
Problem in PostgreSQL replication - ALTER DATABASE
Recently I put to work a Master/Slave replication in my PostgreSQL (9.3). Everything is ok... insert, update, delete, in data and changes in tables... but when I changed the data base name the ...
0
votes
0answers
40 views
Sync PostgreSQL with Cloud and multi Local Locations
I need help with a complex (for me) multi server setup with PostgreSQL.
I have to setup a Cloud Server and 3 Local Servers for our company.
Each Server will have:
Linux Ubuntu 16.04
Docker
...
0
votes
0answers
74 views
ERROR 1794 (HY000): Slave is not configured or failed to initialize properly
This is my my.cnf file:
[mysqld]
server_id = 1
log_bin = /var/log/mysql/mysql-bin.log
log_bin_index = /var/log/mysql/mysql-bin.log.index
relay_log = /var/log/...
0
votes
0answers
21 views
MySQL slave connect to master error_code 2005
I have a master running MySQL 5.6.17 on Windows 10, and a slave running MySQL 5.7.25 on an Ubuntu 17.10 box on a (Windows) LAN.
Replication ran fine until Ubuntu upgrade to 18.04. Now slave ...
0
votes
0answers
31 views
Postgres ALTER TABLE xyz REPLICA IDENTITY FULL
I am trying to alter a table in a database with (postgres 10.6)
ALTER TABLE xyz REPLICA IDENTITY FULL;
However, the command does not return. Is there any way to diagnose what the issue is, or any ...
0
votes
1answer
25 views
Mysql replication rebuild dump database lock
I need to rebuild master-slave replication of whole instance of mariadb on innodb. What I often see is that people do read lock then dump master then unlock, like:
FLUSH TABLES WITH READ LOCK;
SHOW ...
0
votes
1answer
17 views
Microsoft SQL secondary read-only DB for SSRS?
I know that Microsoft SQL has AlwaysOn with a read-only secondary replica. However the cost of enterprise edition for all of our SQL servers makes this not possible. We have SSRS configured to run ...
0
votes
0answers
15 views
Why are the heartbeat message not getting sent? streaming replication - postgresql
I working on logical streaming replication on Postgres. My streaming client is gracefully receiving all the WAL message..
Except for the heartbeat/Primary keepalive message which is mention in the ...
0
votes
0answers
22 views
Why is restart_lsn not set, even on checkpoint - postgresql
A logical slot will emit each change just once in normal operation.
The current position of each slot is persisted only at checkpoint, so
in the case of a crash the slot may return to an earlier ...
-1
votes
1answer
21 views
Automate setting secondary node to primary when majority nodes are down-MongoDB
There are many ways to force a secondary node to become a primary when majority nodes are down in mongo replica set. But we need to do this manually. For eg, forcing reconfig:
cfg = rs.conf();
cfg....
1
vote
1answer
20 views
changing domain name for Mongodb primary
Im trying to initialize my replica set sp that the primary node has a specific domain:port pairing. what I want is:
"vagrant-ubuntu-trusty-64:27022"
but what I get is:
"localhost:27022"
This ...
