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,209
questions
0
votes
0answers
10 views
MySQL replication with read/write tables
I'm trying to implement replicas between master database and secondary databases. I've tried binary replication - it works as suggested. But I want use some service to manage this without manual ...
0
votes
0answers
19 views
How to specify a sync source when adding a new member to a MongoDB replicaset?
Recently we had a machine physically destroyed, so our replicaset is now: Primary - Secondary - Arbiter (250G on disk, 20G (70hrs) oplog).
So, I'm trying to add a new member (4.4.10) to the replicaset ...
1
vote
0answers
13 views
max_replication_slots in RDS replica
We have enabled the on-prem PostgreSQL (Source) to AWS-RDS (Target) replication by following the official guide and which is worked well. Our RDS cluster has multiple replica's and am trying the ...
0
votes
0answers
15 views
MSSQL DB Replication
I need changes of production DB to be synced to another DB that is in a remote location.
I have tried transactional and snapshot replication.
But in transactional replication primary key is the issue ...
1
vote
1answer
20 views
What does running "show slave status" on a master server show?
We are using monitoring software that is throwing an error saying that Slave_IO_Running is returning No for replication on our master server. It is in fact true that when running show slave status on ...
0
votes
0answers
33 views
MariaDB replication error 1236: 'Could not find first log file name in binary log index file'
I received an error during MariaDB replication that I'm not sure how to fix. Replication is a new topic to me and I acquired these databases and their architecture through a job, so I've done some ...
0
votes
1answer
17 views
Best practice for data archiving
I am trying to figure out the best practice for data archiving. I have 1 pair of Master/Slave MariaDB servers where data is replicated from Master to slave. Since this is a very old app I am not able ...
0
votes
2answers
14 views
can we use one arbiter server in two different replica sets of MongoDB?
can we use one arbiter server in two different replica sets of MongoDB?
I had one replica set with
one master
one slave and
one arbiter server
so want to use the same arbiter server in another replica ...
2
votes
1answer
35 views
Transactional Replication vs AO for MS Sql Server
When we set up web servers in AWS, we have a load balancer which allows highly scalable performance improvements per instance provided.
I would like something similar for MS Sql server. I have been ...
0
votes
0answers
16 views
How to replicate a table inside another database in PostgreSQL?
I have two services in a microservice environment (service A and B) that each has its own database (the PostgreSQL instance is shared currently, but might not be in the future)
I want to replicate the ...
-1
votes
0answers
13 views
Postgres High Availablility multi-master replication on kubernetes
I'm trying to implement an multi-master replication on Kubernetes for Postgres database with High availability.
If anyone tried this, Please help me
I tried multiple ways, which are available in ...
1
vote
1answer
44 views
Is there anyway in sql server transactional replication to not drop the target tables?
I have transactional replication setup between Server1 database and Server2 database on few tables.
Now the problem is when I start the replication for the first time, it drops the table on target ...
0
votes
0answers
13 views
How to restore the backup of schema taken using pgdump from a different RDS to a different RDS in postgresql?
I have 2 RDS in AWS actually . I need to take the schema from one of the RDS and restore it into the second RDS without taking the table data. So i have taken the backup using this command in bastion ...
1
vote
2answers
65 views
Replication alternative
We are using SQL express that does not support DB replication to other servers.
1- is there any way/free tool that enable us to perform any type of replication?
2- do you have any idea to share the ...
1
vote
1answer
15 views
WSREP connection to peer timed out, no messages seen in PT3S
I'm running 3 node Galera cluster using MariaDB-server-10.3.13-1.el7.centos.x86_64 and periodically seeing following errors in logs. I did google about this error but didn't find any good answer. Does ...
0
votes
0answers
20 views
mysql replication duplicate entry
I replicate my mysql master to a slave. They works very well but once in a while, duplicate entry would happen and I don't know how to resolve it ending up copy the master over and start replicate ...
0
votes
1answer
10 views
Increasing TransactionLogsDiskUsage in postgresql 11.12 RDS instance [duplicate]
We have a test RDS postgresql 11.12 instance, configured for logical replication. The only thing connected to it is a 3rd party service, Hevo Data, which is managing sync to a separate Redshift ...
0
votes
0answers
24 views
Replica is significantly behind Source on MySQL 8.x
I am running a MySQL 8 source/replica setup on two dedicated bare mettal AMD servers, each on Ubuntu 20.04. Connection is fast over 1GB ethernet switch on dedicated NICs. The database replicated has ...
0
votes
0answers
39 views
Why am I seeing START_REPLICATION 0/42000000 TIMELINE 1 Query in Postgresql 12
I am using Postgres 12 and have a master and slave setup. I am also running Barman on our secondary server in the meantime.
When looking in pg_stat_activity I see:
START_REPLICATION 0/42000000 ...
0
votes
0answers
18 views
Error message when Selecting Replication | Distribution Configuration
We have a SQL Server 19 installation configured for Failover Cluster Instance. I have been asked to setup replication between two databases on this server. When following the Microsoft documentation ...
0
votes
0answers
13 views
mssql replication on ubuntu 18.04.6 - mssql-server 2019
Using mssms I can start to configure replication utilsing the wizard. At the end the wizard states Replication success and publication server success.
Step 2 is to create a publisher. Here is where ...
1
vote
0answers
8 views
Does AWS Aurora MySQL not support encrypted binary log replication with RDS MySQL master?
Trying to setup replication between an RDS MySQL (5.6) master with an Aurora MySQL (also 5.6) replica cluster in the same region via binary log replication for a work project. However, this doesn't ...
1
vote
2answers
36 views
Replicate one database in one server to 2 other servers SQL2008
In product
ion, we have a transactional replication between 2 servers with data from one database going from server A to Server B. We now want to add another server C for the short period of time ...
0
votes
1answer
28 views
Mariadb: Access denied for user 'repl'@'xxx'- Replication slave permission getting revoked
I have 2 nodes running MySQL setup using Pacemaker.
Every time I standby the slave node and unstandby it later, it is not able to catch up and says the error as:
Last_IO_Error: error connecting to ...
0
votes
1answer
25 views
Does Azure MySQL 8 service with region HA support XA transactions?
I need to configure a MySQL cluster in Azure with region HA that supports XA transactions.
MySQL does not support XA transactions when replication is in place for our current setup with Percona XTradb ...
0
votes
1answer
20 views
insert and update triggers do not fire on replicated table
I have created a publication and a subscription on two servers with wal_level = logical in my postgresql.conf. Replication is functioning normally. My problem is to track changes in the replicated ...
2
votes
1answer
19 views
Why can't I setup replication with pglogical? It says I need a primary key even though I have unique constraints
I'm trying to enable replication with pglogical on a database running Postgres 9.6.22, however I can't add one of my tables even though it has a unique constraint:
db=> SELECT pglogical....
0
votes
0answers
27 views
How To replicate from same database name on multiple site
I have a few dozens of sites (with replication enabled, and multiple satellite on each) where there is a standardized database (same schema), let's said its named "prod" everywhere.
I would ...
0
votes
1answer
43 views
How to Tune MariaDB Database System With Right Parameters
I have a MariaDB Galera 3-Node Cluster as the DB system but since I built, it is working with the default parameters. I only changed the parameter as max_connections=3000. It has been about 6 months ...
0
votes
1answer
49 views
Does NOT FOR REPLICATION affect query plan generation?
I do understand why replicated articles have not trusted FK constraints, but wanted to know if I force FK for trusted anyway, will query plan actually change?
1
vote
1answer
9 views
Publication Properties window in SSMS hung when attempting to update
We have a SQL 2012 Database that is mirrored. It also has one publication with 3 subscribers. After a problem occurred (a view that couldn't replicate) during a snapshot push to one of the ...
0
votes
2answers
47 views
When queries start executing on standby server the replay lag starts to increase
I have a two servers with following specs:
8 vCPU, 32768 MB RAM, 640 GB SSD
The master Postgres 13.3 database (db1) is installed on first server (Ubuntu 16.04.7) with the following config:
...
2
votes
1answer
92 views
Postgres major version upgrade using replication server
I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I plan to use the replication for the same. Plan (in short) is to:
Dump the data using pg_dumpall
Kill the ...
0
votes
2answers
31 views
Steps to remove node from percona cluster
I have to update the os on a few servers and I need to remove a db from the cluster.
wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63'
Do I remove the ...
0
votes
1answer
32 views
help finding out the cause of this error in mysql partitioned table
I have a table wallet_transactions which grows very quickly. So, i have partition the table .
CREATE TABLE `wallet_transaction` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`code` bigint(20) DEFAULT ...
0
votes
1answer
41 views
MariaDB: Periodic copy of data from local database to remote database
I need to periodically copy the outcome of a view on our local database to another remote database.
I've tried using mysqldump which works fine when copying data from tables to tables, but i need to ...
0
votes
0answers
20 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
22 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 ...
1
vote
2answers
30 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 ...
1
vote
0answers
86 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
21 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
44 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
12 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
18 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
31 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
2answers
35 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
24 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
22 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
38 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 ...
