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
1
vote
0answers
49 views

Keep 2 instances of SQL Server synced [closed]

We want to set up a second instance/server of SQL Server such that both instances will be kept in sync. The reason is we need to separate some users and processes out to a separate server for business ...
0
votes
1answer
21 views

Adding articles to sql server

I am trying to add a few new articles to an existing sql server replication publication. The publication is for one way transactional replication. I have done this multiple times on multiple servers,...
0
votes
0answers
11 views

Is replication applicable to sync 100s of client db with central db

I'm currently involved in a project(web application Django + Postgres 11) which works in remote locations where network connection is limited. But we need to make sure the application shouldn't fail ...
0
votes
1answer
11 views

restore table and populate new data from transaction log

I use mysqldump nightly to backup a database. I'm trying to find a way to do a partial restore on the data from one table. I use the --master-data flag so I know where in the transactions log my data ...
0
votes
1answer
37 views

Master and Slaves issue

I have one master and 2 slaves,one is replicating but another slave which is read-only not replicating. From Master : show master status; +------------------+----------+--------------+---------------...
3
votes
1answer
90 views

How to force subscriber to have foreign key WITH CHECK?

I know by default SQL Server replication adds WITH NOCHECK and NOT FOR REPLICATION to the foreign keys after transactional replication. But is there are way, where I can avoid these code changes made ...
0
votes
0answers
64 views

MySQL8.0 Replication Got Stuck “Applying batch of row changes (delete)”

When I configured Master-Slave replication it was working fine but after five weeks it is showing the following error. *************************** 1. row *************************** ...
0
votes
0answers
17 views

Mysql replication trigger error

I have replication master - slave on two different machines (both centos 7, mariadb 5.5). When on master i run query which fires some trigger i've got error in Master's logs. [Warning] Unsafe ...
1
vote
0answers
65 views

How to check RDS MySQL database synchronization status

We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
1
vote
3answers
193 views

Sql Server replication: Initial snapshot for publication is not yet available?

I had setup transactional replication and my distributor, publisher are on same windows server and 2 subscriber one on same server and another on other windows server both using push snapshot. I am ...
0
votes
0answers
51 views

Master-Master Mysql Replication temporarily stuck

I've set up a Master Master replication using GTID (Mysql 5.7.29 @ Debian). Its setup for multi-source, but only two servers are in use now. Once in a while, the execution of the transactions on one ...
0
votes
0answers
20 views

2 Way replication issue faced of records skipping/not replicating

We have a replication setup wherein data entry is done at head office and also at multiple branch locations; data replicates from h.o. to multiple branch locations; also data entry done at branch ...
0
votes
1answer
38 views

MySQL Multi Master Replication

I have 4 servers running MySQL 5.7 in total , servers 1,2,3 each has single database on them For example: Server 1 has the DB x_1 Server 2 has the DB x_2 Server 3 has the DB x_3 Server 4 has 3 ...
1
vote
0answers
42 views

Can I do a combination of SQL Server Basic availability groups with SQL Replication?

I need to use SQL Server Standard 2016 to keep the costs low but achieve HA. In addition we need to have two Read nodes for reporting purposes. I am wondering if I can use SQL Server Replication to ...
0
votes
1answer
29 views

Sql Server Replication - Modify Statement Delivery Stored Procedures before the replication starts

