Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

1
vote
1answer
20 views

Streaming replication archive folder taking all space- Postgresql- 9.4

We had recently setup postgres streaming replication between master (physical, CentOS release 6.6) and slave(virtual, CentOS 7.6). We did the test and streaming replication is working fine. We ...
0
votes
1answer
19 views

MongoDB 3.6, adding replica set always fails as on production setup with cannot open /dev/urandom Too many open files

I am trying on add a 3.6 mongoDB node to a 3 member replica set running 3.4. Doing this as a part of DB upgrade from 3.4 to 3.6. When I add the new member to replica set, it goes to STARTUP2, data ...
0
votes
0answers
7 views

Setup mysql innodb group replication in AWS with instance from different region

The plan is to have 4 mysql instances, 3 at US and 1 at Asia as emergency backup. The problem is, the public ip address (elastic public ip) in EC2 is not part of the system's interface. When the ...
0
votes
1answer
21 views

Why am I seeing these mongodb 3.6.5 server log messages in huge amounts?

Could someone please shed some light on these mongodb 3.6.5 server log messages on the primary node of a 3-member replicaset? rs.status() says all the nodes are up and running but seeing a ton of (I)...
0
votes
0answers
5 views

Decrypt RSSD maint password in Replication Server version 15.7.1

Is anyone knows any possibilities to decrypt an encrypted RSSD maint password in the Replication Server configuration file? Thanks in advance.
0
votes
0answers
12 views

MariaDB GTID current_pos vs slave_pos

In a standard master-slave setup using MariaDB (10.3 at this time) and GTID (Global Transaction ID), it is unclear wether to use current_pos or slave_pos. Reminder from the documentation: Using ...
0
votes
0answers
33 views

[MongoDB]See Collections (and Files) created in a Shard on the Cluster

My structure: A Sharded Cluster with multiple Shards. Each Shard contains 1 Collection, which is pinned to it by tags. Every Shard is at the same time a ReplicaSet Secondary. It receives data from a ...
0
votes
1answer
15 views

archive_command failed causing master to run out of disk space. Is there a command that prioritizes master's health

I had replication set up with a simple archive_command in postgresql.conf: archive_command = 'rsync -a %p _postgresql@serverip:/var/postgresql/wal_archive/%f' Which worked great for 2+ years until ...
0
votes
0answers
17 views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
0
votes
0answers
5 views

Adding index only on read replica of MySQL RDS instance

I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use. Consumers of this replica are looking for additional indexes for faster ...
1
vote
1answer
9 views

Can a replication subscription also be used as a publication?

Some background: We are working with a vendor who makes a read-only copy of their source database available to us in the cloud via filtered transactional replication. The cloud database is a ...
2
votes
2answers
40 views

SQL Server Replication with Historical Tables

Is it possible to replicate a SQL Server database and for the replica to have temporal/historical tables? Details: I have a production system, running SQL Server 2014. I want to have a replica ...
-1
votes
0answers
16 views

Setup Replication Between SQL Server 2008 and 2016 [closed]

We have two versions of SQL Server running in our environment one is SQL Server 2008 and another version is SQL Server 2016. Please advise whether is it possible to setup replication between these ...
0
votes
1answer
23 views

mongodb: Can I create an unshard Replica set for a sharded cluster?

I have a 3 node shard cluster mongoDB with replica set, and want to add (single node replica set) a un-sharded Replica set to collect all data in one node. Can I create an unshard Replica set for a ...
0
votes
0answers
16 views

Error 'Unknown Collation: '2048' on query

I'm doing MYSQL Replication for the first time. Master mysql version: mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1 Slave Version: mysql Ver 14.14 Distrib 5.1.73, for ...
1
vote
1answer
25 views

MongoDB replica has no primary

I have an existing MongoDB setup (part of a Graylog installation) where I'm attempting to configure a replica set with a primary, secondary and arbiter. I had the primary and arbiter configured ...
0
votes
0answers
11 views

mysql drop user has broken the replication

I was dropping a user on master. But that didn't execute on Slave. Instead its broken the replication. GTID enabled Parallel replication enabled. On Master: Binlog-do-db: prod_db binlog-ignore-db: ...
0
votes
0answers
12 views

GTID ignore error on parallel replication

Im getting an error in replication where GTID and parallel replications are enabled. Now I want to skip one transaction. I didn't find a way to do that. Last_SQL_Error: Worker 48 failed executing ...
0
votes
0answers
11 views

Where can I find the failover history for an Azure SQL Database with geo replication?

We have an Azure SQL Database that is geo replicated to another region. I suspect that they have swapped which is primary and which is secondary and would like to find information about when that has ...
0
votes
1answer
59 views

Merge replication - Could not remove directory

We are facing an issue with our replication server. We are currently setting up a new environment to replace the old replication server and we keep getting the following error. Server XXX\YYY, Level ...
1
vote
0answers
24 views

Logical replication sync time

I'm trying to create a logical replication between 2 Postgres 10 databases in separate clusters. All the process seem to be working, no error and \dRs+ shows the subscription correctly. The master ...
0
votes
1answer
17 views

PostgreSQL pg_basebackup from several port number

