Questions tagged [database-replication]

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
1 answer

Repmgr fail to register standby in claster, what did i miss?

Problem with repmgr: failed to register in claster PLEASE SAY ME, WHAT DID I MISS? MASTER CONFIG: failover=automatic follow_command='repmgr standby follow -f /etc/repmgr.conf…
Reset
  • 1
  • 2
0
votes
1 answer

Best practice for sharing data over differenet mysql/mariadb databases

I have app that uses DB with 50+ tables. Now i'm in situation that i need to install another instance of app. Problem is that i would like to use some tables as "common" data, e.g. "brands" or "cities" or "countries" in both (for now there are only…
Yuray
  • 747
  • 1
  • 9
  • 19
0
votes
1 answer

In mysql Multi-Source replication,replicate-rewrite-db is not working

In mysql, i have Configured Two master to single slave. i want to replicate from different db to single db. so i mentioned replicate-rewrite-db=TEST->TEST1 I INSERTED IN TABLE test in ONE OF THE MASTER WITH DB NAME TEST. slave has TEST1 DB and test…
0
votes
0 answers

Mysql clusters or replication

Im building a application that should work online and off-line. I will have this application on any fisical stores and a administration on web application that should for all systems installed locale on the store. I have any actions insert and…
0
votes
1 answer

SQL Server transactional replication to Alwayson group

I have 3 servers. Server A, with a publication database, this server is not part of alwayon group, this server is the distributor Server RT1 and RT2, those servers as part of alwayson group Listener RT, the listener have the subscription to Server…
0
votes
0 answers

find all tables that ARE NOT involved with Replication

Is there a way to select articles in SQL Server that are not checked (referring to local publication properties, articles tab). I can only select all checked, simply by this code SELECT      P.[publication]   AS [Publication…
Moccassin
  • 169
  • 1
  • 4
  • 15
0
votes
1 answer

Table Level Replication in Postgres using slony

Is there any native table level replication(Pratial replication) in postgres? If no, I want to replicate only some tables from my primary to standby using slony Could anyone help me in doing this? I am referring this…
Pavan Teja
  • 21
  • 3
0
votes
1 answer

Removing documents with filter replication does not work

I am trying to create a replication using a filter in order to remove the deleted documents on CouchDB but I am always facing the same error. This is my filter : "deletedfilter": "function(doc, req) { return !doc._deleted; };", this is my…
JoCuTo
  • 2,463
  • 4
  • 28
  • 44
0
votes
2 answers

Mysql replication failed after changes on master scheme

I have master-slave replication from server with MariaDB (master) to server with Mysql (slave). All work fine, but when i change scheme of master, i have error on slave and replication broken after it. How i can change my master scheme without…
Buboon
  • 405
  • 5
  • 15
0
votes
2 answers

How to prevent local replication of a company database

I have a big Lotus Notes company database containing sensitive data and I want to prevent normal users to replicate this database locally. Explanation of the main problems : sensitive data on laptop server deleted documents reappear if the purge…
PEC
  • 632
  • 1
  • 11
  • 28
0
votes
1 answer

Transaction replication not replicating one column value

One column of type varbinary(200) is not getting replicated to destination table from source table. I have tried updating the column value in main table again but still it is not getting replicated to destination table. Am not seeing any error in…
0
votes
2 answers

Ignore specific database while replication in mongodb replicaset

I am running a replicaset of three members, i want to ignore a specific database while replicating to secondaries. Is is possible for mongodb, please help!!
Abdul Moiz
  • 1,317
  • 2
  • 17
  • 40
0
votes
0 answers

MySQL Replication doesn't work from 1 computer but does from another

I'm having a super odd error when using MySQL replication. In this setup I've got multiple servers, we got a Master Server, and then we got several slaves. The replication is working fine between Master and all the Slaves. However, there is one…
0
votes
1 answer

Unable to replicate the couch db

I have two machines lets say 156 and 157 I have a db in 156 machine which i want to replicate to 157 machine for that i am using the following command curl -X POST -d…
Katiyman
  • 827
  • 2
  • 12
  • 32
0
votes
1 answer

Issue trying to create a replica set

I am currently having issues with setting up a replica set (as per the instructions on a mongoDB tutorial on creating a replica set) on my Mac (Sierra). I have downloaded the associated .sh file and when I run this code: bash <…
bloppit
  • 621
  • 8
  • 22