I want to create a subscriber (replica) where fields like Username, Email, and other personal customer info is masked (I'm creating a replica of production to help developers troubleshoot issues). So ...
0
votes
0answers
5 views

Un-publish a database with no publications

I'm trying to remove all replication from a SQL Server instance. There are no subscribers. There is one database published for snapshot replication: SampleDb According to sp_helppublication there ...
1
vote
1answer
35 views

Can a MySQL 5.6 master replicate to a 5.7 slave, which in turn replicates to a MySQL 8 slave?

According to the docs, "MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a master running MySQL 5.6 to a slave running MySQL 5....
3
votes
1answer
51 views

Reporting table needs to get refreshed without killing user's read connection to it, any ideas?

I'm investigating a solution that will allow a reporting table to be refreshed that can potentially have users reading from it at a time that it needs to be refreshed. Has anyone implemented a way of ...
0
votes
1answer
28 views

Galera wih MariaDB master-master to support write enable on disconnect

I'm trying out a distributed app using Galera replication topology that needs to support writes if nodes are disconnected from the cluster. The idea was to have an extra MariaDB that is connected to ...
1
vote
1answer
658 views

Could not start WAL streaming, replication slot is active

I want to set up replication between two of my databases. One is an Aurora database in PG 10 the publisher, and the other one is an RDS database in PG 10. But I'm facing an issue, I have 500 GB of ...
0
votes
0answers
63 views

Postgresql Logical replication initial slot snapshot too large

I'm trying to replicate some data from one database to another with logical replication. But it gets stuck into the catchup state. When I'm looking at the logs initial slot snapshot too large I'm not ...
2
votes
1answer
82 views

Replication fails with “Transaction log for database is full due to LOG_BACKUP”

Replication is failing with the subject error. The log_reuse_wait_desc states LOG_BACKUP. I have performed both database and log backups. After changing the recovery mode to single, performing ...
0
votes
0answers
19 views

does it exist error code 22 and what is the cause?

i have the following doubt. Today in the morning, I had the following replication event: SQL: Error 'Character set '#1032' is not a compiled character set and is not specified in the '/usr/share/...
0
votes
2answers
181 views

How to debug a growing Redo Queue Size in the Availability Group Dashboard?

The Redo Queue Size has been growing pretty big over the last couple of hours on my secondary replica's server (SQL16). There's nothing long running or heavy running that I've found over the last hour ...
0
votes
1answer
20 views

How to add/update data from slave server to master server in MariaDB?

I am experimenting on whether I can tweak the functionality of master-slave replication. I can write data in my master server which gets updated in the slave server but it cannot happen the other way. ...
0
votes
0answers
10 views

Quantifying synchronous replication latency

Currently, we asynchronously mirror databases across the WAN to a different DC. What statistics can I collect (COMMIT times, maybe?) from Profiler to measure the impact? Any other statistics from ...
0
votes
1answer
71 views

Exception when starting Snapshot Agent when setting up database replication

I am trying to set up replication between databases. I followed these tutorials: Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber) and after: Tutorial: Configure ...
1
vote
1answer
57 views

What is the cause for the error 1610

This morning, I had the following event: 200310 9:54:57 [ERROR] Slave SQL: Could not execute Update_rows event on table Call_Center_Infinit.queue_member_table; Corrupted replication event was ...
0
votes
0answers
26 views

Conflict Viewer in merge replication

i created merge replication on sql server 2014 Enterprise edition and i saw some conflicts in conflict table but when i opne conflict viewer it showing below Error before this it is working fine and ...
2
votes
0answers
76 views

Whether or Not to Use DataPump with Oracle GoldenGate

