Stack Overflow
Stack Overflow

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

PostgreSQL replication with rubyrep

I'm new to rubyrep and currently using rubyrep-1.2.0 version for PostgreSQL Master-Master replication. All data types except bytea are getting replicated properly. While replicating bytea column, it seems like the data is escaped twice. I'm using…
Kumaran6.2
  • 51
  • 3
5
votes
2 answers

Replicate a single Redis database from an instance that has multiple databases

I have one Redis instance that has two databases. Now I want to set up a second instance and replicate the first instance, but the second instance should only have one database and replicate only db 0 from the first instance. When I try to do it…
Manuel Meurer
  • 3,238
  • 6
  • 35
  • 50
5
votes
4 answers

How to set up synchronous streaming replication in postgres?

I am trying to set up synchronous replication with Postgres 9.1, but I cannot get it to work. I was able to configure streaming replication, but not synchronous. I hope I have not missed anything obvious. I have read carefully many sections of ch…
Julio Garcia
  • 1,087
  • 3
  • 14
  • 22
5
votes
2 answers

How to set up a mongodb delayed slave that is not hidden?

For testing purposes, I am trying to simulate a replication lag in a mongodb cluster, by setting up a slave with slaveDelay=n. As it turns out, this magically causes the slave to be hidden, so my test cannot access it. The mongodb documentation…
axeolotl
  • 51
  • 2
4
votes
1 answer

Mysql - Replicate only a few tables from a database

Using mysql replication with mysqlbinlogs between master and slave databases, is it possible to only replicate a few key tables instead of an entire database? I would ideally like to not even generate the mysqlbinlogs for the unneeded tables If…
LTME
  • 1,086
  • 1
  • 10
  • 13
4
votes
1 answer

How to set up MongoDB for multiple Data Center?

Here is the environment: [ Data Center 1 ] [ load balancer, ip: 45.45.45.45] [ Server 1-A, internal ip: 10.0.0.1, external ip: 200.0.0.1 ] [ Server 1-B, internal ip: 10.0.0.2, external ip: 200.0.0.2 ] [ Server 1-C, internal ip:…
murvinlai
  • 48,919
  • 52
  • 129
  • 177
4
votes
1 answer

offline limited multi-master in Postgres

Site A will be generating a set of records. Nightly they will backup their database and ftp it to Site B. Site B will not be modifying those records at all, but will be adding more records and other tables will be creating FK's to Site A's…
Thomas
  • 3,348
  • 4
  • 35
  • 49
4
votes
3 answers

Drupal 7 MySQL master/slave replication not working

I am having trouble getting Drupal 7.7 to use a MySQL slave database. My settings.php is as follows: $databases['default']['default'] = array( 'driver' => 'mysql', 'database' => 'my_db', 'username' => 'dbuser', 'password' => 'dbpw', 'host'…
Brian
  • 188
  • 1
  • 6
4
votes
1 answer

One way replication with CouchDB

I run CouchDB on my production server, and I want to periodically replicate it to my development server (running on another machine, at my home). So what's the easiest way to do it securely ?
fokenrute
  • 739
  • 6
  • 17
4
votes
1 answer

Postgres RDS pg_recvlogical replication role

Im trying to setup a streaming replication on a rds postgresql database using pg_recvlogical. When I send the command to start streaming pg_recvlogical -d -h -p --slot (slot_name) --start -f - I receive the message: "could…
Fabio Takahashi
  • 69
  • 3
4
votes
2 answers

PostgreSQL is not replicating some changes(extensions)

I'm reproducing following this doc a master-slave replication with PostgreSQL DB servers. In front of the cluster there is a pgpool instance as load balancer. So far so good. The problem is when I query the database from the app and use specific…
Juan I. Morales Pestana
  • 1,057
  • 1
  • 10
  • 34
4
votes
4 answers

Database sync solutions for Delphi

I am looking for some starting points integrating a Win32 Delphi application's data with a remote database for a web application. Problem(s) this project intends to solve: 1) The desktop does not perform well over vpns. Users in remote office could…
Richard Holland
  • 2,663
  • 2
  • 21
  • 35
4
votes
1 answer

Manage conflicts and lag on Postgres Replication in Hot Standby with read heavy Slave

Requirement: Avoid terminating connection due to conflict with recovery error and also have acceptable replication lag. Google Cloud PostgreSQL 9.6, Replication turned on (uses Streaming replication), PGPool-II set to only do load balancing and with…
Khushbu
  • 295
  • 4
  • 14
4
votes
2 answers

Is there a RDS aurora synchronous read replica?

If I understand correctly, Amazon Aurora has asynchronous read replica. So, we can get some read lag (it seems, lag is about 100 ms). I need synchronous read replica. So, can I set such type of replicate for Amazon Aurora for PostgreSQL?
Max
  • 1,803
  • 3
  • 25
  • 39
4
votes
1 answer

Create read only user for postgres replica

I've recently implemented streaming replication and need to create a "report user" for the replica. This user will be used to access the database via ODBC to generate reports with. On the slave (replica DB), It seems I cannot create new users. I…
Jchase
  • 61
  • 1
  • 6
1 2 3
…
99 100