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
71 views

How to resynchronize replica in Postgresql

I have a server with Centos6 and Postgresql 9.2, I have set up a replica in postgresql to another server of the same characteristics, today in the morning I have an error in the archiver process on ...
0
votes
0answers
101 views

MSSQL - Can not start snapshot agent

I'm trying to setup a replication, but the snapshot agent will not start. It tells me Error messages: Message: Data source name not found and no default driver specified Stack: at ...
0
votes
0answers
180 views

MSSQL - Setting up simple Replication fails

Heads up: I'm a rookie when it comes to SQL Administration. Im seting up a simple MSSQL Replication running server '19 (developer edition). The server and agent services run as local admin on the ...
0
votes
0answers
23 views

How to setup MongoDB replication using openssl keyfile

I am having 3 standalone Mongo servers. All the three had setup using keyFile Security: keyFile: /var/lib/mongo/mongodb.key Now I tried to add these servers into replication set. So I had ...
2
votes
0answers
186 views

SQL Server Replication Administrative Password not working

I have been struggling for the past one week to setup the replication in our environment and has been stuck on Administrative Password issue when adding Distributor on Publisher Server. Important ...
0
votes
0answers
225 views

Help with set up replication distribution database in Always On availability group

After following official microsoft guide and sample walkthrough: https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution-availability-group?view=sql-server-2017 ...
0
votes
0answers
15 views

Merge Replication not deleting unmatched filter rows from Subscriber Database

I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from publisher ...
0
votes
0answers
18 views

Creating subscriber for replication without initialization?

Just wondering - I am sitting here for past 30 minutes waiting for Subscriber to finish initialization for Merge Replication. Could I skip this step somehow? and skip snapshot creation? I have: ...
0
votes
0answers
202 views

Mongo DB : Attempting to initiate a replica set with name rs1, but command line reports rs1; rejecting

