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
2,954
questions
0
votes
0answers
14 views
MS SQL to PostgresSQL replications
I have an MS SQL deployment and the data is growing. I have a PostgresSQL server and I drop the data moved from my MS SQL server every day. It takes many hours, and I want to have a replication from ...
0
votes
1answer
7 views
PostgreSQL pg_rewind use cases
Let's say that I configured streaming replication between Server A (master) and Server B (slave). If server A goes down and Server B is promoted, would I be able to use pg_rewind, where Server B is ...
0
votes
0answers
14 views
PostgreSQL Streaming Replication with Switchover
I'm trying to provide streaming replication between a master (T1) and slave (T2) and swapping their roles when necessary (i.e letting T1 be a slave to T2). So far I am able to get this working if I'm ...
0
votes
0answers
9 views
Is there a mechanism in replication which will tell that all records from publisher have reached subscriber
We are using SQL SERVER 2008 R2; transactional replication; distributor, publisher, subscriber setp.We have a scenario wherein material receipt entries are made at factory and purchase invoices are ...
0
votes
1answer
14 views
Transactional replication setup on non default port not working
Transactional replication setup on non default port not working - when adding publication, the underlying name being used is still the one without the port no due to which it is not being able to add ...
1
vote
2answers
23 views
What are the benefits of using Manual Failover Mode in an AlwaysOn Availability Group instance as opposed to Automatic Failover Mode?
Why wouldn't I want to use Automatic Failover as the Failover Mode for an AlwaysOn Availabiltiy Group instance?
Are there pros for Manual Failover Mode that don't exist for Automatic Failover Mode?
0
votes
0answers
18 views
Always on Availability Group not allowing restores on secondary replica
I can’t restore backups or t-logs to my secondary replica and perhaps you can lead me in the right direction or if you've seen this before, give me a hint.
I inherited an environment with zero ...
1
vote
1answer
10 views
Can PostgresSQL cluster have synchronus and asyncronus standbys at the same time for the same dbs?
In this question, Write concern in PostgreSQL Laurenz Albe explained how to control the set of standby servers when data is committed to PostgresSQL, and that gave birth to another question. What if I ...
0
votes
0answers
11 views
MySQL Group Replication Vs InnoDB cluster
Im just trying to understand the difference between InnoDB vs Group replication
InnoDB cluster is built on top of GR, but what it have additionally than the GR?
When to use group replication and when ...
0
votes
1answer
21 views
MS Azure SQL Server Replication [closed]
I understand the function of the MS Replication Backward Compatibility setting and the information in the Transactional Replication Matrix...a subscriber to a transaction publication can be any ...
-1
votes
0answers
9 views
Sharding and Replication order [closed]
Sharding and replication are orthogonal concepts, and theoretically their order isn't defined.
One can do sharding first and then replicate each shard. This way you get fault tolerance in every shard ...
0
votes
0answers
33 views
PostgreSQL logical replication for async service communication? [closed]
Has anyone attempted to use logical replication with table partitioning for async service communication?
Proof of concept (with images): https://gist.github.com/shuber/...
1
vote
2answers
17 views
MySQL master to master race conditions, do I need to use transactions/locks for this code?
I'm playing around with master to master MySQL replication hoping I can run two copies on my C# application on two different servers to help improve performance. Rather than the one copy on one server ...
0
votes
0answers
24 views
MySQL 5.7 Master-Slave Replication Functional but Not Replicating New Records
I've got a Master-Slave topology set up with the following two servers:
Master Information:
OS: GNU/Linux Centos 7.6.1810 (Core)
Kernel: 3.10.0-042stab140.4
MySQL version: 5.7.25
Server_id: 1
Slave ...
0
votes
0answers
9 views
Cannot connect to mysql server error for master replication
Am trying to connect to a mysql master which is a server running LAMP. It replies with an error "cannot connect to mysql server". Have also tried to connect using mysql -h XXX -u -p from the slave ...
0
votes
0answers
21 views
MongoDB replica set
I am trying to set a MongoDB replica set.
The idea is, having 4 instances in aws:
1 - Nodejs app, a simple webpage, configured to connect to a DB_HOST on port 27017
2 - MongoDB Primary
3 - MongoDB ...
0
votes
0answers
17 views
Mysql 8 Replication and promoting slave to master
I am not using GTID based replication and I have only one master
and one slave. This question is in general regarding Mysql 8 and I want to
be prepared when I have to deal with production systems. I ...
1
vote
1answer
27 views
Best way to generate a report on overall SQL Server performance to show management?
I support a transactional SQL Server as a dba and have recently been told by a management consultant that they need a new replication server set for reporting only, claiming poor performance on the ...
0
votes
1answer
27 views
Transactional Replication failing between SQL Server 2012 and SQL Server 2016 versions
As per the Microsoft documentation - A Subscriber to a transactional publication can be any version within two versions of the Publisher version. For example:
a SQL Server 2012 (11.x) Publisher can ...
0
votes
1answer
24 views
Postgresql Streaming Replication on Windows failover
Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK.
How can i manually use the replica ( it is hot_standby=on ) in case Master fails ?
What are the steps i have to ...
0
votes
1answer
33 views
Login failed for user 'NT Service\SSISScaleOutMaster140'
In times of creating replication by using below query I getting from log
Login failed for user 'NT Service\SSISScaleOutMaster140'
DECLARE @distributor AS sysname;
DECLARE @distributionDB AS sysname;
...
0
votes
0answers
24 views
Transactional replication in sql server 2017 but job not running
I have created transactional replication and here is my script
Distribution script:
use master
exec sp_adddistributor @distributor = N'servername', @password = N''
GO
exec sp_adddistributiondb @...
0
votes
0answers
26 views
AWS DMS Log growth problem - SQL Server as Source
I have a problem using the AWS Database Migration Service for implementing a transactional replication from SQL Server as a source database engine, a help is highly appreciated.
The 'safeguardPolicy' ...
0
votes
0answers
1 view
Is gtid_ignore_duplicates required for mesh masters?
I want to set up mesh replication with 3 masters. Only one will be active at any time, the other 2 will be at standby working as a backup. The idea is to replicate each from each, in a mesh fashion.
...
1
vote
1answer
33 views
How to prevent read replica restarts during high replication lag
We're running an Aurora PostgreSQL cluster, with a single read replica along with the master node.
Periodically, there is very heavy write load which causes high replication lag. This can cause the ...
0
votes
0answers
12 views
Error when adding distribution database to SQL 2014: using sp_adddistributiondb error: Destination path is not valid
I am trying to change the default mdf/ldf paths for a the distribution database when running sp_adddistributiondb and when I do so, I get the error "Destination path xxx is not valid. Unable to list ...
0
votes
1answer
27 views
Do I need to redesign my Database and get rid of foreign keys for successful replication?
I plan to set up MariaDB replication either in master-master or master-slave mode. The main issue I have now are worries after reading this documentation.
We use foreign keys a LOT and we also use a ...
0
votes
1answer
10 views
Is it possible to setup multiple RW Replicas for a database in an AlwaysOn Availability Group?
Can I have multiple RW replicas of an AlwaysOn Availability Group database across different servers? (I.e. two-way replication so that multiple servers can write to the same DB.)
0
votes
1answer
21 views
Is it possible to restore single postgreSql database to PITR?
I have PostgreSQL instance with n databases on it.
Is it possible to restore just a single database using PITR ?
# restore
tar xvfz /var/lib/postgresql/db_file_backup.tar.gz -C /var/lib/postgresql/10/...
0
votes
0answers
43 views
SQL Server Read-Only Database Problem [closed]
Platforms:
Windows Server 2016
SQL Server 2016
SSMS 2018
I have a database and it is in an AlwaysOn and a replication structure. When I try to edit my table in this database (with edit top 200 rows ...
0
votes
0answers
15 views
How to set up MongoDB replica set with podman?
I tried to set up a replica set with podman rootful containers but MongoDB does not accept my members because it does not recognize itself.
The podman host address is 10.88.0.1, and MongoDB instances ...
0
votes
0answers
13 views
How to know SQL Server replication articles replication status
We are using SQL Server replication and we would like to know the articles replication status such like when the articles start updating, when the articles stop updating, how's the speed for ...
0
votes
1answer
23 views
Reinitialize all publications
I have a database with almost 20 publications, and every once or twice a week a random number of publications needs to be reinitialized. I have to go and do it manually then every thing works as ...
1
vote
0answers
36 views
SQL Server Replication How to keep primary key schema at publisher
I have implemented Transactional replication and want to have similar schema structure at both subscriber and publisher end. But while creating the publication, Not For Replication appears in front of ...
1
vote
0answers
47 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
17 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
25 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
66 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
22 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
16 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 ...
0
votes
0answers
24 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
68 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
28 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
19 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
28 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
41 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
21 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
4 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 ...
