Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. 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
2answers
13 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
15 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
16 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
14 views

Getting Connection Error on MySQL5.1 to MySQL8.0 ROW Based One Way Replication [on hold]

Trying to replicate MySQL5.1 to MySQL8.0, when running starting the slave on MySQL8.0, I get [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'rep_user@XXXXXXXX.YYY:...
0
votes
0answers
15 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
27 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
17 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
17 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
0answers
11 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
20 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 ...
2
votes
0answers
46 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 ...
-2
votes
0answers
12 views

PG database logical replication outof memory issue how to fix with good configuration?

PG database logical replication out of memory issue how to fix with good configuration? Which is better option for database replication - active /standby? We want to replcate data from source ...
0
votes
1answer
90 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
15 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
45 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
10 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
13 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
16 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
17 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
23 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
23 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
260 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
22 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
36 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
20 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
32 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
25 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
20 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
25 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
30 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
25 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
28 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/...
0
votes
1answer
68 views

How we can we know SQL Replication components installed in SQL server

Can somebody please let me know how can we identify whether Replication components installed in SQL server. Tried below: 1.we had changed the server name earlier so while checking with configure ...
0
votes
1answer
19 views

Is it necessary to archive master WAL files in order to implement streaming replication in postgresql-11?

The documentation at: https://www.postgresql.org/docs/11/warm-standby.html#STREAMING-REPLICATION Starts out by saying that: "Streaming replication allows a standby server to stay more up-to-date ...
1
vote
1answer
52 views

Selecting specific table for each subscriber when using merge replication in SQL Server with multiple subscribers

I am using merge replication with SQL Server 2017. I have one publisher, and two subscribers (all in all 3 database servers). I need to replicate different tables to each subscriber. Is this ...
0
votes
0answers
19 views

Database synchronization 2 times a day -MariaDB

I have 2 different servers. The first one is server1 and the other is server2. On servers, one works for websites (server1) and the other for mobile applications (server2) for security purposes. I ...
10
votes
1answer
202 views

What is a “hashed transaction” in SQL Server Replication terminology?

sys.dm_repl_tranhash contains information about the hashing of transactions, but I have difficulties understanding the terminology. What is a "hashed transaction"?
0
votes
0answers
23 views

Is it a good idea to have a read connection point to both write database and read replica?

In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
1
vote
1answer
31 views

SQL Server 2016 Standard Edition Replication

I have a single database running on SQL Server 2016 Standard edition in our primary datacenter. I would like to keep a live copy as close to realtime (1-2 minutes) in our disaster recovery datacenter ...
0
votes
1answer
14 views

Relay log read fail, relay or master log currupt ,How to repair?

I am running mysql InnoDB cluster 8.0.17(group replication) During the repication the slave disk gets full and no space left at all the thread waits for the disk space to be freed at the same time ...
0
votes
0answers
24 views

Migrate a legacy application that uses MySQL replication

I have been working on the migration of a legacy ecommerce web application to a new server with far hardened security. I have found an aspect with the MySQL server that I am not acquainted with and I ...
0
votes
0answers
15 views

How to change the replication user in Pglogical without breaking the replication?

if_id | if_name | if_nodeid | if_dsn -----------+---------------------+-----------+-------------------------------------------------------------- 440218642 | ...
1
vote
1answer
41 views

Accessing Administrative Share Using Listener Name

Can a SQL Server AG listener name be used to access an administrative share i.e \\DB-listener\c$\Somefolder? I can RDP using the listener name but can't use the listener name to access the $ ...
0
votes
0answers
51 views

PostgreSQL 10 logical Replication not working !!! slots blocking calls not sending wal events back to client

Postgres logical replication not working we have created logical replication slot on pg 10 using below command select * from pg_create_logical_replication_slot('slot', 'wal2json'); Above request ...
2
votes
1answer
46 views

Which are the downsides of not deleting the CDC records in change tables?

If I do something like this: USE AdventureWorks2012; GO EXECUTE sys.sp_cdc_change_job @job_type = N'cleanup', @retention = 52494800; -- (100 years) GO The records in the change ...
0
votes
0answers
76 views

logical replication in postgresql - “server closed the connection unexpectedly”

I'm running two postgresql servers and I'm trying to setup logical replication. These are extra bits of configuration I added on master in order to make replication work: wal_level=logical ...
0
votes
2answers
63 views

SQL Server - Log file not shrinking in AlwaysOn group

We have three-node AO setup in SQL Server. Primary node, one secondary node in Sync mode and another secondary node in Async mode. Main Database on Primary node, log file-size is 434GB, Used 99.91%. ...