Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
88 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
219 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
99 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 ...
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
267 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
112 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
32 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 ...
2
votes
0answers
90 views

CREATE TABLE AS SELECT with GTID

I am trying to migrate to MySQL/Percona server 8.0 and GTID based replication and have stumbled upon the issue where CREATE TABLE AS SELECT is not allowed using GTID. The tables that are created are ...
0
votes
1answer
53 views

How can I decrypt data on a replicated MSSQL database?

I have a database which uses a symmetric key to encrypt a credit card field. There is a trigger on the credit_card field which runs every time it is updated, to encrypt the contents, and save it to ...
0
votes
0answers
30 views

Forgot to add a table in Transactional Replication : Initialize with backup

I have a transactional replication(with initialize from backup) setup in my server. So i setup replication as below: Used full backup(publisher database full back is scheduled every night) from the ...
0
votes
1answer
116 views

MySQL with Glusterfs Storage vs MySQL replication with hostPath storage

I am trying to search right road in a project. We have currently three nodes openshift cluster(okd 3.11) and deployed MySQL with Glusterfs storage. its working fine but look like over engineered to ...
0
votes
1answer
93 views

Mongo replication sync to newer version

I got one mongo v2.4.10 server with 1.7TB data, I am trying to migrate and upgrade the mongo to mongo v.3.0.15 server I've setup a new mongo v.3.0.15 and configured replication for v3.0.15 to be ...
0
votes
1answer
35 views

Transactional replication Issue

I am getting this error when i try to create a new publicaton in dbserver-1 after reinstalling SQL Server in my database server 2. Msg 18482, Level 14, State 1, Line 1 Could not connect to server '...
0
votes
0answers
15 views

Availability Group Replication issues: Distributor (named instance) and Publisher (default instance)

Following the documentation provided (Configure replication with availability groups - SQL Server Always On | Microsoft Docs) I set up an AG-based Distributor (REPLAG) and an AG-based Publisher (PUBAG)...
0
votes
0answers
11 views

SQL Server 2014 Replication Subscription Sync

I have SQL Server 2014 Replication set up. It is my understanding that when you add a new subscription that it will truncate the table and re-insert/re-initialize the tables you are subscribing to. ...
0
votes
1answer
31 views

How can i replicate many database into one, by avoid primary key collision?

