Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
31 views

Linked Server vs Replication vs Other? [on hold]

I've been thrown into a project where this business partner is pushing for transactional replication from our sql server to their sql server (which are on the same network/domain) for records from "...
0
votes
0answers
15 views

SQL Server replication model snapshot, transactional and merge - which method can be used

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is ...
1
vote
1answer
27 views

MySQL utf8mb4 Migration - Replication Considerations

We're planning to migrate a MySQL database with a mix utf8 and latin1 tables to the new utf8mb4 character set per this article: https://mathiasbynens.be/notes/mysql-utf8mb4. Our server is 5.7.22 and ...
0
votes
0answers
19 views

It's possible to avoid overload on a Mysql slave by slowing down replication?

I have a slave on a machine less powerful than the the master (8CPU/8GB on the master, 2CPU/4GB on the slave, MySQL 5.7). Replication is binlog ROW based As the db is increasing on the master, the ...
0
votes
0answers
9 views

replication type of dynamodb

What is the replication type of the DynamoDB system? Like is it master slave, peer to peer, multi master, or something else. I know that that for global tables, DynamoDB has cross replication with ...
0
votes
0answers
21 views

Steps for write ahead log protocol

What are the steps for write ahead log protocol? I know these are the steps, but I don't know the order they occur in. a. Updated data is persisted on disk. b. Data is updated in memory. c. The ...
2
votes
1answer
48 views

RDS MySQL read replica larger than master

We have a Multi AZ AWS MySQL 5.6.40 server with a matching single AZ read replica. Both have 200GB of storage available. However, the read replica is rapidly running out of free storage space, while ...
0
votes
0answers
29 views

Replication Alternatives for Contained Databases

My team and I are in the process of designing a new application using the microservice architecture approach. Each application is going to to be responsible for releasing changes to its own database ...
0
votes
0answers
15 views

Ιndexed view after replication

I am trying to find a smart (no redundunt dataflow) way to aggregate data on views/tables to be used from our reporting tools. One given is that the reporting database is different from the oltp one, ...
0
votes
0answers
36 views

Is it possible to queue PostgreSQL logical replication messages from multiple sources?

I want to use multiple "forward" PostgrSQL instances which serve distinct applications but share overlapping subsets of the same schema to update a single master which holds a full version of the ...
0
votes
0answers
26 views

One way replication between 2 sql servers on different networks

I would like to replicate between 2 sql servers that exist in different networks. This link is not relevant to my case as the servers are not connected: https://docs.microsoft.com/en-us/sql/relational-...
0
votes
1answer
18 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
0
votes
0answers
12 views

Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

Getting one issue in error log in every 30-45 mins. Mysql version 5.6.20-log Server is slave of master main server and its having 100 slaves to this server. Replication hierarchy is there in 3 stages. ...
0
votes
0answers
12 views

Your preferred HA replicated setup of PostgreSQL on Kubernetes - does this even make sense?

I'm currently looking to run a new production level PostgreSQL instance on a Kubernetes cluster. I'm just a software developer who only uses PostgreSQL on the local machine during application ...
0
votes
1answer
39 views

Replicate Postgres to Cockroach

