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
5 views

PgPool setup with remote master and local read replica

I have working two server postgres setup with local (in docker) replica and remote (via VPN) master. Without enabled load balancing everything (all queries) are redirected to master with enabled load ...
0
votes
0answers
10 views

Workaround for repmgr of PostgreSQL in Windows Server OS 2019

I have been provided a VM on Windows Server OS 2019 for installing my web-app which uses PostgreSQL 9.6.6 as DBMS. As per the documentation at this link, there is There is no support for Microsoft ...
1
vote
1answer
24 views

How to apply Static Data Masking With Replication of Database

We used to have multiple environments for applications such as Production, Staging, UAT, Dev, and Sandbox. It is a regular task for the DBA to refresh the lower (staging, test, UAT etc.) environments ...
1
vote
1answer
10 views

Master ip has changed in postgresql replication

I have postgresql replication system with two machines, suppose I want to change the master ip,the streaming to slave machine will stop. Can I resume streaming with the new master ip instead of doing ...
0
votes
1answer
16 views

Enabling mySQL replication using GTID after purging binlog

I am currently working to get GTID based replication established between mySQL 5.7.33 on 2 servers. Amidst this work, I ran into a disk space issue and purged the binary logs on the master. Now I have ...
0
votes
1answer
6 views

threshold replica lag for secondaryPrefered mongod

Example: 3 node on RS with mongos and mongoc(cluster) On one Secondary node(on RS) we have replica lag, e.g. - 1h. So, if my read preference is - secondaryPrefered and if I read data from RS, can it ...
1
vote
0answers
19 views

postgresql - Advance replication slot as part of a transaction

Let me illustrate my use-case, I have a Python middleware doing this data transformation on the top of a postgresql replication slot, I would like to leverage Postgresql transactional capabilities. I ...
0
votes
1answer
16 views

Choosing name for MongoDB replica set [closed]

Are there any guidelines for choosing names for MongoDB replica sets? The documentation seems to mostly contain examples like rs1, rs-test, ... Is replica set name fully redundant, or could it ...
-1
votes
0answers
11 views

How can I correctly increment a field in a PostgreSQL table when the DB is auto-replicated and clustered? [closed]

Note: I also posted this question at Stackoverflow before someone pointed out to me that dba.stackexchange is a thing. Let's say I want to increment a field called total in a PostgreSQL table called ...
0
votes
1answer
16 views

Turning off Append only and snapshot on Redis

I want to turn off data persistence on my Redis master, by turning off appendonly and snapshots, I want to use the replica for persistence, will turning off these two have any affect on replication?
0
votes
0answers
8 views

My Mongos can't authenticate to my replica set

I have 3 config servers in a replica set and when I use the command: sudo mongos --configdb crs/the 3 config servers:port# --keyfile "Keyfile", I keep getting this error: [mongosMain] Unable ...
0
votes
1answer
17 views

what will happen if MongoDB primary host is down and secondary is out of sync. will we lose transaction?

In our environment, we have one primary(A) and two secondaries(B & C nodes) running in Mongodb 4.0 version. secondary(C) server is newly added and sync is happening on that. Cluster is running ...
0
votes
0answers
20 views

Why mongodb's storage size is larger on secondary than on primary?

I don't understand why the storage size is significantly larger on the secondary than on the primary (450 GB vs 375 GB). hardware, operating system, file system and mongodb configurations are ...
0
votes
1answer
29 views

One-directional Transactional Replication is causing one table's Clustered Index to be copied over as a Nonclustered Index in the subscriber database?

This seems really odd to me, as I've used SQL Server's replication feature for a while now and have never seen this occur before. I'm using One-Directional Transactional Replication and I have ServerA ...
1
vote
1answer
35 views

Can SQL Server Replication decrease publisher performance?

We have an application that will generate a lot of insert/update transactions per second. Recently, we've moved the application to a new server and since then, the performance deteriorated ...
0
votes
0answers
8 views

Understanding MySQL Innodb replication issue

I am trying to flip MySQL primary/ RW database from one host to other host. There are times where replication on the workers is broken post flip. Trying to understand the internal details and best ...
0
votes
0answers
66 views

SQL Server 2019 replication problem after update to CU9

