Questions tagged [replication]

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility. It could be data replication if the same data is stored on multiple storage devices, or computation replication if the same computing task is executed many times. A computational task is typically replicated in space, i.e. executed on separate devices, or it could be replicated in time, if it is executed repeatedly on a single device.

The access to a replicated entity is typically uniform with access to a single, non-replicated entity. The replication itself should be transparent to an external user. Also, in a failure scenario, a failover of replicas is hidden as much as possible.

It is common to talk about active and passive replication in systems that replicate data or services. Active replication is performed by processing the same request at every replica. In passive replication, each single request is processed on a single replica and then its state is transferred to the other replicas. If at any time one master replica is designated to process all the requests, then we are talking about the primary-backup scheme (master-slave scheme) predominant in high-availability clusters. On the other side, if any replica processes a request and then distributes a new state, then this is a multi-primary scheme (called multi-master in the database field). In the multi-primary scheme, some form of distributed concurrency control must be used, such as distributed lock manager.

1020 questions
45
votes
10 answers

PostgreSQL Replication

We constantly bat this around the office, and the question continues to come up. How do you deal with PostgreSQL replication? I'm not even necessarily talking about advanced clusters, just keeping it simple with Master-Slave, Master-MultiSlave, and…
f4nt
  • 859
  • 10
  • 9
27
votes
2 answers

Reload my.cnf without restarting MySQL service

I have to configure a MySQL server to act as a replication-master. I modified my.cnf to activate binary logs, but now in order to reload configuration I have to reload the service with /etc/init.d/mysqld restart. The problem is that the server…
David Espart
  • 387
  • 1
  • 4
  • 9
24
votes
2 answers

Is it a good idea to store Docker volumes in glusterfs?

I am currently thinking about migrating some of our servers and apps to a coreOS environment. One of the problems I see here is the management of persistent data as coreOS does not handle Docker volumes when moving a container to a new machine.…
Martin
  • 353
  • 1
  • 2
  • 8
21
votes
1 answer

PostgreSQL 9: Does Vacuuming a table on the primary replicate on the mirror?

Running PostgreSQL 9.0.1, with streaming replication keeping one read-only mirror instance up to date. Auto-vaccuum is on on the primary, except for a few tables which are not vacuumed by the auto-vacuum daemon, in an effort to reduce business-hour…
Scott Herbert
  • 586
  • 1
  • 6
  • 13
19
votes
3 answers

How fast is MySQL replication?

I'm considering setting up replication of our mysql db to be able to have local slaves in each of our branch offices, while having the master in the main office to improve application performance (significantly) at our branch offices. The db itself…
Steven Evers
  • 653
  • 5
  • 9
  • 23
17
votes
7 answers

USABLE multi-master replication for Postgres?

I tried Postgres-XC and it doesn't implement full SQL yet (like SERIAL) Postgres-R looks interesting but it's "not production ready" according to developers. So I used pgpool-II 3.0.1. Yes, it works nicely. But as far as I can see it's only for 2…
mrkafk
  • 379
  • 1
  • 2
  • 7
16
votes
7 answers

Is DRBD the only viable block replication solution for Linux?

I've found myself needing redundant storage at a block level. File-level replication (Gluster, GFS, etc) does not work for my use case. It looks like DRBD is the go-to solution for block replication. There don't seem to be too many other sane…
Charles
  • 1,194
  • 2
  • 12
  • 22
16
votes
4 answers

Starting a branch office on the other side of the world

Going to cut right to the point on this question, as I'm after as diverse range of solutions as possible so don't want to effect any opinions with the question too much. Client is a UK based company. Organisation is 95% Windows with AD They have an…
15
votes
3 answers

Windows Server: Replicate folders without DFS?

From reading the DFS documentation, AD appears required. This is a problem for us because our servers are either stand alone (not in AD), or part of our hosting service AD, and AD is out of our hands. The question is: How to do DFS, or something…
15
votes
3 answers

MySQL Replication Performance

I'm having a serious issue with MySQL 5.5 replication performance between two machines, mostly myISAM tables with statement based replication. The binary logs and mysql data directory are both located on the same Fusion ioDrive. The problem was a…
Nick
  • 153
  • 1
  • 6
14
votes
5 answers

mirrored filesystem across a few servers

I'm looking for a solution to mirror or replicate one directory (or one filesystem) across a few Linux servers. Ideal solution would be one, which permits all servers read-write access. I also want it to me resilient, if one of the servers goes…
vartec
  • 6,137
  • 2
  • 32
  • 49
14
votes
5 answers

Prevent non-replication writes to MySQL slave?

We have some MySQL database servers set up with row-based replication, for performance. The software writes to the master, and reads from either the master or the slave. Everything's working great, for the most part. It's my understanding that…
Ken
13
votes
4 answers

Has anyone ever used SMTP site links?

A simple real-life question, inspired by a comment here: Active Directory has supported inter-site replication using SMTP instead of direct RPC since its first introduction in Windows 2000. But did anyone ever actually use it? If yes, why was it…
Massimo
  • 68,714
  • 56
  • 196
  • 319
12
votes
3 answers

How to actually use mysql slave as soon the master is failover or got burnt

I have MySQL master-slave replication that works fine; I googled the whole net and MySQL site to find the standard procedure to make use of the replication but found nothing. It is as if admins are happy to have replication on, but when the time…
Jawad Al Shaikh
  • 254
  • 1
  • 3
  • 15
12
votes
4 answers

Windows Domain replication monitoring tool

I am looking for web-based interface GUI, or some kind of monitoring tool that will show replication status for a domain. I know I can use repadmin with various options on the command line to query the status. I thought about creating a script they…
1
2 3
67 68