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
0answers
4 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 ...
2
votes
1answer
53 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 ...
7
votes
1answer
145 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
0answers
27 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
2answers
123 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
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
1answer
84 views

Postgresql streaming replication slow on macOS

I am using PostgreSQL 10.1 on MAC on which I am trying to set up streaming replication. I configured both master and slave to be on the same machine. I find the streaming replication lag to be slower ...
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 ...
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.
0
votes
0answers
16 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
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
1answer
170 views

Problem creating subscriptions on Replication Server version 15.7.1

if anyone knows what is the error? Can not use active or standby connection names for subscriptions I got this error when I'm trying to create my subscriptions. I have already created a repdef WITH ...
2
votes
1answer
126 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
0
votes
1answer
237 views

Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes? I have 3 postgres databases (up to date with current version) running in AWS that I would like to ...
0
votes
2answers
92 views

MongoDB Replica Set InitialSyncOplogSourceMissing error

I am setting up a 3 nodes MongoDB replica set with one node in AWS using Mongo 3.6.12. There are about 400GB data need to sync to secondary nodes. Initial sync starts fine. However, after data sync ...
0
votes
1answer
233 views

Row-row based logging in a blackhole replication filter setup?

I am using two MySQL server instances on the same server to filter replication to a third external server. My filter slave is using the blackhole engine as described here: https://dev.mysql.com/doc/...
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
1answer
90 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 ...
-1
votes
0answers
12 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
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
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 ...
3
votes
1answer
4k views

Postgresql Streaming Replication Error: WAL segment removed

I want to set up PostgreSQL streaming replication, but get the following error: FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 00000001000000000000006A has already ...
0
votes
1answer
172 views

LogShipping replicated database

We use transaction replication to replicate our production database to another server(server 1) for reporting purpose. For a standby copy, we also logship the main database to another server (server 2)...
2
votes
1answer
136 views

Can scheduled and continous replication configurations exist side-by-side on the same master/slave servers?

Environment We have a core sql server cluster. This cluster contains some databases that get replicated to a load-balanced sql cluster of currently 3 servers. These databases are replicated each 12 ...
1
vote
1answer
353 views

Patroni : How to handle a slave which has been disconnected from master for long time?

Let's say if I am using asynchronous streaming replication with the below configuration in a 3 node cluster with Postgres 10.4 and Patroni 1.4.4 bootstrap: dcs: ttl: 30 loop_wait: 10 ...
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
0answers
121 views

Understanding pg-pool in details

I have following problem regarding the pg-pool (3.3.3) When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave ...
0
votes
2answers
139 views

MySQL replication - independent data update on slave

I have an unusual situation where I am migrating websites and their corresponding databases from one server to another. I have a database that is hosted on one server, A, where new records are ...
-1
votes
1answer
136 views

mariadb create slave from another slave

I have a big database its like 800G, and I'm using MariaDB 10.2.9. My configuration is : Server A (master) Server B ( Slave from Server A) Now I setup Server C and I wanted that it reads everything ...
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
128 views

master-master replication or master slave replication?

We have right now one server with a database. A device and a website are accessing that database causing load What I want is to create two servers master-slave where master databases are replicated ...
1
vote
1answer
153 views

Grabbing SQL Dump of Master DB Without Downtime

I'm curious whether downtime will be necessary to grab a SQL dump of my master database. Right now, I'm in the process of rebuilding my one slave. There is actually only one database from master that ...
0
votes
1answer
116 views

Restore server instance using logical backup and wal files

Is it possible to restore a database instance using logical backup and wal files? A senior SQL Server DBA asked me to implement below scenario in PostgreSQL took the logical backup using pg_dumpall ...
0
votes
2answers
161 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
1
vote
1answer
132 views

MySQL GTID replication: is it possible to make DDL changes to a slave and then catch it up to a master?

Here's what I would like to do: 1. hang a slave off my production master. 2. stop replication 3. adjust some data types and create some indexes on the slave (no data mods) 4. restart replication 5. ...
-1
votes
2answers
131 views

Master Master replication not working showing

error from master 1 Last_SQL_Error: Error 'Cannot add or update a child row: a foreign key constraint fails (stylanzo_live.report_viewed_product_index, CONSTRAINT ...
2
votes
1answer
2k views

Create temp tables in Amazon RDS PostgreSQL read-replica

I have dozens of legacy stored procedures which create temporary tables inside for collecting results for a read-only application. I've created a read-replica of my PostgreSQL in Amazon RDS and tried ...
0
votes
1answer
2k views

MongoDB replica has no primary

I have an existing MongoDB setup (part of a Graylog installation) where I'm attempting to configure a replica set with a primary, secondary and arbiter. I had the primary and arbiter configured ...
0
votes
1answer
237 views

Will changing a MySQL user's password break existing connections?

If I update a user's password or privileges in MySQL, how does this affect existing connections? In particular, if I change the replication user password, will it break replication for connected ...
-1
votes
2answers
181 views

Heartbeat frequency in AWS DMS (Database Migration Service)?

Within "PostgreSQL Source WAL Heartbeat https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReleaseNotes.html#CHAP_ReleaseNotes.DMS230", what does heartbeat frequency represents? The AWS docs doesn'...
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 ...
4
votes
2answers
3k views

Column cannot be converted from type 'int' to type 'bigint(20) unsigned'?

I have a Percona MySQL cluster, with a master and a few slaves. Each of them is running "Ver 14.14 Distrib 5.5.40-36.1" of MySQL. Replication is row based. I ran an alter query on one of the tables ...
5
votes
2answers
1k views

Many-to-One replication / Transactional Replication

I have several PostgreSQL DBs in different geographical locations (local sites). Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, ...
13
votes
0answers
762 views

Splitting Snapshot files with MaxBCPThreads for Transactional Replication

I've just set up a publication, and I'm attempting to get the snapshot to apply faster. So far the Distribution Agent is respecting the MaxBCPThreads settings, but the Snapshot Agent is not. I'm ...
1
vote
1answer
570 views

Status of PostgreSQL replication after pause and resume

To backup the PostgreSQL database we setup a slave server which uses streaming replication. We found the commands pg_xlog_replay_pause() and pg_xlog_replay_resume(). So we thought we use the commands ...
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 ...
2
votes
1answer
88 views

Replication recommendation

I am asked to investigate viability to use SQL Server replication technology for one of our upcoming project. In this project, basically there will be one central server located at corporate HQ (say ...
0
votes
1answer
215 views

Clarification on steps creating Database Replication Definition

I am being asked to create database replication definitions for a couple of databases (around 20 databases). I just wanted to clarify is the below-mentioned steps are the correct steps to be carried ...