After update to CU9 for SQL Server 2019 (15.0.4102.2) (Linux Ubuntu 18), replication (snapshot) stopped working with errors: 2021-03-23 11:58:08.70 [0%] The replication agent had encountered an ...
1
vote
1answer
20 views

MySQL Read-only Replication

I've multiple linux servers which runs MySQL server and my applicaiton each. I have a cron job which creates daily backups and uploads them to another server. Daily backups are OK but, i want to be ...
0
votes
1answer
15 views

PostgreSQL Update and Delete are not (logically) replicated while having REPLICA IDENTITY

I was trying to sync a table with Logical Replication. This needs to cover Insert, Update and Delete. However the replication only worked for Insert and not the rest. As documented here A published ...
1
vote
0answers
31 views

How can I insure data transfer from a client to an SQL database server if the network connection goes down? [closed]

My scenario is likely common: Many product test stations sending test data to a centralized (master) database. (In my case the product being tested is a high frequency transceiver) My goal: Keep the ...
1
vote
1answer
26 views

In MySQL 8, can we make group replication db as readonly?

I have configured group_replication on 4 db. Out of which I am trying to make 2 db as slave(only read). Even though I make read_only, user can write data in it. Is possible to make 2 as master and 2 ...
0
votes
0answers
20 views

MongoDB replica set goes into recovery state after start up

Its a cluster 3 replica. Data size is ~20GB 2 of secondary crashed only node was available is primary and it stopped abruptly and when I started the daemon and is going into recovery. At first I ...
1
vote
0answers
30 views

pgpool 4.2.1 and postgres 11 streaming replication problem

I've setup a 2+2 pgpool and postgresql cluster. two pgpool nodes in active/standby configuration and a streaming replication between databases All seemed work fine until after some failover and ...
0
votes
0answers
51 views

High Memory Usage on Replica - Mysql 8

Hope you're doing well. We've recently moved to Mysql 8 (from Mysql 5.7). We're using AWS RDS Service with MySql. The AWS Team is also looking for a solution btw. Since a few days, we're facing ...
0
votes
1answer
84 views

Is there a cross-platform way to compare data in one columnd on each sitde of replicated data, like a checksum or hash?

I have an Oracle 12 database with lots of tables, and I am replicating several of the tables (a subset of rows) into a SQL Server 2016 database. The subset of rows can be established with a WHERE ...
1
vote
1answer
33 views

Is it possible to run a stored procedure automatically on a new database when it is attached?

Replication is causing issues on our daily snapshots. What we would like to do is remove replication automatically on a database when it is attached to the SQL server. Is this possible?
0
votes
0answers
20 views

Mysql Router not sending Write request to R/W instance

I am doing InnoDB Cluster Group Replication for the first time. I stuck at the last step Mysql Router. Mysql Router is configured with bootstrapping, But the main issue is MySQL router does not send ...
0
votes
1answer
17 views

'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,EXPLICIT) for operation '='' on query

