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
1 answer
174 views

Mariadb replication - Ignore users changes

I posted this question on ServerFault but was told to ask it here. I need to set up multi-source replication (3 masters and 1 slave). I'd like to avoid replicating users' changes on the slave because ...
0 votes
1 answer
231 views

Problem in PostgreSQL replication - ALTER DATABASE

Recently I put to work a Master/Slave replication in my PostgreSQL (9.3). Everything is ok... insert, update, delete, in data and changes in tables... but when I changed the data base name the ...
0 votes
1 answer
19 views

Read Replica block queries postgres

I've RDS PostgreSQL DB with read-replica. Also, have one script which frequently checks the blocking query but I faced one issue yesterday where the blocking query was a startup(backend_type)process ...
0 votes
1 answer
701 views

Does a read replica help if the problem are heavy queries?

The application that our team is responsible for is having ever more often DB performance problems. The application querying it doesn't throw lots of concurrent queries, the problem we have are rather ...
0 votes
2 answers
21 views

Internal Paramaters on sp_MSdel<TableName>, sp_MSins<TableName>, sp_MSupd<TableName>

The following procedures sp_MSdel, sp_MSins, sp_MSupd are the outcome of an configured publication/subscription on SQL Server. These procedures let you do small transformations inside them so the ...
1 vote
1 answer
338 views

master-master replication or master slave replication?

We have right now one server with a database. A device and a website are accessing that database causing load What I want is to create two servers master-slave where master databases are replicated ...
1 vote
1 answer
38 views

Error in the documentation MariaDB -> mysqlbinlog: `--rewrite-db` and `--database`

In the mysqlbinlog utility documentation, the --rewrite-db=name option has the following explanation Filtering (e.g. with --database=name ) happens AFTER the database rewrites have been performed. ...
1 vote
1 answer
564 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
2 answers
289 views

MySQL replication - independent data update on slave

I have an unusual situation where I am migrating websites and their corresponding databases from one server to another. I have a database that is hosted on one server, A, where new records are ...
3 votes
1 answer
643 views

Avoiding a full re-initialization when making changes to transactional replication

When I use the GUI to make any changes to transactional replication on SQL server, I live in fear of the "the changes you have made require a reinitialization of all articles" dialog. I have had ...
6 votes
1 answer
239 views

SQL Server Replication

We had an issue with replication, where a large (7.5 million row) update was done on a 33 million row table. Replication converted that to 7.5 million individual update statements. When my alerting ...
0 votes
1 answer
37 views

Can Cassandra nodes running in 2 different DCs on K8s behind NAT on private subnet form a cluster?

Is there anyway Cassandra nodes running in two different data centers behind NAT, on private subnet can form a single cluster? Use case: For an on premise Geo-Diverse setup, we needs to run Cassandra ...
0 votes
1 answer
244 views

Is there a way to synchronize mysql databases that are missing a few days worth of data

I have a primary-primary MySQL server setup that is connected to a load balancer. At one point, a failure occurred to where the replication wasn't happening and data was being written to one server ...
0 votes
1 answer
19 views

Troubleshooting foreign key dependency error when setting up new MariaDB replica

Question: Does anyone have advice on what I can do to successfully get this new replica set up and replicating from our production server just like the old replica? Details: I am trying to set up a ...
0 votes
1 answer
582 views

What is the use case for Cascading Replication in PostgreSQL?

What are the advantages of cascading replication in PostgreSQL? I have done testing with three nodes. M1 ----> S1 -----> S2 What is the use if my primary server (M1) goes down (failover)? Where ...
0 votes
0 answers
15 views

pg_replication_origin_status returns NULL external_id

When i run pdns=# select * from pg_replication_origin_status ; local_id | external_id | remote_lsn | local_lsn ----------+-------------+------------+----------- 2 | | 0/7D56538 | ...
0 votes
1 answer
387 views

Renaming multiple databases on a MySQL slave

I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
1 vote
2 answers
24 views

Change Tracking SYS_CHANGE_COLUMNS on Update operation

I would like to get an understanding of why on an update operation in the change tracking table, the SYS_CHANGE_COLUMNS can be NULL. I would expect the SYS_CHANGE_COLUMNS will be populated. In the ...
0 votes
1 answer
2k views

invalid integer value "CONNECTION" for connection option "port" Previous connection kept

I'm new to postgres and I'm trying to configure table level logical replication(PUBLICATION/SUBSCRIPTION) on postgres-12. I have updated postgresql.conf file and updated wal_level=replica. Also, then ...
0 votes
1 answer
650 views

Replication Server version 15.7.1 - Sybase ASE 15.5, how to change primary data server in RSSD?

