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

Is offsite replication from MySQL AWS RDS with encrypted RDS storage possible? How?

AWS RDS for MySQL now supports encrypted storage backends. This encrypts the MySQL data and binlogs with a key within AWS's key management system, thus causing offsite replication issues because we ...
0
votes
0answers
271 views

Postgresql logical replication reapeted failures, replication slot is active for PID x

Postgres 13.2 running on Windows server 2019. Every few days or sometimes even more frequently logical replication is stopped by an error replication slot "sbscr_name" is active for PID 4754 ...
1
vote
0answers
19 views

GCP Cloudsql Mysql Replica unresponsive after mass delete on Master

We have a Master/Replica configuration for Mysql innodb(5.7.32) databases in Cloud SQL... We have a single Table (let's call it Master table) partitioned on Two keys having both primary and non-...
0
votes
1answer
37 views

Rebuilding a single corrupt table with dual master replication

I have a replication setup with two MariaDB 10.2 instances set up in a dual-master configuration. On host A, a table has been corrupted somehow; whenever I try to read from it (including CHECK TABLE ...
0
votes
1answer
23 views

ERROR: Too many connectioons

I'm new to mysql. So, sorry if you find it an easy/silly question. I have a quick question since I encountered a strange scenario. I want to make sure does it actually happens or did I do the right ...
0
votes
0answers
206 views

SQL Server Replication: How do you change the distributor?

I've been given the task to change the distributor to a new server for pre-existing replication (both snapshot and transaction). Server A: Existing Replication (Publisher) Server B: Existing ...
0
votes
1answer
38 views

mysql 4 masters in different location

Because internet is not always available i cannot just use one central database. So there are is a DB in every location. I need to have them all in sync, but there can be a delay of 30 minutes or ...
0
votes
0answers
13 views

Not able to see the master gtid in gtid_executed_set slave status after switching master. But replication is working fine

I recently switched source of a slave(C) from a existing master. The old architecture was B<--A-->C, A being the primary source for B and C. After switching master, now it is working as A-->B-...
0
votes
3answers
108 views

Replicating contained SQL databases to customer in near real-time

We host a number of customer SQL Server databases that we need to replicate to external customer sites in near real-time. The main constraint we have is that, for security reasons, our databases are ...
0
votes
1answer
30 views

migrate mysql DB between two servers using replication

I need to perform some steps, I have to migrate our company live DB to a new server, if I use normal way such as lock table, mysqldump, scp, mysql restore, it take around 5-6 hours, so I want to make ...
0
votes
0answers
25 views

Setup amazon aurora as replica to mariadb master [duplicate]

I am trying to setup replication between MariaDB 10.4.17 and Aurora 5.7.12 MySQL, with Mariadb as master and aurora as replica. I am following this aws article I noted the file name and position +-----...
0
votes
1answer
109 views

Replica identity value on PostgreSQL read-only replica

In PostgreSQL will the replica identity of a table in a read-only replica database be the same as the replica identity in the primary? I.e., if I run the following query on primary and replica ...
0
votes
0answers
56 views

Store Elasticsearch shards in separate partitions on data node

I have an Elasticsearch cluster configured with one head node and three data nodes with the number of replicas set to 2. The data nodes are each split into three partitions called /data1 /data2 and /...
0
votes
0answers
25 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 ...
1
vote
1answer
269 views

How to apply Static Data Masking With Replication of Database [closed]

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
47 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
98 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
11 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
75 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
33 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
15 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
78 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
41 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
49 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
291 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
16 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
1answer
328 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
45 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 ...
1
vote
1answer
893 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
123 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 ...
1
vote
0answers
228 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
1answer
207 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
182 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
35 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
1answer
214 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
73 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
38 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
18 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
82 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
24 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
18 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
83 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
155 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
26 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
192 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
1answer
49 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
26 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 2 3
4
5
65