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.

1036 questions
3
votes
2 answers

What is the best way to check the status of a MySQL slave that is replicating from a master?

Specifically I have a set of InnoDB tables and we are backing these up into MyISAM tables to provide full text search. The slave DB routinely falls behind the Master. I am looking for advice on diagnostics or commands that can be used to keep track…
IanMulvany
  • 133
  • 4
3
votes
5 answers

Master - Slave MySQL setup on a VMWare Cloud -- Is it needed?

We currently are in the research phase of building a "Master" database for our e-commerce business that will centralize all data, including product information, vendor information, Magento information, Amazon, etc .... We have looked into both…
Zak
  • 354
  • 4
  • 17
3
votes
3 answers

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated environment, but I thought the whole point of…
Max
  • 3,523
  • 16
  • 53
  • 71
3
votes
1 answer

Rails/Mongo across multiple different geo-regions

I have a system that by necessity requires physical presence in three or more different locations and I need advice on structuring in such a way that my database stays replicated in a timely manner without horrible latency. I've seen mysql access…
wmarbut
  • 301
  • 2
  • 4
  • 12
3
votes
3 answers

failsafe RAM drive solution

I'm looking for a production solution to create a RAM drive that will be safely synchronized with HDD. I have a piece of custom software with heavy I/O load (this is some kind of proprietary document-oriented DB), and I need to speed it up…
3
votes
1 answer

Queries Stuck on the 'Connect' Command

So, little back story. We have a master-slave set-up and multiple times per day, we see something like this on the slave database, trying to replicate whats come from the master Id User Host db …
Ascherer
  • 93
  • 7
3
votes
1 answer

Quickly change Active Directory Replication Schedule for all Sites & Sitelinks

My company has more than 80 sites, and my predecessor for reasons unknown to me put in a large chunk of time preventing replication between the HQ's DC and the branches' RODC. I need to reset their settings to allow replication throughout the day,…
pepoluan
  • 5,038
  • 4
  • 47
  • 72
3
votes
2 answers

Checksumming mysql replicas over ssl

After hours of struggling to understand the way percona toolkits (2.1) pt-table-checksum works, I try to try you. Situation Running MySQL replication (Master-active:Master:passive) Slave user is required to connect via SSL pt-table-checksum can´t…
Ruben
  • 31
  • 3
3
votes
1 answer

What is and what is not replicated in a glassfish cluster with a mod_jk load balancer?

I have a Glassfish (3.1.2) cluster over 2 computers as nodes, with a mod_jk load balancer. Are servlet instance variables replicated perfectly? If not, how do I make sure it is? Are all actions, including method calls and disk writes, replicated…
Navigateur
  • 185
  • 3
3
votes
1 answer

mongod: automatically initiate replica-set

Currently I manually execute the rs.initiate() in the shell after starting a mongo primary or secondary machine to join the replica-set "farm". Doesn't the /etc/mongodb.conf allow me to define the initiate command to do this automatically when…
ledy
  • 565
  • 1
  • 6
  • 15
3
votes
1 answer

HAproxy with MySQL Master-Master Replication incredibly slow

I have two MySQL servers in multi-master mode, with an HAproxy machine for simple load balancing/redundancy. When I am connected to one of the servers directly and try to update about 100,000 entries, it is completed including replication in about…
Joe Gibson
  • 45
  • 8
3
votes
1 answer

MongoDB -what's the safest and most efficient way to change from Master-Slave to ReplicaSet?

I now have two mongo servers with a Master-Slave configuration (all read-writes are done with the Master, the Slave is just a cold backup) serving a pretty demanding web app. I want to switch to ReplicaSet of 3 servers - I have these 3 already…
SecondThought
  • 409
  • 1
  • 4
  • 11
3
votes
3 answers

What backup method should I choose to backup database on high-load server

I have a mysql (MyISAM) database with size around 30Gb. It has single large table (and some smaller ones but it makes no difference). It performs around 2000 selects (single row by primary key)/second, 300 updates/second and 50 inserts/second. We…
Poma
  • 1,299
  • 6
  • 24
  • 35
3
votes
1 answer

Exchange 2003 to 2010 public folder replication

I've found several guides and tutorials on public folder replication from 2003 to 2010, but am still a little bit confused. What we have, is a 2003 exchange server obviously holding all of our public folders, and two 2010 exchange servers in a DAG,…
James Edmonds
  • 1,733
  • 10
  • 37
  • 59
3
votes
1 answer

What are possible results/side effects if replication between DC's in a Windows domain is unable to occur?

There's plenty of administration literature out there how to properly manage Windows servers. But in dealing with real life, things don't always occur like you want them to. In Microsoft's Windows Server 2003 Administrator's Companion, out of…
Chad Harrison
  • 6,990
  • 10
  • 29
  • 41