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
3,387
questions
1
vote
0
answers
485
views
How to debug a huge MySQL replication lag?
We have an AWS RDS and a corresponding Replica. Once or twice a month the replication lags and does not recover from its own. Our "solution" is to create a new replica and delete the old one....
- 111
0
votes
1
answer
181
views
MongoDB OplogStart Missing
I understand that some times MongoDB secondary data becomes stale at which point, we need to perform an init sync from the Primary instance.
But sometimes we see error logs that look like this:
2022-...
- 103
0
votes
1
answer
428
views
SQL server replication conflicts
Once per week, a snapshot publication is done from a database "myDB" in PROD to "myDB" in PREPROD.
Now in PREPROD we set up a transactional replication between "myDB" to ...
- 145
0
votes
1
answer
361
views
slave on logical replication does not get update real time
I successfully started logical replication on a testing environment. I generate insert on the master for some 60K records using procedure. While the insert process is running, i monitor the slave ...
- 157
-2
votes
1
answer
96
views
PostgreSQL replication options
community!
I am wondering if there are any new extensions/solutions which can replicate not the entire PG cluster but by database?
Logical replication is not an option.
For example, I want my primary ...
- 2,309
0
votes
0
answers
136
views
Replication in SQL Server by Merging a Publisher and Subscriber
I have 2 databases, A and B.
database A contains a subset of database B. I want to replicate any changes on database A (insert, update, delete one way replication) to database B without affecting any ...
- 111
1
vote
1
answer
141
views
is it possible to change postgresql schema on receiver using logical replication?
I have a PostgreSQL 12 database set up to follow a remote database (version 12) using logical replication.
I do not control the sender database.
I need to perform queries on the DB filtering records ...
- 11
-1
votes
1
answer
45
views
Replication between two Cloud Services
Is it possible to implement SQL Server Replication between two disparate cloud services?
For instance, if I have an instance running in Amazon's AWS Cloud Service and another instance running in ...
0
votes
2
answers
633
views
In Azure, what's the best setup for creating a development db with a production db? Replication, mirroring, copying, copy then sync, etc?
Currently in Azure, I have a website (app service) pointing a database (Sql Server). So far so good! Everything is still in development so nothing is live yet. I use EF code first migration with all ...
0
votes
1
answer
3k
views
Monitor logical replication using LSN
How do I monitor a logical replication in Postgresql 12 by seeing the lsn ?
What I have done :
Inspect some colomns on Publisher and Subscriber.
Publisher side :
select * from pg_stat_replication; -- ...
- 157
1
vote
1
answer
411
views
How can I determine which database a replication subscription belongs to?
Following along from https://stackoverflow.com/questions/68720250/cannot-drop-subscription-from-postgresql
It seems in order to drop the subscription, you first need to connect to the associated ...
0
votes
1
answer
849
views
WAL files management
I want to have advice about WAL management. I am expecting a large numbers of wal files (the database is very large and it has like 30 - 40 millions of records in totals) since I am setting up a ...
- 157
3
votes
0
answers
2k
views
Replication instantly fails with 1032 error; Coordinator stopped because there were error(s) in the worker(s)
I have two databases, which I'm attempting to configure in a master-slave relationship (the eventual goal is to set them as master-master, but I'll settle for getting master-slave working at this ...
1
vote
1
answer
282
views
How to disable MYSQL Replication?
I have 2 databases which are replicating each other with no issues. I required a test database server and to avoid installing OS etc, I started a new image of one of the servers (with different ...
- 113
0
votes
1
answer
366
views
POSTGRESQL table replication between 2 servers
I want to to replicate A TABLE from one server A to another B so that A and B always in-sync.
This table on server A has like 4 - 5 million rows, whereas the table B is empty.
What I want to do is ...
- 157
1
vote
1
answer
1k
views
Read Postgres CDC data with Logical Replication via Pgoutput plugin and decode it into textual format
Background: We are running Postgres v13.4 and have enabled logical replication for reading CDC data for a select few tables. We are using the pgoutput plugin and the basic setup is working fine.
Query:...
- 11
0
votes
1
answer
400
views
Multi master vs leader-follower
Sorry if I ask this basic question. I am reading different articles and trying to understand how it works.
Lets suppose I have two master DB(MySQL) in two different availability zone and two different ...
- 1
1
vote
0
answers
321
views
MySQL Replication is online, but stalls with no errors or large transactions
Have a replica that runs MySql 5.6 Replication. It has been running without issue for a long time. Now replication is running, but it pauses on a transaction and will not move until you issue a stop/...
- 11
0
votes
1
answer
126
views
How to replicate between On-Premises and Azure in Mongodb
I have three 3 node cluster on-premises ( 1 Primary and 2 Secondary ). I have same 3 node cluster in AZURE ( 1 Primary and 2 Secondary ) with same version and data but with different FQDN in azure. ...
- 99
1
vote
0
answers
589
views
Pgpool for HA of Postgres with repmgr switchover. Pgpool haw to follow primary
I'm trying to setup a highly available postgres (13) cluster(3 servers) with streaming replication.
I first tried native replication and then decided to use repmgr to manage this so I could use the ...
- 11
0
votes
0
answers
32
views
Cannot connect to PostgreSQL replica [duplicate]
I can't to connect to PostgreSQL replica.
When I try to connect to PostgreSQL replica it shows error message:
psql: error: FATAL: canceling statement due to conflict with recovery
DETAIL: User query ...
2
votes
1
answer
1k
views
How to rollback to earlier SQL Server version without data loss after SQL Server upgrade
We are planning for SQL Server 2019 upgrade from SQL Server 2014 version. One of the requirement from the business owners is that we should be able to fall back to earlier version without data loss ...
- 21
1
vote
1
answer
39
views
Drop Subscriber at SQL Transactional replication
We have SQL Transactional pull replication:
Publisher and Distributor are at the same server - ServerA.
It publicates Publication1.
Pull Subscribers to Publication1 are - ServerB, ServerC and ...
- 11
1
vote
0
answers
247
views
Replicate MySQL table to MariaDB for System Versioning
We have some tables in an operational and busy MySQL database (AWS RDS) for which we require system versioning for some of the tables. (point-in-time queries)
Is it possible to somehow replicate the ...
user5372615
0
votes
0
answers
51
views
MySQL Replication with Data Transformation and Replicant-specific Data
I have two MySQL 8.0.23 RDS's - one "Production" RDS that actual users use, and one "Performance" RDS that is used for performance testing.
These databases have the same schema and ...
- 101
0
votes
1
answer
51
views
SQL Database Replication
I have requirement with below for SQL database replication.
I have two separate SQL database servers on same network, one will be used as primary and another one as secondary.
Primary is a central ...
- 1
0
votes
1
answer
37
views
Can we use a mongodb 4.3.3 and mongodb 2.6.5 in same replica set?
we are running a mongo 2.6.5, 5 member replica set on CentOS and are looking to upgrade to 4.3.3. We do not use sharding. The tricky part for us is that we operate a service and can't have scheduled ...
0
votes
1
answer
21
views
Enabling replication in MySQL in fresh database
We have a legacy TokuDB database that we would like to begin migrating to a new engine. Unfortunately taking the db offline for migration is not feasible. We also can reprocess all the data in the ...
- 113
0
votes
1
answer
203
views
Finding the MySQL binlog positions to restore replication
I have a large database where replication became broken (a query to delete rows ran on the slave directly by mistake)
The decision was taken to restore the slave from the master. I've made an export ...
0
votes
1
answer
184
views
Postgresql Replication issues of clarity
In an effort to document myself I examined a few sources; these two from the official docs and this external one seemed promising
Now the latter one seems to be updated in 2020, but refers to version ...
- 269
0
votes
1
answer
1k
views
Is wal_keep_segments required with streaming replication when archive and restore commands are set?
I have a 2 node postresql(12.9) cluster with streaming replication enabled. I have also set the archive and restore commands which I verified is working as expected. No replication slots or ...
- 1
0
votes
0
answers
346
views
Why is restoring a fresh database from a backup failing due to a duplicate key error?
I'm trying to build a replica from an active database with no downtime for replication purposes.
I run the following statement to get a backup, avoid locking the tables, and flush the logs so that the ...
- 167
1
vote
2
answers
444
views
SQL Server replication between standard and developer editions
I have one SQL Server Standard (2019), I want to add one server for development (not used for production so the Developer edition); is it possible to replicate data from the Standard edition? What is ...
- 11
0
votes
0
answers
116
views
Report (log) of each transaction on SQL Server Replication?
I've configured a transactional type of Replication between two SQL Servers. Since it's a project that it's still under review on my side I have only selected a couple of articles for the replication. ...
0
votes
1
answer
69
views
MySql (local-Online) replication
I am trying to apply MySql replication between a local server (Master) and an online server (Slave) and need your help.
** All names (username – password – server name) are just an example and not the ...
1
vote
1
answer
467
views
fivetran replication from PostgreSQL (connector Broken with WAL log error)
PostgreSQL RDS instance having physical replication to multi-AZ, same instance also enabled for Fivetran replication copying data to BigQuery using WAL logical test-decoding.
Multiple issues here:
...
- 21
1
vote
0
answers
220
views
Which MariaDB-Galera Node Should I Start After Cluster Crushing or Failing?
Sometimes my 3-Node GaleraCluster fails and doesn't serve. When I check I see all of them are activated but two of them are not working, so I check log files I see one of them could not operate an ...
0
votes
0
answers
60
views
ubutun 18.04 I did master and slave replication. before it was working fine but today it stopped all of a sudden I don't know why
2022-04-27T21:57:22.421118Z 2 [ERROR] Slave I/O for channel '': error connecting to master '[email protected]:3306' - retry-time: 60 retries: 1, Error_code: 2003
2022-04-27T21:58:22.810750Z 2 [...
1
vote
1
answer
191
views
Azure Database Performance Throttling - Use Replication or?
We keep a "rather large" azure database where we load all of our company data into every night.
It uses temporal tables to keep track of changes to the data
Now we want to start reading this ...
- 113
3
votes
1
answer
165
views
MySQL replication setup based on an LVM snapshot – am I forgetting anything?
I'm tasked with starting a brand new replica of a client's MySQL 5.7.35 database server. While I've observed others doing this in the past in various circumstances, I haven't been in charge of this ...
- 135
0
votes
1
answer
171
views
Restore SQL Server replication subscriber
We have merge replication in our system and there is a case when we need to deploy our system with subscriber database and time is crutial. I wonder if the is possibility to take configured subscriber ...
- 3
0
votes
1
answer
302
views
Upgrading Logical Replica of PostgreSQL
I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication.
Though the upgrade process of the replica can be done, however the replication ...
- 532
1
vote
1
answer
522
views
SQL Server replication msRepl_commands msRepls_transactions tables growing
I'm not getting any clue how to safely clean up the above tables. Last Friday, these tables had 22m and 6m records, respectively. Over the weekend, the number of rows has been reduced to 10m and 2.5m. ...
- 11
1
vote
1
answer
694
views
How to re-sync the Mysql replication if Master down
I have a very simple webapp infra: FE => BE => MySQL. I have set up MySQL master-slave replication successfully. If my MySQL master node is down, I can manually point the MySQL IP to the Slave ...
- 111
0
votes
2
answers
120
views
Is better to copy value between DB table or create a reference?
I’m at a crossroads, and I don't know which is the best option to choose.
Let's say I have a Table A which contains addresses and other information. As you can expect lot of rows contains the same ...
1
vote
0
answers
212
views
SQL Replication - What is @frequency_recurrence_factor and what must it be set to?
The documentation says:
[ @frequency_recurrence_factor = ] frequency_recurrence_factor Is the
recurrence factor used by frequency_type. frequency_recurrence_factor
is int, with a default of 0.
Does ...
- 253
1
vote
1
answer
464
views
How do I safely drop a table under replication
I have newly set up replication on my Sql 2012 Server. It is working OK.
I occasionally have sql scripts that drop existing tables and recreate them.
However, I cannot drop any table currently under ...
- 73
1
vote
1
answer
503
views
How to modify the Replication Subscription Job/script to make it point an IP Address and a Port number?
I have an SQL Server 2012 server set up replicating one Database. It is behind a firewall. I have poked a hole in the firewall so I can access the server on Port 1433. I am using an IP Address and a ...
- 73
0
votes
1
answer
99
views
SQL Server modification timestamps
I'm implementing ingestion job from SQL Server 2016. For performance reasons we want to implement incremental loads.
Few facts:
Customer has read replica as a part of always on availability group ...
- 101
2
votes
1
answer
4k
views
MySQL 8 Replication
I've got this error message:
Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin....
Ayaa Ahmed