I have installed MongoDB and its set up as windows service. When I try to set up replicaSet I am getting error "Only one usage of each socket address (protocol/network address/port) is normally per...

I am creating replication slot and streaming changes from AWS Postgres RDS to java process through JDBC driver. My replication slot creation code looks like this. final ReplicationSlotInfo replic...

I have merge replication set up between two databases and am using identity ranges on both. I want to add a specific row to a merged table (setting the identity value to something outside of the i...

Following the discussions in the comments at this answer, @kevinadi recommended me to open a new questions related to his comment: You can start a replica set with one node for development purpo...

We have a master-slave replication configuration as follows. On the master: postgresql.conf has replication configured as follows (commented line taken out for brevity): max_wal_senders = 1 wal...

I have two MySQL servers with master/slave replication between them. The connection between them is ADSL. It is not reliable at all. I decided to add another ADSL connection from another ISP with i...

I recently upgraded my Cloudera environment from 5.8.x (hadoop 2.6.0, hdfs-1) to 6.3.x (hadoop 3.0.0, hdfs-1) and after some days of data loads with moveFromLocal, i just realized that the DFS Used...

I am new to MySQL and after a long search I am able to configure master-slave ROW based replication. I thought it would be safe and I would not have to recheck it again and again. But today when I...

This introduction to Cassandra Replication and Consistency (slides 14-15) boldly asserts: R+W>N guarantees overlap of read and write quorums. Please imagine this inequality has huge fangs,...

I hava kafka cluster having 3 brokers and a couple of topics with each having 5 partitions. Now i want to set the replication factor for the partitions. What is the maximum replication factor whic...

I want to create a replica to my Percona Server with GTID enabled, but got this error when i show slave status: Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: '...

Our usage case is a database responsible for accounts, sessions, licenses, etc. — it needs to be polled upon client startup, so high reliability is crucial. As such, we'd like to replicate across d...

i have a cluster structure on RDS (master/slave)...and all the temporary tables created on the master are replicated on the slave. I don't want that.... I want that statements like: create te...

I have setup the replica set over 3 mongo server and imported the 5 GB data. now status of secondary server showing "RECOVERING". Could you let me know what is means for "RECOVERING" and how to sol...

I am trying to get a stream of updates for certain tables from my PostgreSQL database. The regular way of getting all updates looks like this: You create a logical replication slot pg_create_logi...

I've got a small database, around 50mb. It's a master replicating to a remote server. I noticed that the relay-bin files total to over 5GB. Is it safe to delete them?

I have replication slot which I want to delete but when I do delete I got an error that I can't delete from view. Any ideas? postgres=# SELECT * FROM pg_replication_slots ; slot_name | plugin | s...

I'm doing a INSERT ... ON DUPLICATE KEY UPDATE but I need the update part to be conditional, only doing the update if some extra condition has changed. However, WHERE is not allowed on this UPDATE...

I set up a fully functional logical replication of multiple masters to one slave. As soon as I convert any of the replicated tables to timescaleDB's hypertable, the replication stops working - on...

Do I need to do anything on the primary if I permanently remove its only replica? I'm concerned about WAL files filling up the disk. I want to remove the only replica from a single-node replicatio...

In a replication set up of primary, secondary and arbiter, the replication connection URI times out intermittently and logs show below error. Please help share what could be the issue and what woul...

I build a replication set with one primary, one secondary and one arbiter on MongoDB 3.0.2. The primary and arbiter are on the same host and the secondary is on another host. With the growing of ...

I am having all sorts of trouble getting SQL Server (2005) to work properly. When I run the client (SQL Server Express 2005) I get the following error The concurrent snapshot for publication 'xx' ...

I have a CouchDB 1.2.0 instance running on my laptop and I want to replicate a local database named "soup" to a remote machine, which runs a CouchDB 1.1.1 instance. I issue the replication from fut...

I have a regular table transactions with 200 million rows. I decided to convert this table to a Declarative Partition using Logical Replication. I created a Publication on node1 like so: CREATE ...