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 ...
