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
Filter by
Sorted by
Tagged with
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 ...
SQLPRODDBA's user avatar
  • 1,908
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 ...
KenD's user avatar
  • 303
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 ...
Iyad Al aqel's user avatar
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 ...
Sudha's user avatar
  • 31
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 ...
user avatar
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. ...
Darkhan's user avatar
  • 131
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 ...
DamagedGoods's user avatar
  • 2,591
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 ...
learningtech's user avatar
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 ...
jellad.tarek's user avatar
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 ...
James Healy's user avatar
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 ...
Rick Willemain's user avatar
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 ...
Samuel Ludwig's user avatar
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 ...
boatcoder's user avatar
  • 335
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 | ...
Вячеслав Бадиков's user avatar
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 ...
cenko's user avatar
  • 31
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.
void's user avatar
  • 123
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....
user avatar
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 ...
Timothy Fisher's user avatar
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 ...
Mamo Ghandi's user avatar
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 ...
Gowthamakanthan Gopal's user avatar
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 ...
EAmez's user avatar
  • 155
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 ...
Shoieb Arshad's user avatar
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 ...
nishi's user avatar
  • 121
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 ...
Dan's user avatar
  • 121
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 ...
user avatar
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 (...
user avatar
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 ...
Marcello Miorelli's user avatar
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 ...
Paso's user avatar
  • 121
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 ...
Behrooz's user avatar
  • 121
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 ...
J.D.'s user avatar
  • 37.3k
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. ...
Sayad Xiarkakh's user avatar
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, ...
Rusty Lemur's user avatar
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 ...
JKhan's user avatar
  • 123
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 ...
user2200550's user avatar
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 '...
Mike Oro 's user avatar
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 ...
S_S's user avatar
  • 121
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 ...
chester89's user avatar
  • 127
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 ...
vishnu's user avatar
  • 41
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. ...
NOOK's user avatar
  • 23
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 ...
kainlite's user avatar
  • 121
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 ...
rezizter's user avatar
  • 123
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 ...
S Deshmukh's user avatar
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....
user2475096's user avatar
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 ...
Ilde's user avatar
  • 21
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. ...
nidu's user avatar
  • 121
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 ...
Laurence Frost's user avatar
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 ...
user3820901's user avatar
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 ...
IGGt's user avatar
  • 2,116
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 ...
amaidment's user avatar
  • 121
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 ...
Yaroslav's user avatar
  • 2,826

1
2
3 4 5
19