We are setting up GoldenGate to keep 3 of our Oracle databases in sync. Regarding configuration:   We plan to have an instance of GoldenGate running on all 3 nodes. Each node will run an extract on (...
0
votes
2answers
80 views

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured. Consider that the leader node crashes. Two ...
0
votes
1answer
56 views

MySQLdump Exclude master-data

Is it possible to exclude the master data from a mysql dump? From the manual it seems like the only options are commented out or present. I don't need the data at all because it is going to a static ...
0
votes
0answers
23 views

Postgres replica out of sync

we have a postgres 9.6 replica configured among 2 servers. We used the following configuration to create the replica: postgresql.conf wal_level = hot_standby max_wal_senders =...
0
votes
0answers
23 views

questions on sqltabledependency, servicebroker and replication

is the activation of the servicebroker on a database permanent so i can use it with the sqltabledependency , or it will auto desactivate after some amount of time ? i am developping an application ...
0
votes
1answer
30 views

Unusually low insert rate on MySQL Slaves

I have 4 MySQL nodes replicating like this: M1 - S1 | M2 - S2 Only the M1 master is writing, the hardware is similar (the slaves are a bit beefier), they all run Percona 5.7. The trouble is that ...
0
votes
1answer
44 views

Percona restore databases error

I am trying to restore Percona backup but getting the below error. [/]# xtrabackup --copy-back --target-dir=/backup-billingsystem xtrabackup: recognized server arguments: --innodb_file_per_table=1 --...
4
votes
0answers
67 views

how to remove all permissions in a database?

every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
0
votes
3answers
117 views

How to sync daily the prod database to dev database in Azure SQL Server service?

I have two Azure SQL Database, prod and dev. How can i daily replicate the prod database into dev database? I have tried to automate it by exporting and importing the BACPAC file but it takes too long ...
0
votes
1answer
18 views

Double Transactional Replication (e.g. Two report servers)

Is it a good plan to use SQL Server Transactional Replication from server one to server two then another from server two to server three? Most of us DBAs here are advise against it. The boss wants ...
0
votes
0answers
79 views

How to implement master-master replication in PostgreSQL?

I am working on a project which requires my database client to scale horizontally for higher availability but it is required to use RDBMS for our solution. Therefore, we want to implement master-...
0
votes
0answers
31 views

Index Rebuilding on Live Server [duplicate]

Hi I have one live server A , db A and another replication server B , db B on stand by. I am using Microsoft SQL Server 2014. I plan to put the live server, db on stand by and turn on the the ...
0
votes
0answers
90 views

SQL Server Replication with Temporal Tables

After a bit of advise. I have an existing database that extensively uses Temporal tables (i.e. System versioned tables). We are looking at an environment where we have a near to real time replica of ...
1
vote
1answer
89 views

MongoDB Replication initial sync fails with OplogStartMissing

I'm currently testing replication in our development environment. Our current (primary) mongo instance has around 70-80 GB of data. I created a new instance and added it to the replica set. It takes ...
0
votes
1answer
22 views

MongoDB Reconnects to Secondaries Too Fast

How can MongoDB 4.0.12 be configured to SLOW its rate of re-connecting to its replica members when they are down? I had MongoDB replica members die. The online replica members get “connection refused”...
0
votes
0answers
16 views

How I can calculate/debug table bloat for each table once I set the hot_standby_feedback=“on” on postgresql 11?

Because I use a replication with hot_standby_feedback=on option I need to calculate how much my tables are bloated on a given time. In other words I need to calculate the following difference: ...
1
vote
1answer
41 views

postgresql logical replication — subscriber size discrepancy

I have a postgres 11 database in Amazon RDS with a little over 2 TB data in it whose tables have incrementing integer ids that are nearing exhaustion. I've been vetting using logical replication to ...
0
votes
0answers
152 views

How trigger update in replica database on Postgres?

In both servers (master and replica) I have two tables like this: CREATE TABLE my_table ( id SERIAL, name TEXT, "timestamp" timestamp without time zone, CONSTRAINT my_table_pkey ...
0
votes
1answer
21 views

Replication testing is a Materialized view Refresh equivalent of continious update?

In my database I have the following a materialized view named materialized_view_test and the data are being feeded from 3 tables: select * from a_table join b_table on b_table.a_id=a_table.id ...
0
votes
1answer
55 views

MySQL database cluster vs. replication setup for large crawler indexes

What is the most efficient way to set up a MySQL cluster or replication in an application that has a crawler/indexing engine with thousands of read/writes and then a separate front-end for public ...
0
votes
1answer
13 views

MySql Replication Failure on primary secondary

We have experienced replication failure between primary - secondary databases. I have tried various scenarios to get replication to work again, which included deleting secondary database and ...

1 2
3
4 5
60