We are planning to replicate our Postgres database to Cockroach. We are looking for a relatively simpler solution to achieve that. Currently, we are working on a Stream based replication (something ...
0
votes
1answer
20 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
22 views

REPLMERG.exe cannot connect to distributor

We have a SQL Express 2016 instance that is doing merge replication to a SQL 2016 box. This is an upgraded instance on both sides. We upgraded from SQL Express 2012 to 2016 and we moved the database ...
0
votes
0answers
25 views

Postgres Replication Scenario

I trying to implement following scenario using postgres : Server A : This server is used for product A production stage Server B : This server is used for product B production stage. This B product ...
3
votes
0answers
48 views

Should I use Transactional Replication here?

I have a database on SQL Server A & one on SQL Server B. (SQL 2017 w/ enterprise) They share similar objects and need to be kept fairly up to date. Both will require changes to be passed to each ...
0
votes
1answer
19 views

How Maxscale deals with “Select for update transactions”

We are facing intermitent deadlock issues that doesnt got reflected in the maxscale log nor the mariadb log. Only in the applications triying to do sql transactions in the database. We use mostly ...
1
vote
0answers
16 views

MySQL fatal error 1236 when swapping in new master, “master has purged binary logs”

Our situation: we have three MySQL 5.7.23 replica servers attached to a MySQL 5.7.23 master server running in EC2 instances in AWS. All the servers are fine and GTID replication is working properly. ...
0
votes
0answers
24 views

Configure replication from SQL server 2014 Enterprise Ed. to SQL server 2017 Enterprise Ed

The query here is pertaining to Replication support between Publisher instance running on SQL Server 2014 Ent. Ed. and Subscriber instance being on SQL Server 2017 Ent. Ed. Currently all DB instances (...
0
votes
0answers
14 views

MySQL 5.5 replication over SSL broken after upgrading OpenSSL, OS

I've got an issue where, after upgrading a replication slave from Ubuntu 14.04 to 16.04, this slave can no longer connect to its master using SSL. Setup before the upgrade: 1 master, 2 slaves, ALL ...
0
votes
1answer
23 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
1answer
17 views

MySQL Replication ignore few columns

I have setup MySQL replication, is there a way to skip replicating one column or multiple columns from few tables?
0
votes
0answers
40 views

MySQL Replication Error - Deadlock

Our replication seems to randomly stop/fail; a restart of the server resolves the issue (temporarily); this morning I picked up on the conversation, noting that a reboot doesn't actually fix the issue ...
0
votes
0answers
25 views

MySQL replication stopped working with error code Error_code: MY-003159

I am trying to setup Master-Master MySQL replication in MySQL 8. It was working fine until recently. I am able to connect as replication user from slave host to master; however, when I start ...
0
votes
1answer
16 views

Is there an option to prioritize a table while replication conflict occurs?

I have a master slave configuration for my production stage environment. Sometimes I need to write to some tables of my stage server i.e slave server. In that case conflicts occurs as content from ...
0
votes
1answer
38 views

differences between hot standby vs warm standby postgresql?

I am confused about the Differences BETWEEN the database replication methods mentioned in a wiki page of postgres, which is best for normal situation? warm-standby/Continuous archiving/log shipping ...
0
votes
1answer
65 views

MySQL slave stuck on Applying batch of row changes (write)

I'm using Amazon RDS as a slave for my dedicated MySQL server (running outside of AWS). Replication has been working alright for the past few months, until yesterday when I updated the structure of ...
0
votes
2answers
49 views

Sync two postgres databases from two sperate locations with no network

I have 2 postgres databases running the same schemes on two different computers, that are not guaranteed to have any network connection while having to handle read/write requests. Because they ...
1
vote
2answers
73 views

The merge process could not connect to the Publisher ' '. Check to ensure that the server is running. (

I have 2 servers with 2 kinds of replications between them. One is Transactional and the other is merge. The Transactional replication is working fine but in the merge replication, I'm getting error ...
0
votes
1answer
42 views

Logical Replication to different schema name

We have PostgreSQL 11 database with structure one database one schema (public). dbname : production_one schema : public dbname : production_two schema : public I would like to set up a logical ...
1
vote
1answer
28 views

Replication to subscriber with different name

Is it possible in PostgreSQL to set up the following replication scenarios? Replication between 2 servers with different database name. For example, replicate FROM server_A (primary) database name ...
0
votes
1answer
52 views

Cannot set up replication between two servers

I am trying to subscribe a 2016 (sp2, cu1) server to another 2017 server. I am getting the following error message: For merge publications, the version of the Subscriber must not exceed the version ...
1
vote
1answer
28 views

What happened to pg_xlog?

There uesd to be a directory called pg_xlog that stored all of the WAL logs in PostgreSQL? Part of restoring a basebackup under the archiving scheme required me to copy the WAL into DATA_DIR/pg_xlog. ...
1
vote
1answer
37 views

Streaming replication archive folder taking all space- Postgresql- 9.4

We had recently setup postgres streaming replication between master (physical, CentOS release 6.6) and slave(virtual, CentOS 7.6). We did the test and streaming replication is working fine. We ...
0
votes
1answer
37 views

MongoDB 3.6, adding replica set always fails as on production setup with cannot open /dev/urandom Too many open files

I am trying on add a 3.6 mongoDB node to a 3 member replica set running 3.4. Doing this as a part of DB upgrade from 3.4 to 3.6. When I add the new member to replica set, it goes to STARTUP2, data ...
0
votes
1answer
29 views

Why am I seeing these mongodb 3.6.5 server log messages in huge amounts?

Could someone please shed some light on these mongodb 3.6.5 server log messages on the primary node of a 3-member replicaset? rs.status() says all the nodes are up and running but seeing a ton of (I)...
0
votes
0answers
8 views

Decrypt RSSD maint password in Replication Server version 15.7.1

Is anyone knows any possibilities to decrypt an encrypted RSSD maint password in the Replication Server configuration file? Thanks in advance.
0
votes
0answers
27 views

MariaDB GTID current_pos vs slave_pos

In a standard master-slave setup using MariaDB (10.3 at this time) and GTID (Global Transaction ID), it is unclear wether to use current_pos or slave_pos. Reminder from the documentation: Using ...
0
votes
0answers
37 views

[MongoDB]See Collections (and Files) created in a Shard on the Cluster

My structure: A Sharded Cluster with multiple Shards. Each Shard contains 1 Collection, which is pinned to it by tags. Every Shard is at the same time a ReplicaSet Secondary. It receives data from a ...
0
votes
1answer
26 views

archive_command failed causing master to run out of disk space. Is there a command that prioritizes master's health

I had replication set up with a simple archive_command in postgresql.conf: archive_command = 'rsync -a %p _postgresql@serverip:/var/postgresql/wal_archive/%f' Which worked great for 2+ years until ...
0
votes
0answers
33 views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
0
votes
0answers
18 views

Adding index only on read replica of MySQL RDS instance

I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use. Consumers of this replica are looking for additional indexes for faster ...
1
vote
1answer
11 views

Can a replication subscription also be used as a publication?

Some background: We are working with a vendor who makes a read-only copy of their source database available to us in the cloud via filtered transactional replication. The cloud database is a ...
2
votes
2answers
50 views

SQL Server Replication with Historical Tables

Is it possible to replicate a SQL Server database and for the replica to have temporal/historical tables? Details: I have a production system, running SQL Server 2014. I want to have a replica ...
0
votes
1answer
32 views

mongodb: Can I create an unshard Replica set for a sharded cluster?

I have a 3 node shard cluster mongoDB with replica set, and want to add (single node replica set) a un-sharded Replica set to collect all data in one node. Can I create an unshard Replica set for a ...
0
votes
0answers
36 views

Error 'Unknown Collation: '2048' on query

I'm doing MYSQL Replication for the first time. Master mysql version: mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1 Slave Version: mysql Ver 14.14 Distrib 5.1.73, for ...
1
vote
1answer
92 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 ...