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
904
questions with no upvoted or accepted answers
3
votes
0
answers
309
views
Domain name change of SQL servers involved in replication
I have a situation where client wants to change their domain name of servers hosting SQL Servers(e.g. from AB to CD). I have a transactional replication with updatable subscription configured with 1 ...
3
votes
0
answers
248
views
SQL Server replication - recommendations for stability
We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
3
votes
0
answers
1k
views
How to sync mysql remote database daily ?
I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
3
votes
2
answers
1k
views
Syncronize mysql databases between local and hosted servers automatically
We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one ...
3
votes
2
answers
8k
views
mongo replicated shard member not able to recover, stuck in STARTUP2 mode
I have following setup for a sharded replica set in Amazon VPC:
mongo1: 8G RAM Duo core (Primary)
mongo2: 8G RAM Duo core (Secondary)
mongo3: 4G RAM (Arbiter)
mongo1 is the primary ...
3
votes
0
answers
144
views
Once in a while synchronization of the independently updated mysql databases problem
I have a production database and a test database running on MySQL with MyISAM and InnoDB tables, which are updated independently.
The Production database is updated by system and sometimes by a user.
...
3
votes
0
answers
753
views
Upgrading Remote Distributor in SQL Server Replication
I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2.
Script ...
3
votes
2
answers
3k
views
mongodb replication failed with socketexception and listener
I'm trying to set up mongodb replication using two servers in different data center. For the purposes of this question, I'll say their IP address are 1.1.1.1 and 2.2.2.2. I installed a clean version ...
3
votes
1
answer
314
views
SQL Server replication over internet error
I have 2 SQL Servers connected over internet, I can connect (with no problem) from each one to other using SQL Server Management Studio by using publicIP,1433\server as server address.
So, I created ...
2
votes
0
answers
155
views
Why does the same query require more "Heap Fetches" when run on my postgresql replica?
I have a Postgres 13.10 database running on AWS RDS, with a primary instance and a replica. The replication is managed by AWS - it's not logical replication I manage myself.
The replica is configured ...
2
votes
0
answers
17
views
Merge Replication in SQL2019 database is restored to new server NOT keeping_replication
Merge Replication in SQL2019 database is restored to new server NOT keeping_replication but in restored database we find MSmerge_cont_% system views.
The last part of the system view name appears to ...
2
votes
1
answer
242
views
Why is the MySQL server-id necessary for replication when the server-uuid exists?
We're trying to setup some basic MySQL Master/Slave replication at our company, and we're confused regarding the unique server_id requirement on replica servers. Quoting the mysql docs:
On the source ...
2
votes
0
answers
156
views
Postgres First Replica has expected safe_wal_size, 2nd replica does not
Using Postgres 14 on Ubuntu:
I have logical replication setup from master => slave => slave2; It is replicating, but there is a problem with safe_wal_size.
Using du -sh /var/lib/postgresql/14
...
2
votes
0
answers
65
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 | ...
2
votes
2
answers
271
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 ...
2
votes
0
answers
385
views
Is it possible to re-sync table with logical replication?
Let's imagine that someone executed the command
TRUNCATE TABLE tbl1;
on logical replica.
How will it be correct to synchronize only one table again?
I use PostgreSQL 14.
2
votes
1
answer
5k
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....
2
votes
0
answers
36
views
Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?
I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that ...
2
votes
0
answers
364
views
Slave index corruption mariadb 10.5
We have a simple mariadb replication with a master and a bunch of slaves. without any prior alert or warning, randomly in our slaves some indexes ( some of them are not present in master) become ...
2
votes
0
answers
640
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 ...
2
votes
0
answers
1k
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 ...
2
votes
0
answers
276
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 ...
2
votes
0
answers
111
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 ...
2
votes
0
answers
150
views
CREATE or ALTER when using replication
I am using CREATE OR ALTER in the scripts for all of my views and stored procedures, as they are pushed frequently from a CD pipeline. I am also using replication to push certain tables, views, and ...
2
votes
2
answers
274
views
In mysql master-slave Replication which server requests the other?
I want to setup mysql replication between two servers one of them is my localhost and the other is online server.
I have all availability to make any one of them the master.
But according to that my ...
2
votes
0
answers
476
views
Whether or Not to Use DataPump with Oracle GoldenGate
We are setting up GoldenGate to keep 3 of our Oracle databases in sync. Regarding configuration:
We plan to have an instance of GoldenGate running on all 3 nodes. Each node will run an extract on (...
2
votes
0
answers
264
views
the mystery of the table showing up in the subscription, but not in the publication
TL;DR: This question refer to sql server 2016, transactional replication
I've got a table that shows up in the subscription but not in the publication.
Here are the details:
In one of my servers ...
2
votes
0
answers
924
views
CREATE TABLE AS SELECT with GTID
I am trying to migrate to MySQL/Percona server 8.0 and GTID based replication and have stumbled upon the issue where CREATE TABLE AS SELECT is not allowed using GTID.
The tables that are created are ...
2
votes
0
answers
1k
views
PostgreSQL logical replication and partition table
We have a large database and we want a copy of the database in our company for faster access. we are going to achieve this copy by logical replication on PostgreSQL 11.
But we have a big problem.
We ...
2
votes
0
answers
64
views
Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?...and if PostgreSQL is the publisher?
Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle?
What if the publisher database is in PostgreSQL?
If ...
2
votes
0
answers
235
views
Changing Postmaster File Name in PostgreSQL
I have two instances of PostgreSQL with master-slave replication between them and want to use GlusterFS. Everything works fine until the second instance wants to store the data in the GlusterFS. ...
2
votes
1
answer
716
views
Postgresql - archive_cleanup_command with multiple standby servers
Regarding the archive_cleanup_command command, the Postgresql 9.6 documentation states the following:
Note however that if multiple standby servers are restoring from the
same archive directory, ...
2
votes
0
answers
233
views
Percona Xtradb Cluster not accepting options on command line
I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error:
CentOS 7:
systemctl start mysql --wsrep-sst-donor=srv1
...
2
votes
0
answers
386
views
Foreign Key Error with Transactional Replication from Backup
I'm getting a missing foreign key error when I begin transactional replication.
Steps taken:
Created a pull publication (live server)
Created a copy only full backup
Restored backup on reporting ...
2
votes
1
answer
273
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 '...
2
votes
0
answers
215
views
Database replication/synchronization using multiple source nodes for postgresql
What would be the approach for synchronization at DB level for a scenario where data from multiple sources (DB nodes) needs to be integrated at a destination DB node when using PostgreSQL?
The ...
2
votes
0
answers
571
views
Should I connect to my replica through PgBouncer?
We're using a setup of one Postgresql master server and a several replicas to be able to withstand master failure. Connection to master server is made through PgBouncer.
Currently the idea is that ...
2
votes
1
answer
2k
views
error connecting to master '[email protected]:3306' mac-ubuntu
Server info:
Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10
Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11
Slave server2 (mac): macOS High Sierra IP: 192.168.0.3
MySQL Server ...
2
votes
0
answers
505
views
Best practice for shut down and restart of Replicated SQL Servers
We have SQL Server 2008 R2 and SQL Server 2012 in production. We have transactional and snapshot replication implemented in our environment and unfortunately the subscribers are also the distributors. ...
2
votes
1
answer
453
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 ...
2
votes
0
answers
671
views
Mysql replication does not replicate delete statement
Experiencing a strange issue.
MariaDB 5.5.44 on both the master and the slave
From the master, if I create a table, it appears on the slave, as well as data written to the master is replicated to ...
2
votes
1
answer
2k
views
Access denied error when archiving WAL during postgresql 9.5 replication setup
I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video.
For archive_command I use this:
archive_command = 'copy "%p" "\\\\ip-address of ...
2
votes
0
answers
441
views
symmetricds 3 tiers one way registration problem
i am trying to setup a one way 3 tiers replication using symmetricds like so
the company, intermediate, web servers have respectively these ip addresses
192.168.173.1 /
192.168.173.15 /
192.168....
2
votes
0
answers
61
views
Replication to SQL Server and to Oracle not working for one database
I have a replication for many databases on one server to one SQL Server database and to Oracle. Replication for one database is not working while the other four databases are working. For SQL Server ...
2
votes
0
answers
253
views
MS SQL Server merge replication cannot find file specified
I'm trying to setup merge replication between two MS SQL Server 2012 databases on different hosts in one domain.
When replication is set up and first snapshot is generated replications starts. ...
2
votes
0
answers
59
views
Periodically synchronise databases on 2 different servers
On my main development workstation I have around 20 databases. Every so often I will work from home on my laptop instead, where I also need a copy of these databases. Because working from home is ...
2
votes
1
answer
259
views
MongoDB stale replication, odd timestamp after data flush
Right before my secondary goes stale, it first has this written in the log:
2017-04-25T06:48:02.991+0000 I STORAGE [DataFileSync] flushing mmaps took 13530ms for 3150 files
Then it gives me a odd ...
2
votes
0
answers
874
views
mysql - Do DDL statements replicate under Row Based Replication if the Default Database is not set?
In Statement Based Replication the Default Database is of paramount importance.
e.g.
replicate-do-db=dbTwo
USE dbOne;
UPDATE dbTwo.tableTwo . . . .
will fail as dbOne has been set as the default ...
2
votes
0
answers
312
views
MySQL master slave replication on a per database basis
We use MySQL master-slave replication to maintain a backup database server as a replica of our master / production database server.
If there are issues with the master slave replication (i.e. it's ...
2
votes
0
answers
364
views
Replication log reader not updated to new primary after availability group failover
We set up transactional replication on a database that is part of an AlwaysOn Availability Group on our work environment:
The primary is SP1 and the secondary replica is SS2.
The distributor is on ...