I have one slave server which used as a replication server (let's called it slave1) from several master servers. The `slave1' server is set up to receive replication from several postgresql server, ...
0
votes
0answers
28 views

Postgresql Replica is in sync but repmgr says node unattached

I've set up a replica of a Postgresql instance using repmgr, and the replica is totally in sync with the master instance and have been in sync since some days, but repmgr tells me replica isn't ...
0
votes
1answer
23 views

How to handle set up real time DML and DDL statements sync between two DB servers SQL Servers

We are looking to offload the data from a Production enviroment to a reporting environment. I currently have an SSIS package setup to extract and load data between the two servers. However, now ...
1
vote
2answers
51 views

Is it possible to run an arbiter on a machine that also hosts a secondary member?

I have two machines (it is a restriction) configured as a replica set with MongoDB 3.6.5. Is it possible to run an arbiter on a machine that also hosts a secondary member? Even if it is not ...
0
votes
1answer
62 views

Accidental deletes at SQL Server Subscriber

Unfortunately, this happened twice in 2 weeks on our most critical db server; just before Christmas! Instead of running a delete script at the publisher, the script was run at the subscriber, which ...
0
votes
1answer
22 views

Replica Set Oplog Maxsize

I have two databases (Mongodb 3.6.5) using ReplicaSet, when I made a split in the network, I am forcing the secondary database to be the primary. cfg = rs.conf() cfg.members[0].votes = 0 cfg.members[...
0
votes
2answers
37 views

Safe backup of PXC / Galera cluster

I have 3 nodes 'master master' cluster and using PXC 5.6 But I am only using a single node for both read and write. Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
1
vote
0answers
33 views

postgres :: FATAL: could not access file “pglogical”: No such file or directory

We installed pglogical from source code, we are running PostgreSQL 9.4 make USE_PGXS=1 clean all make USE_PGXS=1 install Installation was successful after updating the parameters, we tried ...
0
votes
1answer
42 views

How do I tell what agent profile is being used?

When you change from one replication agent profile to another using the SSMS GUI, you often have to stop and restart the agent for the change to take effect. I'm trying to debug an issue where it ...
2
votes
0answers
26 views

Postgres Replication out of sync

We have master server on one Datacenter, and the Replicate is in another Datacenter Intermittently, on the replicate server, we see this as below. “2018-12-19 07:24:25 UTC: : @: [25775]: [2-1] ...
0
votes
1answer
42 views

How to solve replication in MongoDB only with two machines?

I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary. ...
0
votes
1answer
14 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...
1
vote
1answer
36 views

Streaming replication version between different minor versions

I want to know few details about streaming replication. I want to setup streaming replication between version 9.4.4 and 9.4.20 ? I have the master server in centos6.6 with postgres version 9.4.4 ...
0
votes
0answers
14 views

Postgresql streaming replication slow on macOS

I am using PostgreSQL 10.1 on MAC on which I am trying to set up streaming replication. I configured both master and slave to be on the same machine. I find the streaming replication lag to be slower ...
0
votes
2answers
38 views

How verify if replicaset is working?

I am newbie with MongoDB and even more in administration of databases. But my boss passed me an issue to solve. SCENARIO I have two servers using MongoDB and ReplicaSet, when I run the command db....
0
votes
1answer
9 views

Character set warning in PXC logs

I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning: [Warning] Client failed to provide its character set. 'latin1' will be used ...
1
vote
1answer
8 views

Switch publisher - subscriber side

I have 2 server using merge replication. One acts as a Publisher and one acts as a Subscriber. One day I want to switch the side, publisher become subscriber and subscriber become publisher. In my ...
0
votes
1answer
28 views

Replication stalling on one subscriber

I currently have transactional replication set up for three databases from the same Publisher to the same three Subscribers in SQL Server 2005. Publisher and Distributor are on the same server. One ...
1
vote
0answers
30 views

SQL Server upgrade re-initializes subscriptions

I recently, in a test environment, upgraded my SQL Server Distributor from 2012 to 2017. The upgrade went off without a hitch but I noticed that after the upgrade was completed all of my subscriptions ...
0
votes
0answers
37 views

pg_basebackup taking way too long

I'm trying to set up a replica of my Postgresql DB using repmgr, and every single time it takes way too long for it to finish. This is the command that I actually run: repmgr -h MASTER_DB_ADDRESS -U ...
0
votes
1answer
31 views

SQL Server Log Reader Agent while trying to add node in p2p Replication

I am trying to add one more node in peer-to-peer cluster. In current state, I have 3 servers A, B and C. I need to add a node D with node A(only). For this, I used following steps: Took full backup ...
0
votes
1answer
47 views

Create Copy of all rows where foreign key matches specified and then replace foreign key

I'm new to database administration (this is my first time) and have been tasked with creating a database with functionality that allows users to select a "Model" as a current state which can then be ...
1
vote
3answers
80 views

Using Postgresql logical replication, how do you know that the subscriber is caught up?

Postgresql has some interesting monitoring tools for monitoring the new logical replication system's progress, but I don't really understand them. The two tools I'm aware of are: pg_stat_replication ...
1
vote
1answer
26 views

Bucardo - without Primary Key and Unique Key

I read this from Postgresql Wiki page. Cannot incrementally replicate tables without a unique key (it can "fullcopy" them) Now we have 5.5.0, so still do we need PK or unique key for this? What ...
1
vote
1answer
30 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, ...
1
vote
1answer
26 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 ...
-1
votes
0answers
40 views

MongoDB Connection String ReplicaSet Not Working

I have set up a MongoDB Replica Set and this is the structure: One primary node. One secondary node. One arbiter node. I have included the output of rs.status() at the end of this post. The problem ...
2
votes
1answer
22 views

postgresql configuring wal_archive directory

I had a problem with PostgreSQL server. I took over PostgreSQL server from my former colleague, and today my server crashed due to filled up disk space with wal_archives. Usually wal segments were ...
0
votes
1answer
29 views

Why is searching by one varchar column not working correctly on replica?

PostgreSQL: 9.6, master, replica. Async replication, wal archiving. We detected that if we execute a select query on a varchar column against a replica, then the results return no rows, but if we ...