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

Will a SQL Server Replication Reinitialization overwrite data?

I have a customer's server which is giving me a "Snapshot not available" error when trying to do it's replication. From what I've read, I need to mark it for reinitialization. Now, here's the important part: On the subscribing server, there is…
0
votes
1 answer

What configuration would allow me to keep my MySQL server(s) updated while keeping the service consistently available?

I have several Centos 5 web hosting servers with local instances of MySQL that I am looking to segment so that all servers connect to a central MySQL instance. These are web applications doing more reads than writes, and I would like to keep the…
S. Cobbs
  • 267
  • 1
  • 2
  • 8
0
votes
2 answers

Any problems with my mysql replication setup command?

I wrote myself a small script that produces the following shell command. echo "CHANGE MASTER TO MASTER_USER='slave_user';" | mysql -uroot -pXXX --host=SLAVE && echo "CHANGE MASTER TO MASTER_PASSWORD='slave_password';" | mysql -uroot -pXXX…
The Shurrican
  • 2,240
  • 7
  • 39
  • 60
0
votes
1 answer

SQL Server 2005 on 2008 DC - Cannot change service user

I cannot start SQL Server 2005 transactional replication after I promoted my 2008 Server to a DC. A required privilege is not held by the client. This site suggests that I need to change the SQL Server service from my domain account to a local…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
0
votes
1 answer

Replicate content across IIS farm, *not* on a domain

What's the best way of replicating web content across an IIS web farm where the servers are not on a domain? Most people seem to recommend DFS for this type of scenario, but I understand that relies on AD to work, and running a domain here is not an…
growse
  • 8,020
  • 13
  • 74
  • 115
0
votes
1 answer

SQL Server 2008 Replication Promotion

I have a 4 node cluster, 1 subscriber and 3 publishers, all running SQL Server 2008 R2 Enterprise. The intention is that if the subscriber goes down, we can use one of the publishers to quickly build up its replacement. Our testing reveals a problem…
Stefan Mai
  • 322
  • 2
  • 9
0
votes
2 answers

migrating from postgres 8.1 to 9.0

We are moving from one server with postgres 8.1 on it to another with 9.0 on it. We were looking to use slony to replicate between the two and already have slony-I 2 on that new server. However, it doesn't work with postgres 8.1, though slony 1.2…
Eric Snow
  • 145
  • 1
  • 5
0
votes
1 answer

Most suitable 'replication' technique for SQL Server 2005

I have a SQL 2005 database that is currently 15GB in size. We do a lot of web / intranet based reporting from thsi system and we're seeing a performance hit as a result. I'd like to create a copy of the live database on another server and have it…
Marko Carter
  • 4,092
  • 1
  • 30
  • 38
0
votes
2 answers

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server as a proof-of-concept for some larger databases…
0
votes
1 answer

Can Exchange 2007 SCR work between servers in different domains (same forest)?

As per subject: if there is an Exchange 2007 server active in domain A, can another Exchange server in domain B (in the same forest, of course) be used as a Standby Continuous Replication (SCR) target for its databases?
Massimo
  • 70,200
  • 57
  • 200
  • 323
0
votes
1 answer

DRBD Replication failure

A couple of weeks ago I setup a 2 nodes CRM system with one of the resources managed being MySQL over DRBD. Today for maintenance reasons I restarted both nodes but now they can't connect to each other anymore. DRBD fell out of sync and I followed…
MrD
  • 235
  • 5
  • 11
0
votes
1 answer

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it…
automatic
  • 205
  • 1
  • 2
  • 5
0
votes
1 answer

Implications of renaming sql server 2000 instance

I have a sql server 2000 of which I want to replicate the data to a sql server 2008. However the output from select @@servername and select serverproperty('servername') on the 2000 server are different and that prevents replication. There is a…
peg_leg
  • 93
  • 1
  • 1
  • 7
0
votes
0 answers

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import procedure doesn't work as well for me as the…
0
votes
1 answer

Percona system tables corrupted

I am having problems setting up mysql replication with a percona as server. accidentally, took a full dump from mysql and restored it on percona and then started,the replication. now when i stop slave and start slave, i am getting the error "[ERROR]…