I have n number of databases and I have to collect data from those into one database. The databases has some specific value (e.g. currencies) which I want to update from the collector database(of ...
0
votes
0answers
35 views

Start replication again from crashed MySQL master

I am messing around with MySQL replication trying to learn about it and have ran into a snag that I can't seem to find the solution to. I have a local instance of MySQL running as Master and a remote ...
0
votes
0answers
64 views

Data integrity in one-to-many distributed architecture

We are a retail shop that has a central data repository which collects data continuously from geographically distributed 1500 odd servers (each store has one SQL Server instance). Like a one to many ...
0
votes
0answers
35 views

MariaDB Galera + Replication (GTID error)

Using MariaDB 10.2.25 + Galera with 3 masters All Masters have binlogs active Want to switch the Master_Host of an external salve (also running MariaDB 10.2.25) to a different Master. Replication is ...
1
vote
1answer
29 views

Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database

We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says Column mycolumn in object mytable contains type Date, ...
1
vote
0answers
190 views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
0
votes
1answer
148 views

PostgreSQL logical replication slave - shouldn't it be read-only and available only for subscription updates?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on a second server. It also has 21 rows. They both have this row: tinker=# table ...
0
votes
1answer
87 views

PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on second server. It also has 21 rows. They both have this row: tinker=# table ...
2
votes
1answer
21 views

Is it possible to create AWS RDS as replication from external server?

I can't find any tutorial to create a new instance of AWS RDS (MySQL) to be an replication db from an external db server. Is it possible to create one? Thanks.
1
vote
1answer
45 views

Postgresql Vacuum and replication

I have an architecture of cascading replication with 3 postgresql db Because the master is becoming too big (~ 170Gig), I wanted to run a "cleaning" job over the week-end that would do multiple ...
0
votes
0answers
27 views

Republishing data in merge replication SQL Server

srv1 is distributer and publisher srv2 also is distributer and publisher srv3 subscriber of srv2. I create merge replication and data successfully replicated from srv2 to srv3 However, when ...
0
votes
1answer
475 views

Postgres Logical Replication - “replication slot ”mysub“ was not created in this database”

I have two database servers 192.168.150.210 and 192.168.150.220 I created publication and subscription successfully for logical replication. postgresql.conf file is modified on both servers. ...
0
votes
0answers
27 views

Memsql replication fails - master not reachable

I'm trying to replicate a database between two Memsql clusters residing in the same local network. For doing this I'm using the following command: REPLICATE DATABASE my_db_name FROM master_user:'...
0
votes
1answer
26 views

What will happen if master goes down in peer to peer replication?

In case of Peer to peer replication, if Master goes down, will the other two nodes continue synchronizing or not?
2
votes
0answers
19 views

Is binary log purging done by expire_logs_days equivalent to PURGE BINARY LOGS?

In a MySQL replication environment where replication is done with binary logs, if you run PURGE BINARY LOGS on the master, the server will not delete logs that are currently being replicated by a ...
3
votes
2answers
76 views

Distribution database corrupt - What to do?

The below error message has been received from one of our SQL Server databases: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6847f47b; actual: ...
0
votes
1answer
298 views

wal_level both hot_standby and logical

I have a PostgreSQL setup with one master and three slaves. It's configured as streaming replication. Now, I want to replicate only a few tables from the master server to an analytic server using ...
0
votes
1answer
36 views

SQL Server replication: can I modify contents of a snapshot?

I have a merge replication which I was unfortunate enough to start modifying, in a way that required the subscriptions to get re-initialized. It makes very good sense and all, since I was touching ...
0
votes
1answer
25 views

Fail-over or switching the Reporting server database

I have two databases in server, dbs-01.One is a transactional database and a reporting server database.Reporting is minimum,that is why we have it together in the same instance. I have transactional ...
0
votes
0answers
36 views

MySQL Replicated table: How can I prevent a trigger chain?

I've written a trigger to log updates on a replicated table. The trigger inserts into a separate table. We use MIXED replication which defaults to statement-based. The trigger spins around and ...
0
votes
0answers
20 views

using Federated tables for different data sources

We are planning to create a standalone MySQL server specifically for Federated tables that points to 4 DB instances. Sample table: federated_db1_users federated_db1_transactions federated_db2_users ...
0
votes
0answers
244 views

error occurs when starting mysql group replication

With MySQL 8.0.15, I tried to set up the group replication according to the manual(not all the same steps), but the errors occurred. Maybe I missed some details. I was trying to set up the first ...
2
votes
1answer
43 views

SQL Server Replication and Recovery Model

In SQL Server for Replication when recovery model is not very important then how it saves the transactions and also keeps the secondary instance in sync? I tried to check on MSDN and found the ...
0
votes
0answers
56 views

Bidirectional Publish/Subscribe with PostgreSQL

With PostgreSQL, I can set up a publication and subscription between two databases and the subscription will duplicate the contents for the published table. What I found interesting is that the ...
0
votes
0answers
89 views

Postgresql - Can we create streaming and logical replication replication from same server

I have a postgresql setup with 1 master and 3 slaves. Now I want to setup a replication for only one database to reporting server. My problem statements: I can't use bucardo (no approval for ...
0
votes
0answers
24 views

Moving Replicated database in SQL Server Transactional Replication

I have a scenario where I need to move the published database (Transactional Replication) to another server, which is having upgraded Windows and SQL Server installed. Current config is: Windows 2012 ...
0
votes
2answers
76 views

Transaction Replication as DR solution

I have a production database server and a failover database server set up. All the transactions from the primary production db server is being replicated(transactional replication with initialize ...
0
votes
1answer
60 views

MariaDB replication failure: Fatal error 1236 - binlog shows 'Event truncated'

Disclaimer: I am not a certified DBA I have configured MariaDB Master - Slave replication and everything was working but now have an error that I cannot get past. I have run the following on the ...
5
votes
2answers
192 views

DBCC SHRINKFILE on the distribution database

I have an .mdf file from distribution database which is growing. I know the advantages and disadvantages of shrinking database/files. Is it okay to shrink the .mdf file to some a smaller size. Is ...
0
votes
1answer
42 views

-skipErrors in Transactional Replication not happening

I have set up a transactional replication initialized using backup for a big database(1.6TB).Due to some error(space issue in the subscriber) the replication was not happening and there were ...
0
votes
1answer
35 views

change master to cause 1364

ip addr|grep inet inet 192.168.8.47/24 brd 192.168.8.255 scope global ec1 inet 192.168.8.45/24 brd 192.168.8.255 scope global secondary ec1:1 I got like this mysql> show slave status\G; ******...
1
vote
2answers
161 views

MongoDB replica set quorum config (network partitioning behaviour)

I use mongodb 4.0.10. I want to establish a quorum for a cluster of one primary node and two secondary nodes as written here. When the number of nodes is less than the quorum, 3 nodes in my case, ...
0
votes
1answer
12 views

resuming server replication on PostgreSQL servers

I got one main server and other two servers are replicating from the main. I got full disk space on the main server (I have an archive_command that put wal archives into the /wal_archive/ directory). ...
0
votes
1answer
70 views

What's the best way to maintain a writable DB slave which is always overwritten by the master?

I need to replicate our main server's databases (MariaDB) to a local server in our office, which will be used as an offline mirror when we have connectivity issues. The data on the master should ...