MongoDB Enterprise > rep_cfg = { _id : "rs1", members : [ {_id:0, host:"Server1:27007", priority:2}, {_id:1, host:"Server2:27007", priority:1}, {_id:2, host:"Server3:...
6
votes
3answers
815 views

Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?

I am moving database to new server. New server has SQL Server 2016 running, current server has SQL Server 2008. I need to have backup/fallback plan in place for few weeks (in case something goes ...
1
vote
1answer
146 views

What are drawbacks of setting REPLICA IDENTITY FULL in PostgreSQL table

I want to use the wal2json extension to capture the changes in the PostgreSQL database. I need to find the diff between old and new rows. Having searched the Internet for an answer, I realized that ...
0
votes
0answers
31 views

Data compression at distribution level in SQL Server replication

I have SQL Server transactional replication setup. For one of the server I am facing slowness due to limited network bandwidth. Is there any way to compress data at distribution level only.
1
vote
2answers
65 views

For AlwaysOn AGs, can a secondary replica cause contention on the primary when the resources of the secondary are maxed out?

Is it possible and in what ways can the secondary replica cause contention against the primary replica when the secondary replica's resources are maxed out (e.g. does the primary "lock" up while ...
1
vote
1answer
30 views

Find all tables in a snapshot replication that have primary keys

I've been tasked with moving all tables in a single snapshot replication that have primary keys to the transaction replication. I've tried to break it down into two steps, finding all tables in a ...
1
vote
1answer
184 views

Is there a maximum IOPS for MySQL asynchronous replication on the slave server?

I have been struggling with this issue for a while now. I have a simple Master-Slave setup with MySQL 8.0.15 installed on both systems. In day-to-day operations the slave keeps up the Master with no ...
7
votes
1answer
259 views

Is there a way to determine what kind of data is sitting in the Redo Queue for an AlwaysOn AG Secondary Replica?

Do any of the DMVs or is there another way to expose what kind of data is in the Redo Queue that's in process of being synced up to a secondary replica? (E.g. is it table data and which table, or is ...
2
votes
1answer
1k views

What's the cause for an AlwaysOn AG Secondary Replica to have a high Redo Queue Size and Estimated Recovery Time with a good Redo Rate?

SQL14 is the Primary server, SQL16 is the Secondary Replica, and they're setup using synchronous commit availability mode: As of yesterday it appeared that data stopped synchronizing from the primary ...
0
votes
0answers
42 views

Transactional Replication with 2 subscribers

I have an existing subscriber and want to setup another subscriber but on different machine.So 2 subscribers, 1 publisher I want to initiate it from a backup rather than snapshot but when i try set ...
0
votes
1answer
55 views

Can a subscriber be a publisher at same time

I want to setup a topology for replication. The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher). I then want this ...
0
votes
0answers
18 views

what is the difference between replication options proc exec and definition only?

I understand proc exec option as for example when you run a procedure which inserts 1000 records into table, those insert afterwards will be replicated to the subscriber. When it comes to definition ...
0
votes
0answers
23 views

Is subscription database considered as read-only?

I am not sure about that because while users implement SELECT from subscription database, publisher replicates data to the subscription server meaning that INSERT and UPDATE also take place (which are ...
0
votes
0answers
44 views

Mongodb doesn't respond

We have a sharded cluster with 3 shards. The version is: 3.6.13. The users of the prod. database (1,8 TB sized) complain about an issue. System works normally but after sometime it stucks and doesn't ...
0
votes
3answers
179 views

When does PostgreSQL move a WAL file to archive?

I'm a complete newbie with PostgreSQL - please forgive my gaffs - and have inherited a service using a master-slave cluster at the backend. Currently on the slave, the disk is filling up with WAL ...
1
vote
0answers
46 views

SQL Replication sysarticles Status 57

I am looking at the data kept in the various SQL Replication tables. I am trying to understand what information is available and what it means. In this example I have push replication on the database ...
1
vote
1answer
36 views

Mongodb automatic Replica Set creation with JS driver

The MongoDB docs state that one can use the mongo client console to initialize replica sets by running rs.initiate([config]). However, I don't want to have to manually use the command line for this. ...
1
vote
1answer
15 views

How to make UUID() function, statement-based replication safe?

I'm trying the copy and generating UUID()s on the fly for exiting data when executing A insert from select. How can I make the UUID() function statement-based replication safe? Can I somehow use the ...
0
votes
1answer
38 views

Intentionally slow down importing of (Percona) MySQL 5.7 dump

I need to move a very large MySQL table (250M rows, 120 columns. 120GB of data, 310GB of index) from one database instance to another (on AWS). For reasons beyond the scope of this question, this is ...
2
votes
2answers
943 views

Replication problem in SQL Server 2019

I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message when I run the snapshot agent: 2019-10-30 12:32:41.59 Microsoft (R) SQL Server Snapshot Agent 2019-...
0
votes
1answer
12 views

Writing something then immediately read when using read/write split: how to deal with replication lag

We have an issue where we write to the master table, then immediately must read using the reader. We are experiencing issues with replication lag where the data is not available to the reader at the ...
0
votes
2answers
87 views

Mysql: slave read binlog from local storage

I am running master-slave replication, Can I manually move binlog files from the master server to the slave and make the slave read them locally? I am willing to do so because I am running out of ...
0
votes
0answers
37 views

Mongo primary failover causes rollback

I have a replicaset that processes largish batches of inserts (a few million) every night. Last night, the primary failed over and went into a rollback state. All clients which access this replicaset ...
0
votes
1answer
36 views

MySQL replication still failing after new import

I had an issue with my MySQL replication from Master to Slave. An App we had by mistake wrote to the Slave and deleted some data as well, causing errors during the replication (delete errors, primary ...
1
vote
0answers
76 views

MongoDB: Lost dry run election due to internal error

I am trying to solve a Replication issue here in MongoDB 4.2, but I can no longer get my Primary server back to primary, it always stays in SECONDARY mode. I've tried several types of solutions, like ...
0
votes
1answer
39 views

Is it possible to have more than one replica on a PostgreSQL server?

version: PostgreSQL 11.4 OS: Windows 10 This is an illustration of my question: On 3 different machines there are one primary server per machine. Is it possible to have one common server where ...
1
vote
1answer
75 views

Mongodb - Best Practice for TTL index on huge dataset

I want to create a TTL index for a table. Table size 1.2TB I have a shard infra. Each shard is having 3 node replica set. For creating this index, can I go with the rolling index creation method? ...
0
votes
0answers
23 views

What is the simplest method to get a Readable Copy of the database, one having more historic data

I am hoping to get some input as to what the best replication method/tool would be for my situation. I have to make a new system and the business needs are as follows : They need to have access to ...
0
votes
1answer
120 views

AWS DMS: 2 million CDCIncomingChanges resolved without target throughput

We're attempting to use AWS DMS to replicate MS-SQL to a customer's on-prem DB, and running into a confusing situation. At 13:00 UTC there are over 2 million CDCIncomingChanges, with CDCTargetLatency ...
0
votes
1answer
109 views

How do i disable or limit Postgres Replication creating causing too many WAL files generated?

On AWS RDS PostgreSQL 10.7, I turned on logical replication for a one specific table . on publisher: CREATE PUBLICATION mypublication FOR TABLE <mytable>; on subscriber: CREATE SUBSCRIPTION ...
3
votes
1answer
277 views

Never changing the password for distributor_admin for local instance only?

Per Does distributor_admin need sysadmin? distributor_admin needs SA and per Can the account name of 'distributor_admin' be changed? the name can not be changed. The password is changed with ...
0
votes
1answer
243 views

How to replicate CREATE USER command?

I'm replicating database master to master and everything works ok except for mysql.user table. When I create user in DB-1, that user is not created om DB-2. I have this on both servers in cnf ...
0
votes
0answers
17 views

Master to master using logical replication [duplicate]

Is it possible to create master to master syncing architecture using logical replication in postgres? I have a database at local machine and I want to sync data from local to remote/cloud and from ...
0
votes
0answers
53 views

Router Configuration for HA InnoDB Cluster

I've set up three Ubuntu MySQL servers (18.04 LTS / 8.0.17) in a single-primary InnoDB cluster and have installed mysqlrouter on an application server. With the router’s configuration manually ...
0
votes
1answer
68 views

Best way to replicate MySQL database tables

I'm trying to wrap my head around the many options on how to possibly sync database tables automatically from one database to the next (and next, and next, ...). We're trying to create a very simple ...
0
votes
0answers
81 views

Can't login into MariaDB slave servers

I have set up a master and a slave for MariaDB using the Bitnami docker image. The replication seems going smoothly: MariaDB [(none)]> show processlist; +-----+-------------+--------------------+--...
0
votes
0answers
18 views

Merge replication repeatedly applies snapshot to subscribers

We recently moved our 2008 R2 database to a 2016 server. The compatability level was changed to 2016 on the publisher which is also the distributor. The server uses a merge replication to laptop ...
0
votes
1answer
65 views

how to upgrade postgresql 9.0.4 to latest with minimum downtime

I have master-slave-slave setup for postgresql 9.0.4 in our production setup. We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
0
votes
1answer
25 views

Transaction publication with merge publication

I have a transaction publication setup on SQL Server 2014 lets call it (node A) that replicates to SQL Server 2008 (node B), then I use merge replication to synchronize changes from (A) through (B) to ...
0
votes
2answers
550 views

Multi-Master Multi-Region MySQL Cluster

I am hosting an application (a game) in multiple regions around the globe. Performance is critical to this application since it's a game, and therefore I need to host a database instance in each of ...
0
votes
2answers
45 views

Slave error after master upgrade

I have two MySQL servers in replication (master -> slave). I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now. Last_Errno: 1005 ...
6
votes
2answers
1k views

Postgresql 11 logical replication - stuck in `catchup` state

I'm running two postgresql 11 servers - master and slave (setup with logical replication). The problem I'm facing is that today after weeks of uninterrupted work slave got out of sync with this error ...

1 2 3
4
5
60