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
5
votes
1 answer

How to configure grails 3 for mongodb replicaset

I am deploying a grails 3 app to a live server. A mongodb instance has been setup in replication mode and tested successfully from the live box. I tested with: mongo -u uname -authenticationDatabase dbname ip-1.ec2.internal:27017/dbname -p…
Godfred
  • 91
  • 8
5
votes
2 answers

How to grant replication privilege to a database in mysql?

I need to create a user with replication slave permission for each database. When I use the command GRANT replication slave ON `mydb`.* TO 'user'; the error Incorrect usage of DB GRANT and GLOBAL PRIVILEGES is shown. Is there a way to GRANT…
Joel Ollé Ripoll
  • 451
  • 1
  • 4
  • 15
5
votes
1 answer

Google Datastore cross region replication

We have a app that is hosted in US and the EU. For great performance we will host a datastore instance on both locations. Now is our question how we can replicate the data from the US datastore to the EU datastore? Or is it no matter where we store…
Aron
  • 1,179
  • 15
  • 29
5
votes
2 answers

Is it possible to read data only from a single node in a Cassandra cluster with a replication factor of 3?

I know that Cassandra have different read consistency levels but I haven't seen a consistency level which allows as read data by key only from one node. I mean if we have a cluster with a replication factor of 3 then we will always ask all nodes…
5
votes
0 answers

PostgreSQL Replications: Multiple Masters to a Single Slave

I have several PostgreSQL DBs in different geographical locations (local sites). Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, Department_ID, Department_Name. Site_ID is unique for each…
5
votes
1 answer

Obtain insertion time of a tuple in an existing table in PostgreSQL 9.3

I am running PostgreSQL 9.3 (in a hot standby setup) on Ubuntu 14.04 LTS. I would like to display the growth (e.g. amount of tuples) of a table over time. The table does not contain a "timestamp" (or equivalent out of historical reasons) column. Is…
rzo1
  • 5,561
  • 3
  • 25
  • 64
5
votes
1 answer

Archiving records from PostgreSQL database that surpass timeline

Let's say we have a database for a bus company. We collect data about bus rides, passenger lists, fuel etc. We mostly work with data about upcoming rides Sometimes we need to look in the history (for accounting), but the time frame is short (3…
xpuu
  • 1,514
  • 13
  • 13
5
votes
1 answer

Does Redis support master-master replication?

From my understanding from the below questions which were asked quite some time back, Redis doesn't have a built-in support for master-master replication. Question 1 Question 2 Question 3 The official website as of now looks like there is nothing…
5
votes
3 answers

Amazon RDS Read Replica -- Skipping Replication Errors

I have an amazon rds instance database, and I'm using a read replica for analytics. However, every week or so the read replica crashes with a replication error. I've tried looking at the slave status and skipping replication errors as per this help…
jkeesh
  • 3,289
  • 3
  • 29
  • 42
5
votes
2 answers

Postgres Replication: Incomplete Startup Packet

I recently configured PostgreSQL 9.3 hot standby replication between a single master/slave. I've checked my standby server again today and it looks like it is unable to complete and exit recovery mode on restart: 2014-03-25 22:36:07 UTC LOG: …
Kyle
  • 4,202
  • 1
  • 33
  • 41
5
votes
2 answers

MongoDB balancer timeout with delayed replica

We have a setup of two mongodb shards. Each shard contains a master, a slave, a 24h slave delay slave and an arbiter. However the balancer fails to migrate any shards waiting for the delayed slave to migrate. I have tried setting _secondaryThrottle…
5
votes
0 answers

What is the difference between passive master and slave in mysql replication?

There are several ways to configure mysql replication. I know how to configure the replication cluster to use master-master-active-passive model or master-slave model. If I configure passive master and slave to be "read-only" in each model and both…
Eagle
  • 509
  • 1
  • 4
  • 11
5
votes
1 answer

How efficient is Meteor's DDP at syncing very large collections?

Meteor's DDP protocol works very well for syncing a small collection of data from a server to a browser-based client, which inherently limits the amount of data that is processed. However, consider a situation where Meteor is being used to sync a…
Andrew Mao
  • 35,740
  • 23
  • 143
  • 224
5
votes
4 answers

Error 1794 loading mysql 5.6 master dump while configuring replication slave

E:>mysql -u root < masterDump.db ERROR 1794 (HY000) at line 22: Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in…
KingAndrew
  • 1,164
  • 4
  • 21
  • 41
5
votes
2 answers

Does mySQL Replication: Master DB Name has to be the same as the Slave DB name?

I have set the Master DB Name as MDB & in the Slave server I set to replicate-do-db=SDB <-- this did not work? But when I set it up as the same DB name it works. Is there any solution out there to setup 1 master db with 2 different slaves but in the…
hkshambesh
  • 435
  • 1
  • 5
  • 16