Recently, I am requested to migrate the current Sybase data server to a new Sybase data server (let's say, from pub1 to pub2). To do this, I need to rebuild all the RepAgents which have been set up ...
1 vote
1 answer
20 views

Does hidden priority-0 replica count when calculating fault tolerance?

We have a mongdodb cluster with 3 replicas in one. We are planning to add one more replica on cloud. The replica on cloud is set as hidden and priority-0. If we include the hidden the total no. of ...
0 votes
1 answer
3k 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; ...
1 vote
1 answer
175 views

In MySQL replication, why aren't queries run on the slave when there was no USE statement on master?

We have replication running from our master server to a slave. binlog_format is the default; mixed. We have noticed something weird and are not sure whether it's a bug or intended behaviour. Certain ...
0 votes
1 answer
13 views

SQL Server 2016 Transactional Replication with Service packs on 2 Servers

Transactional replication: If Server A has Publisher and Distributor with SQL Server Service pack 1 and Server b is Subscriber with SQL Server 2016 service pack 2 Does publisher and distributor (SQL ...
5 votes
1 answer
501 views

Mysqlfailover command - No slave is listed in health status

I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command. mysqlfailover --master=root:abc@10....
0 votes
1 answer
22 views

SQL Server Merge Replication bulk delete leaves subscriber databases large

We have SQL Server 2017 merge replication set up with three subscribers (running SQL Server 2017 Express). We need to clear data from the server database occasionally to reduce the database size at ...
4 votes
2 answers
823 views

advantages of single-leader (transactions) over multi-leader replication

I am reading the excellent book "Designing Data-Intensive Applications" which I wholeheartedly recommend, but I'm confused by a section comparing multi-leader (i.e. multi-writer) replication to single-...
0 votes
1 answer
25 views

Backup master - slave replication

On a master-slave replication setup (1 master with 2 slaves. the slaves are hot standby in case the master fails). How can I do a backup under normal circumstances? Are all nodes are backed up ...
1 vote
1 answer
34 views

Merging data from identical tables from multiple databases into one larger table. N-1 table replication

There are N databases with identical table structures in a multitenant, multi-database system. The desire is to replicate a table(s) from these databases into a single larger table in a OLAP database, ...
1 vote
1 answer
605 views

Get position of mysqlbinlog error. I have the error's line number

If I use mysqlbinlog to load a binlog into my database like this: mysqlbinlog --defaults-file=/path/mysqld.cnf bin.000011| mysql -u root and get an error like this: ERROR 2006 at line 290: MySQL ...
0 votes
2 answers
27 views

How to perform mysqldump and import simultaneously?

I have a master database and a slave one. Recently, the slave has not synced with the master. So, I tried running mysqldump command to the master: mysqldump -h <master_host> -u <user> -p &...
2 votes
1 answer
912 views

Postgresql 11: terminating walsender process due to replication timeout

I have found some questions about the same error, but didn't find any of them answering my problem. The setup is that I have two Postgres11 clusters (A and B) and they are making use of publication ...
3 votes
1 answer
8k views

Permanent count of waiting tasks (2) in Activity monitor

Now I'm observing in Activity Monitor permanent count of waiting tasks: and at "Resource waits" tab I see next: so, my question is: How to find and resolve this wait tasks? I suspect that it ...
1 vote
1 answer
21 views

Schedule replication overnight

I have a MySQL database, where approximately 3.5 million entries are been inserted/updated daily. For some heavier data analysis I would like to create a replica. Is it possible to schedule the ...
2 votes
1 answer
280 views

Identity management in Transaction replication with updatable subscription

I have migrated my publisher DB to new server yesterday. For migration what I did was removed subscriptions and publication completely backed up DB on which publication was configured restored DB to ...
1 vote
1 answer
212 views

MySQL Replication ERROR 1130: error conecting to master

I'm having difficulty connecting MySQL slave database to master using MyWorkBench. I tried: executing CREATE USER 'replication'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON . TO '...
1 vote
1 answer
491 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 ...
2 votes
1 answer
417 views

Mariadb-10.0.30 Replication drift

We've configured 4 mariadb 10.0.30 slaves, the master also has the same major version and about the same hardware (32 cores, 128Gbs ram, 4.4Tb of data on ssd raid), everything was running fine until ...
0 votes
0 answers
21 views

Multi master with some slaves vs single master with some slaves

I need some advice on architecture. I have a national database that relies on postgres and some architectural design that involves orchestrating several components, very much similar to the picture ...
1 vote
1 answer
30 views

MySQL 8 replication: is it possible to specify master side a specific port for replication, and only replication (different than the default 3306)

Master side. In MySQL 8 for the replication, is it possible to specify master side a specific port for replication, and only replication that is different than the default 3306 where regular clients ...
1 vote
1 answer
2k views

Connectivity issues in replication process

I've been trying to add a new node to a replica set without success due to these errors: 2019-08-12T06:48:15.031+0200 I ASIO [NetworkInterfaceASIO-RS-0] Ending connection to host mongo03:...
1 vote
1 answer
519 views

Conditional MS SQL replication

I have an issue that I want to do conditional replication to one of my enterprise level client databases. This database is very large: approximately 300 GB MDF file and a 160 GB LDF file because of ...
0 votes
1 answer
438 views

Add column to database, used with logical replication generates large WAL files

I have a PostgreSQL 10 master database with a logical replication, but I faced with an issue. I added one more column (int, without default value) to a big table in master (weight 39gb, over 100 ...
0 votes
1 answer
628 views

CDC error - Error converting data type varchar to uniqueidentifier

I have CDC and Replication configured on an Always On cluster. I had to patch the SQL Server on Node 1 so I failed over the instance to node 2 and started patching node1. After about an hour one of ...
0 votes
1 answer
80 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
349 views

Mysql slave status is completely perfect but data is not reflecting

I have setup replication using mysql utilities. Slave can able to read and execute master's position and binlog files perfectly. seconds_behind_master is also 0. But data is not reflecting into slave. ...
1 vote
1 answer
302 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
1 answer
460 views

Insert into table select - Replication lag - Percona Server 5.6

I have two MySQL instances (Percona server 5.6.31) in Master-Slave replication setup. I have set the below configuration: ROW based replication is set. Transaction Isolation is set to read-committed....
0 votes
1 answer
250 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 ...
2 votes
1 answer
352 views

Transactional Replication breaks when schema is changed in Publisher

We have set up Transactional replication where two Publishers feed into one Subscriber. Now if try to change the schema of any one Publisher or both publishers, replication breaks. We have tried to ...

1
2 3 4 5
68