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
6
votes
1answer
56 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 ...
0
votes
1answer
45 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
26 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
26 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
17 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
21 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
13 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 ...
-1
votes
0answers
11 views

MongoDB Replica Set failover with 2 nodes

I have a Replica Set consisting of three nodes: -Server1 (Primary) -Server2 (Secondary) -Server3 (Secondary) When the primary server (still Server1) is down, a voting is started and Server2 get ...
0
votes
1answer
27 views

Unable to create cluster with repmgr for postgrSQL [on hold]

I follow this guide to setup. https://medium.com/@victor.boissiere/how-to-setup-postgresql-cluster-with-repmgr-febc2f10c243 Everythings going fine but when come to here sudo -i -u repmgr rm -rf /...
0
votes
3answers
26 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 ...
0
votes
0answers
31 views

SQL Server replication or Integration Services [closed]

Our team develop a web application Enterprise Resource Planning (ERP) and we install it in all the stores that we have. Which store has its own application and database to prevent the lack of ...
1
vote
0answers
11 views

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 ...
1
vote
1answer
14 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
13 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
30 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 ...
0
votes
0answers
46 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
9 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
20 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
20 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
0answers
21 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 ...
0
votes
0answers
24 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
29 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
22 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
20 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
22 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
25 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
73 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
97 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
16 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
20 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
49 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
23 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
15 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
21 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
18 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
45 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
25 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
327 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 ...
0
votes
1answer
25 views

How to resolve the error for “Alter Subscription disable”?

I have the following subscription for logical replication: pctest1=> SELECT subscription_name, status FROM pglogical.show_subscription_status(); subscription_name | status ----...
0
votes
0answers
53 views

How to start, stop, pause and resume a logical replication setup in PostgreSQL using PgLogical?

I have a publisher node on on-prem 9.4 and subscriber node on RDS version 10.6 and few tables are configured for replication. The current status is replicating. Now for my learning, I want to stop the ...
1
vote
0answers
30 views

Restart a GTID Based MySQL Master-Master Replication

I can see many good articles around the web about setting up MySQL Master-Master Replication with GTID. However, strangely enough, I simply can't find the same about in how to stop and start it. My ...
0
votes
0answers
42 views

Verify if user has replication permissions in Postgres

I am working on streaming changes in my Postgres database using Debezium using the Postgres connector offered by Postgres. However, for the connector to work, the user must have REPLICATION and LOGIN ...
-1
votes
1answer
31 views

SQL Server Database replication from Enterprise to Express version

We need to replicate one of our enterprise SQL Server database to DR site for HA purpose, due to budget reason, we would like to install another SQL Server Express rather than the enterprise or ...
0
votes
0answers
6 views

Rebuilding MySQL Slave from being previous Master with GTID

I have MySQL1 (master) and MySQL2 (slave). Both of them are MySQL version 5.7.26 and GTID enabled. After MySQL1 is broken I failover the master to MySQL2 and this is currently running fine. Now, I ...
0
votes
1answer
22 views

Replication SQL Server to a Cluster with error

I have a source DB MSSQL Server and deploy transactional-replication to a cluster with 2 Node(A&B). The subscriber was added using SQL IP of Cluster and using "sa" account. It run fine when ...
0
votes
0answers
16 views

mssql server 2016 merge replication article properties keep changing after a while

We have on our setup merge replication between two servers running the same versions of MSSQL server. We have some fields of the geography datatype and we fix that by converting filestream to nvarchar(...
1
vote
1answer
28 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
1
vote
1answer
31 views

SQL Replication components install in 2016 standard edition

i would like to install the components of Replication in sql server where the initial installation version is 2016 standard with SP1 (KB 3182545) - 13.1.4001.0 but now the SQL version is 2016 standard ...
0
votes
0answers
27 views

Transaction Replication - re-initialization the subscription after changing an article's structure

I'm using SQL Server 2014 SP3CU2 Enterprise Edition. I have a transaction replication on a DB with some very large tables. I needed to change the structure of a column on one of the tables that were ...
0
votes
1answer
31 views

Solution for a readonly copy of a standalone MongoDB server

I store some data in many databases/collections on a standalone MongoDB server. This server is used for production. I need to access those data (or at least nightly build data, and not all databases/...