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,179
questions
0
votes
0answers
2 views
MongoDB Replication Info Results
I want to understand the following:
First-Third execution of db.printSlaveReplicationInfo() results to “0 secs (0 hrs) behind the primary”
Fourth execution of db.printSlaveReplicationInfo() results ...
0
votes
0answers
11 views
ERROR: Error when fetching backup: pg_basebackup exited with code=1 when start patroni service for a replica
I created a cluster including 3 servers via Patroni. Everything was alright like failover, switchover... but when I try to add another replica server I am getting an error like this:
Eki 25 13:19:22 ...
0
votes
1answer
17 views
PostgreSQL 13.4: Setting synchronous_commit using ALTER SYSTEM doesn't change it
We're currently building a PostgreSQL cluster using PostgreSQL 13.4, Patroni, Consul and Confd. The setup was successful (Patroni cluster is replicating with one master and one replica), and we are ...
0
votes
2answers
15 views
MySQL replica lagging but reporting no lag
I have a primary MySQL DB with a secondary replica which, apparently, works perfectly.
The replica is connected through a VPN, which reports no problems.
SHOW SLAVE STATUS reports zero seconds behind ...
0
votes
0answers
12 views
Replication from AWS RDS to MySQL fails because of unknown character set?
I have an RDS instance running MySQL 5.7, which I have configured as replication master, and a MySQL 5.7 running on an EC2 instance (Ubuntu 20.04) as slave. The replication breaks instantly with:
...
0
votes
0answers
8 views
Where Should I Install Galera Load Balancer? On Cluster Nodes?
I want to install Galera Load Balancer for my 3-Node Galera Cluster, but where should I install the galera load balancer? Can I install on the cluster nodes or should I build a new server for galera ...
1
vote
1answer
40 views
How do I prevent a column being replicated in SQL server?
I'm on MSSQL 2016 using push-based transactional replication to an Azure instance. I have a few columns in our modeled data that I really do not want to replicate.
Is there a way to flag a column as &...
0
votes
0answers
11 views
Partial One to Many DB replication
We operate a number of self-service terminals. We have a central DB that holds all the data in several tables and then there are local DBs in every terminal that have the identical schema to the ...
0
votes
1answer
16 views
replicate-wild-do-table=channel_name:db_name.% doesn't work in MySQL 8.0 for channel based replication
I am trying to configure a replication topology where there will be one slave which will connect to two masters. Percona Server 8.0.25.
Master1- main master
bkp_server - slave to master1 and ...
1
vote
1answer
27 views
Calling triggers on replicated table when reinitalising from snapshot
I noticed my triggers weren't being fired after a subscriber was reinitialised. Is there a configuration to allow this functionality.
Currently my setting for 'Action if name is in use' is 'Delete ...
0
votes
1answer
26 views
How to Prevent the Connections for MariaDB Galera-Cluster When There is Only One Active Node?
I was using "rsync" as the wsrep_sst_method in my galera.cnf files on 3-Node Galera Cluster. When it was so, the system served when there was at least 2 active node. So when any two node ...
0
votes
0answers
20 views
MariaDB upgrade fails on replication slaves
I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching.
The system has several slave ...
0
votes
2answers
16 views
WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly
My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
0
votes
1answer
28 views
MariaDB Galera 3-Node Cluster Sometimes Doesn't Serves
I have 3 Node MariaDB Galera cluster. I am using "mariabackup" as the wsrep_sst_method, but the database system doesn't work properly. I can say that sometimes there are 100 connection ...
0
votes
1answer
9 views
What are best practices for incremental replications?
I'm working on a tool to replicate data from several different source DBs (used by the same company, but different vendors and versions) to one centralized analysis platform (for the purpose of this ...
0
votes
1answer
37 views
Performing operation on transactional insert
Using MS SQL Server to replicate data between 2 servers for security purposes. Is it possible to perform an operation on the data sent from the publisher database before it is inserted into the ...
0
votes
1answer
30 views
MySQL slave stuck on Applying batch of row changes (read)
Might be duplicate of:
MySQL slave stuck on Applying batch of row changes (write)
or
MySQL8.0 Replication Got Stuck "Applying batch of row changes (delete)"
I am trying to use MySQL 8.0.26 ...
0
votes
0answers
13 views
Bucardo Race Condition
I have an application that uses multiple PostgreSQL databases and Bucardo to sync between the various master/slave nodes. I'm seeing a race condition where bucardo dies on a master node and doesn't ...
0
votes
1answer
28 views
Importing MySQL dumps to multiple MySQL instances in one machine
In case of title is not clear, I would like to explain myself further.
I have 6 MySQL instances in my server.
Let's call them, M1, M2, .., M6.
The reason I have 6 MySQL instances here, I have also ...
0
votes
0answers
19 views
Postgresql pg_logical sequence replication not synchronized
I'm testing pg_logical extension for Postgresql because we need to replicate some clusters with Postgresql 9.6 before upgrading them to newer version, where logical replication is a core feature.
I've ...
0
votes
1answer
26 views
PostgreSQL 12 dropped replication slot but standby is still trying to contact the primary
We have recently decommissioned a standby that was experiencing some hardware issues from our streaming replication cluster. We were able to successfully stop the PID on the primary and then drop the ...
0
votes
0answers
33 views
MySQL replication out of AWS RDS lagging
I have a very large database in RDS - just under 3 TB. I have set up a replication slave in an EC2 instance (t2.xlarge with io1 disk volume for data). OS is Debian 9, DB is MySQL 5.6.
The problem is ...
0
votes
0answers
31 views
Kubernetes - Replicated stateful mySQL database
Helloo
This is the scenario:
I have a cluster on gke with apache, mysql and keyrock and i would like to scale it up with horizontal pod autoscaler.
For mysql i am using statefulset and the code is ...
1
vote
1answer
31 views
Mariadb - Master/Slave both out of sync bin log files - 1236 error
As we have "purge" enabled and one the nodes went offline, so now we have out of sync bin log.
I guess, I need to stop the slave, set the master to use the current bin log and start the ...
0
votes
0answers
24 views
Does collation effect SQL Server replication
I've been getting a replication error for some time now between my Publisher and Subscriber databases (SQL 2016). The error is the classic:
"42000 The row was not found at the Subscriber when ...
2
votes
1answer
41 views
Postgres difference between restart_lsn and confirmed_flush
According to the documentation, restart_lsn is
The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints...
...
-2
votes
1answer
70 views
Relational database with Kafka-like durability/caching implementation
When reading about Kafka I found it really interesting how they are providing durability, especially in comparison to databases:
Kafka - never writes synchronously to disk, provides durability by ...
0
votes
1answer
26 views
mysql/mariadb replication with proxy
I have a standard master-slave replication for MariaDB to sync one database (master) to multiple slaves. One of the slaves lives behind a proxy, so I need to proxy the replication request to the proxy ...
1
vote
3answers
34 views
SQL Server replication additional subscriber
I have a publisher with the distributor on the same server which is transactional replication.
There is also an active subscriber using push method.
I need to set a new subscriber up going to a ...
0
votes
2answers
17 views
How to organize MongoDB replicaset backup and alerting
I have a running MongoDb replicaset consisting of 2 replicas and 1 master nodes. Recently I noticed that my master gone and automatic failover took action and changed master, however I wasn't aware of ...
0
votes
1answer
29 views
postgres: reset pg_last_xact_replay_timestamp()
We have a pg10 replica that got promoted to master and have monitoring around the following query to monitor replication
SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp())) as lag
...
1
vote
1answer
55 views
MS-SQL transactional replication - How to figure out how much data is being pushed per day in replicated databases
We use MS SQL Server transactional replication in our environment. I would like to know if there is a way or script to figure out how much data is being pushed per day to replicated databases?
How to ...
0
votes
1answer
13 views
Sql server transactional replication latency
I'm analyzing the distribution database to see if there any latency in the replication between publisher and subscriber
The architecture is one publisher, 1 distrubution db (on publisher server) and ...
1
vote
0answers
30 views
Mysql 5.6 tmpdir change deletes some users
We have a Percona-mysql 5.6 setup with one master and one replica.
After trying to do a big ALTER TABLE on it, it failed because the tmpdir was inside of the memory and therefore wasn't big enough.
...
1
vote
1answer
11 views
Does Azure Mariadb/Mysql data-in replication support certificate chains?
I would like to migrate from AWS RDS Mysql to Azure Mariadb managed database.
For this purpose, I would set up data-in replication using TLS, roughly following the provided guide.
AWS provides ...
0
votes
0answers
15 views
display the transaction for a given GTID in MySQL
is there a way to show the statements of a transaction for a given GTID ?
I know the binlog, if the correspond binlog file was not purged, can be used, but I'd like to know if I could see any ...
0
votes
0answers
32 views
PostgreSQL- replication server lags behind the master - memory usage too high
we have a classic physical replication with primary and secondary nodes. The two nodes are also monitored by software.
There are always lags between the primary server and secondary server when there ...
0
votes
1answer
44 views
oracle goldengate replication
Please I need help. Actually i am working on oracle 19c to perform a data base replication using the goldengate. I created two data bases (source and destination) the 3 processes (extract, pump and ...
0
votes
1answer
106 views
What does it mean when slave status shows SQL running but IO not running?
What exactly does this mean, when the SQL is running but the IO is not running on the Slave in a Master-Master replication setup?
There are no other errors showing when running show slave status\G
...
2
votes
0answers
24 views
mySQL cluster with Active Active DC
Let me give you a bit of background before jumping into the discussion.
Our company is running two DC's in active active scenario, we spent a lot of money on getting specialized hardware to be ...
1
vote
1answer
34 views
Postgres schema based replication
I have setup streaming replication in postgresql V10 in the production environment. Now for a typical scenario, I would like to know if I can configure replication in such a way that only specified ...
2
votes
0answers
62 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 ...
0
votes
1answer
35 views
Is there a way to setup one Alert for all Replication errors?
I have a SQL Server 2016 (Standard) instance, with DatabaseA, who is the Publisher in a Transactional Replication (push subscription) topology. A second SQL Server 2016 (Standard) instance, with ...
0
votes
0answers
24 views
Large number of row locks on a partitioned slave table
I am testing mysql5.7.28 partition. Table in master is not partioned. The table in slave is partitioned. When I start the replication, slave lag keeps on increasing.
This is the table schema in master
...
1
vote
1answer
18 views
restarting master and slave machines without breaking master slave MySQL replication
We need to resize the size (CPU and RAM) of two database servers having MySQL server 8: master and slave, but this operation implies that those machines will be restarted, And I think a restart of ...
0
votes
1answer
23 views
Replicating to 3 databases one is web server
I have a customer that is looking for a very unusual replication configuration. I am hoping for some insight on why this is a bad idea, or even the possibility that it can be done.
There are two ...
0
votes
0answers
13 views
Replicating multiple unrelated servers
We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
2
votes
0answers
28 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
16 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
20 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 ...
