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,147
questions
1
vote
0answers
14 views
Issues with failback for logical replication using postgres
I am using PostgreSQL 13 to set up logical replication. When the original active node (A) becomes the secondary, the prior secondary(B) which is now active node needs to sync to the (A) node.
To ...
0
votes
0answers
9 views
MSSQL P2P Replication , after add subscription slow on initialization
I am creating a new peer to peer replication.
First, I backup my database from master server and restore it into secondary server.
Then, I run below script on both of my "master server" and &...
0
votes
0answers
12 views
CDC on secondary from different replication schemas - analysis
We have a mission critical database in Sql Server 2016 (Std) and we are not authorized to alter the schemas because of legal issues with the software provider. We need a way to have CDC in that ...
0
votes
0answers
14 views
Issue with pg_basebackup
I am trying to create postgres replication to another server. But while create base backup., I am getting following error.
Pg_basebackup: could not send replication command "IDENTITY_SYSTEM":...
0
votes
0answers
9 views
How to switch the Slave Server (Standby Mode) to Normal Mode to PITR in postgres? [closed]
Description
I have Two Server (Master and Slave).
I have set up the Slave server in such a way that the slave server is delayed 3 days from Master Server.
Now I want to start PITR from Slave Server. ...
0
votes
1answer
13 views
Limit size of WAL files for PostgreSQL database
I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension.
Recently, one of the application migrations has updated the schema of the ...
1
vote
1answer
52 views
RDS Postgres oldest replication lag increases during inactivity even though Fivetran connector keeps synchronizing
I'm in the process of setting-up a datawarehouse using Fivetran as the ETL layer. One of the source databases is a AWS RDS Postgres instance.
I've configured the Postgres instance to perform Logical ...
1
vote
0answers
35 views
Sql Server Replication Slow when Downloading to Publisher
I got a very weird problem.
On a SQL Server 2017 Standard and with MERGE replication with job run at subscriber.
The problem happens in 2 out of 4 of our customers environment.
The configuration is as ...
1
vote
0answers
22 views
MySQL Replication stop after a huge amount of transactions on Master
Running MySQL 8 for months now, without much troubles, I still have randomly some problem of replication between the Master and its Slave.
Problems means, all works, both instance works, still the ...
0
votes
1answer
14 views
ALTER TABLE statements not replicating in all tested scenarios - MariaDB
Summary
Tech: mariadb 10.3
Issue: some attempts to ALTER TABLE to change engine is not replicating.
Scenarios tested:
command line PHP script running ALTER statements using PDO - did not replicate
...
0
votes
1answer
25 views
Strange replication failure on date field under MySQL 5.7
This problem cropped up yesterday and I'm quite stumped. I have a primary RDS cluster that is running MySQL 5.6 and RDS is forcing everyone to 5.7 soon. I have a smaller standalone replication slave ...
1
vote
1answer
12 views
How do I restore all replicated MySQL servers from a backup?
I've got two MySQL 5.7 servers running with binary log replication. I now need to rollback to an older backup but I'm not sure what effect this will have on the binary log for replication.
If I just ...
0
votes
0answers
29 views
SQL Server Replication - accidentally unselected table from snapshot: how do I add it back in again?
Using SQL Server merge replication, one of the tables was accidentally unselected (check box unticked). How do I add it back in to the snapshot again? It was unfortunately a large table with plenty ...
1
vote
2answers
37 views
Is there a mysql feature to allow parallel replication per query?
When adding columns or indexes to big tables in a master salve setup, replication lag occurs.
My understanding is that replication occurs in a single thread on the slave, and statements get executed ...
0
votes
0answers
11 views
Timestamp is off by an hour When Migrating from Mysql to Sql server AWS DMS
We are trying to migrate a MySQL database on AWS RDS to SQL Server Database on AWS.
Both the Source and Target Database are created in PST Time zone.
Replication Instance Version : 3.4.4 Mysql Version:...
0
votes
1answer
22 views
Merge Replication Subscriber does not Expire or cleaned up
I have a merge repliaction with retention period set to 1 day. Allow anonymous Subscriptions is set to False.
I Add 2 subscribers. One of the subscriber machine name is wrong, so it is inaccessible. ...
0
votes
1answer
19 views
How Can I Find the Problems Occurred on MySQL-MariadbDB Systems?
I have built a three-node galera cluster, so it is a Master-Master replication structure. But sometimes the first node goes down and I can't find the problem causing this. I am only looking at /var/...
1
vote
1answer
37 views
Is there any way to monitor if all columns in an article is published in replication
In replication, if we add a column in Publisher then it doesnt replicate to Subscriber unless it is done explicitly. I am looking for a way to track or monitor this.
I am not able to find any system ...
0
votes
1answer
18 views
Mysql Replication trigger not executing on slave
Mixed replication is enabled.
MySQL master has a table Products that has triggers on update and delete. On slave database we have different trigger on same table on update and delete.
Master database ...
0
votes
1answer
24 views
Mysql replication, replica not running inserts
I was trying to rebuild a MASTER - MASTER replication after a server reinstall and ran into a replication error after starting the slave.
MASTER conf:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
# ...
0
votes
1answer
15 views
Error on adding an arbiter
Adding 5th node getting an error
"Our replica set configuration is invalid or does not include us
Presently all 4 nodes are healthy.
node
arb1
arb2
rs1
m1,m2,m2
a1
when I try to add a2 both ...
0
votes
0answers
64 views
The SQL Server replication subscriber cannot start: 'No agent status information is available.'
I am trying to run merge replication of the database between two servers (both are SQL Server version 15).
Both servers are in the domain. On both I am logged using this domain account (all server ...
1
vote
1answer
23 views
PostgreSQL Replication to a Different Schema
I want to consolidate 3 different production databases into a single reporting database.
Let's say we have 3 production databases:
Prod 1
Prod 2
Prod 3
What I want to do is to replicate data from ...
0
votes
1answer
15 views
Does GTID have only benefits in MySQL over “standard” Replication?
I'm used to setup MySQL replication in the old-fashioned way and notice now there is a method using GTID. From what I read, GTID is presented has an improvement over "standard" replication.
...
5
votes
1answer
51 views
postgresql: Replaying of streaming WAL files is slow on some standby servers
Environment: Postgresql 9.6.21.
Multiple standby servers managed by patroni
+ Cluster: db11 (12345678901234567) ------+---------+-----+-----------+
| Member | Host | Role | ...
0
votes
0answers
20 views
MySQL replication server as proxy/intermediary? [duplicate]
My current infrastructure is composed of a master MySQL server and a number of slaves, all connected via a private network not accessible via Internet.
I need to create another slave located outside ...
0
votes
0answers
20 views
Restore the distribution database to production database
I was trying to set up my SQL server for replication. I accidentally added my production database as the distribution database. Is there any way to revert the changes without losing any data in the ...
0
votes
1answer
19 views
Why slave_parallel_workers affects TPM
I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM.
As far as I understand, ...
0
votes
0answers
20 views
Privileges of mysql/mariadb replication accounts
I've created a replication account on a master(server1) and client(server2). This is the output of SHOW GRANTS FOR 'repl'@'192.168.1.%'; on a master;
GRANT REPLICATION SLAVE, BINLOG MONITOR, ...
0
votes
0answers
32 views
BUCARDO - PL/Perl function “validate_goat” at /usr/local/bin/bucardo
I'm new to Bucardo, I have been trying to replicate PostgreSQL-12 using Bucardo with no success due to the errors.
DBD::Pg::st execute failed: ERROR: DBI connect('dbname=test1','bucardo',...) failed:
...
2
votes
1answer
44 views
Data missing on Subscriber Database in SQL server transactional replication
We have Transactional replication set up between a server 'A' and server 'B', where the Data from 'A' is getting replicated on the server B as database "B".
There is an issue reporting that ...
0
votes
0answers
38 views
Postgres Switchover Failed - ERROR: requested starting point AF/7D000000 on timeline 1 is not in this server's history
My switchover to the standby replication was failed. So I have moved towards bringing it up. DBs are online but I see the log file like this:
2021-06-15 16:59:40.339 CEST > ERROR: requested ...
0
votes
1answer
28 views
MySql Replication: Access Denied
I am trying to migrate between cloud providers, using MySql Replication to copy data across live so we can switch with no downtime.
Current setup:
2x Windows servers with old provider, with MySql 8 ...
0
votes
1answer
59 views
Postgresql Physical Replication vs Logical Replication?
I have reading about difference between logical replication slots and phyiscal replication slots in Postgres. I am confused about some paramters and how they are used.
For a replication slot, we have ...
0
votes
2answers
26 views
ALTER ROLE on replica
I have a primary server, with a secondary replicating it.
I want to change a role from LOGIN to NOLOGIN.
I can do this easily on the primary, but the change doesn't replicate to the secondary, and I ...
0
votes
1answer
17 views
MySQL Replication from On-Premises to AWS
I have an on-premises DB server running MySQL 5.5.37 with multiple databases.
I created database on the AWS RDS.
The idea is to set the replication from on-premises to the AWS, but for only one ...
0
votes
1answer
16 views
MySQL replication username
What is the difference in using these two approaches when setting master-slave replication:
Setting the binlog-do-db option on the master to choose which DBs are going to be replicated;
Creating a ...
0
votes
1answer
13 views
Replication setup
Currently, I have a production setup which consists of one Primary server and one Replica server, lets call them Primary1 and Replica1. All databases from Primary1 are replicating to Replica1.
Now, I ...
0
votes
1answer
56 views
Clickhouse Replication without Sharding
How to make replication (1 master, 2 slave for example) in ClickHouse without sharding?
All I can see from the examples are always have sharding:
Altinity Presentation
Docker Compose Example
...
0
votes
2answers
34 views
Is Postgres insert performance the same in the replica
We've got a Postgres database with a table that takes heavy select, update and inserts that needs some tuning (it has too many indexes).
We have a read replica, and I'm wondering if moving all of our ...
0
votes
1answer
32 views
MSSQL peer to peer replication what is the best practice to drop and create multiple table
I have a Transactional Replication server in peer to peer topology with 3 server node.
My development strategy was Agile, so that will be a frequency change on the database etc.
Scenario: I need to ...
0
votes
0answers
31 views
Cross contamination in replication
I have the following scenario:
Pub Databases:
db-A
db-B
db-C
Sub Database:
db-Sub
Table in Pub:
db-A.T1
db-B.T1
db-C.T1
Table in Sub:
db-X.T1_a
db-X.T1_b
db-X.T1_c
Replication:
db-A.T1 -> ...
0
votes
2answers
32 views
Is there an automatic way for a secondary member to promote to primary member in a replica set?
Here is my setup:
Node 1 = 10.1.0.1 (Primary) - priority 1
Node 2 = 10.1.0.2 (Secondary) - priority 1
Node 3 = 10.1.0.3 (Secondary) - priority 0
In the event of Node 1 failure, Node 2 will be set to ...
0
votes
0answers
36 views
Editing file /etc/mysql/my.cnf for Master-slave repllication
here is my "my.cnf" file:
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" ...
0
votes
0answers
13 views
MySQL Backup and Restore
I have a specific situation and I will try to explain as much as I can.
L1-Master DB1 (Slave for L2-Master DB1)
L1-Slave DB2 (Slave for L1-Master DB1)
L2-Master DB1 (Slave for L1-Master DB1)
L2-...
0
votes
2answers
81 views
How to replicate from Standby mode database
I have set up a pipeline which brings transactional logs each hour from a FTP site, and this newly created database is in Standby mode all the time because I need to read data during an office hour.
...
0
votes
1answer
30 views
Efficiently DROP huge table with cascading replication in PostgreSQL
What I have:
Database: PostgreSQL 9.3
Table T,
Structure: 10 integers/bools and 1 text field
Size: Table 89 GB / Toast 1046 GB
Usage: about 10 inserts / minute
Other: reltuples 59913608 / relpages ...
1
vote
1answer
41 views
How do I stop a master from being a master in mariadb
I have a database which used to be setup as a master in a topology. Now I want to remove it as master, and make it a replica. How do I do this?
Is there something similar to how to stop slave but for ...
3
votes
1answer
65 views
Measuring Always On Availability Group potential data loss
I have read these articles few times. I do monitor potential data loss today using some of the methods described in these articles.
Measuring Availability Group synchronization lag by Derik Hammer
...
1
vote
0answers
18 views
Create logical replication along with normal replication [closed]
I need to replicate only some of the tables from my Master Postgres.
With Google search, I got to know that it is possible with logical replication from Postgres10.
I already have a read-only replica ...