I have migrated the mysql 5.1 to 5.7 by using the mysqldump file. But i am facing the issue during master slave replication as below. Error 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (...
1
vote
1answer
19 views

Does row-based replication with “binlog_row_image=minimal” cause issues when ALTER TABLE reorders columns?

Just trying to get my head around the caveats of using binlow_row_image=minimal with row-based replication in MySQL 8.0.23... To avoid silent data drift, the requirements seem to be that: All tables ...
0
votes
0answers
30 views

Will database replication increase the size of the replicated database?

First thank you for your time. We have a SQL Server database that was assigned to be replicated. the original size of the database was 5 GB for the datafile, not the log file. Now after the ...
0
votes
0answers
17 views

Will database replication increase the size of the replicated database? [duplicate]

We have a SQL Server database that was assigned to be replicated. the original size of the database was 5 GB for the datafile, not the log file. Now after the replication the data file is 4 times ...
0
votes
1answer
14 views

Why would you distribute replica shards across nodes and not mirror replicas?

I'm trying to understand how replicas work in Elasticsearch. This is a very basic question, but can someone explain why one node is not just all replicas? Surely in this example, if one node fails 50%...
0
votes
1answer
17 views

Bulk DELETEs in publisher breaking SQL Server Replication in subscriber

We have SQL Server replication set up between 2 databases running SQL Server 2019. Every night, a SQL Agent job runs on the publisher that deletes all the data from a table and then rebuilds the ...
0
votes
0answers
10 views

MySQL Group Replication starts master node with super_read_only

I am trying to set up MySQL group replication. Only problem is, that when I try to start replication group, It starts with super_read_only. Here the configurations in my.cnf file [mysqld] ...
1
vote
1answer
26 views

SQL Server Replication: Is there a way to know which articles are being used in a replicated database?

I've come into a situation where there are about 1000+ tables being replicated to a database. When it was created, I think the creators just put a bunch of tables they thought would be needed. I'd ...
0
votes
0answers
15 views

Mysql backup- restore on multiple host in live replication

MySQL database has 1 primary host which is replicating to 2 Read replicas RR1 RR2 RR1 is master of RR11 RR12 RR13 RR2 is master of RR21 RR22 RR23 I have to make a schema change so I started schema ...
0
votes
0answers
27 views

FK Constraint error

I am in the process of setting up a replication between my production server and a secondary. The two machines connect to each other perfectly and I think I set things right. I dumped my prod that I ...
2
votes
2answers
27 views

How do you update one side of a MySQL master-master replication setup?

I have a master-master (circular) replication configured between two MySQL servers, call them West and East. There is also a web app that interfaces with each DB, also on its own West and East server,...
0
votes
0answers
14 views

PostgreSQL 10 logical replication only synchronizing one time and then stopping

I have one database containing user information that I'm replicating to a separate application db on the same cluster. After an error I discarded the subscription, replication slot, and the replicated ...
1
vote
1answer
104 views

#sql-ib***.ibd files fills up the disk after a couple of hours

Why are these files created? They fills up the disk on my slave server (master/slave replication) #sql-ib219492-948768181.ibd The slave is created via Percona xtrabackup from a master backup ...
0
votes
0answers
18 views

MySQL 8.0.20 - Master Replica scheme, errors during replication process

This threads follows a previous one, given at this URL: MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica Replica Server has been configured this way, which ensures a ...
2
votes
1answer
21 views

Sync MySql Replication from Master2 to Master1 after failover

Due to Disk space issue Master2 server crashed and it was rebuilt again using mysqldump of Master1. Both Master 1 and Master2 are in sync and Master2 is in Read_only mode. During the crash, I stopped ...
1
vote
1answer
53 views

MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica

We have a Source Database of about 1TB, and a Replica on another server (similar architecture). We have setup Master Slave replication and delay between Master and Slave is always growing since. ...
0
votes
0answers
18 views

Should mysql database be replicated in a replication setup

When I do a replication setup I always ask myself should I put mysql and other internal databases (like information_schema) in the binlog_ignore_db option. Documentation about replication I read never ...
1
vote
2answers
21 views

Is there a way to analyze a MySQL query and determine whether it's read-only?

I have a main database and a replica that is automatically kept in sync with the main one. It would be nice, for each query I make, to perform all data- and database-altering queries on the main ...
0
votes
1answer
117 views

Can't restore master/slave replication from Percona backup (slave server)

A slave is restored from a master backup created with Percona xtrabackup On the master binlog is set to expire in 14 days and this backup is less than 24 hours old my.cnf (master) expire_logs_days = ...
0
votes
1answer
30 views

Does a single replica gives any performance improvement?

Consider a case where you have a single PostgreSQL database. Then you add a replica (hot standby) and you send all the reads to that replica. This is what does Rails for example. Does this gives any ...
1
vote
1answer
31 views

SQL Server Transactional Replication between SQL server 2019 Standard and SQL server 2016 Web Edition

We have SQL Server 2016 Web Edition on production currently. Since this edition supports replication as Subscriber only, I set up a new server with SQL Server 2019 Standard edition. I want to ...
0
votes
1answer
22 views

Filter a SQL replication

I'm trying to replicate a SQL database but I want to apply a filter based on date. The database has more than 6000 tables and all of them have a datetime column (stamp) with the same name "...
1
vote
1answer
31 views

Failover in MySQL Chain Replication

We have a 4 server setup, 1 master, 3 daisy-chained slaves, in the following setup: A (master) -> B (slave) -> C (slave) -> D (slave) (the servers B and C and D are running with ...

1
2 3 4 5
63