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

SQL Server 2008 One-Way Mirroring

I'm new to DB admin but learning fast. We have a large SQL Server 2008 setup and I've just implemented a three-stage testing system - Alpha, Beta and Live servers. All three run the same version of SQL Server (though Alpha is x86 while the others…
0
votes
3 answers

Rebuilding corrupt slave by copying mysql folder

Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing? master mysql> SHOW MASTER STATUS\G (take notes) slave mysql> STOP SLAVE; Shut down master and slave…
Chris Weiss
  • 25
  • 1
  • 6
0
votes
1 answer

is it possible to lower the priority of the replication process in sql server 2005

we're planning on running transactional replication of a part of our database for some near-time reporting. I'm not quite sure which process will run to 'do' the replication, but is it possible to give this process a lower priority then sql server…
Michel
  • 239
  • 2
  • 4
  • 10
0
votes
2 answers

Manually Removing a Replicate Domain Controller

I have a single domain environment on Active Directory, Windows Server 2003. I created a replicate domain controller to put on a remote LAN connected via site-to-site vpn. I shipped the server but now we have decided not to use it. Instead of me…
ItsPronounced
  • 634
  • 4
  • 18
  • 40
0
votes
2 answers

MySQL binlog not logging

Have added the directive in my.cnf log-bin Both the binlog and index files are created, but seems the binlog file remain unchanged even I massively insert data into the db.
Howard
  • 2,135
  • 13
  • 48
  • 72
0
votes
1 answer

MySQL master-slave replication with more than 1 server

Is it possible to setup replication for database_A from master_A and database_B from master_B server? It looks like I can only set one master-host in MySQL configuration file. Thanks in advance.
Emre A
0
votes
4 answers

Is database locked when it's in replication process?

I'm doing POC on database replication, and I'm stuck with question from my boss. Is database locked when it's in replication process on SQL Server 2005?
Ekkapop
  • 113
  • 1
  • 4
0
votes
3 answers

Disaster Recovery - using Double-Take for live replication to DR on a developer's client machine with Visual Studio running

Our Systems team is implementing Double Take on client machines for live replication to DR servers. Developer's desktops typically have multiple instances of Visual Studio open at all times which generate 4GB of write IO per hour. Even when Visual…
Tion
  • 121
  • 4
0
votes
1 answer

How long does initial replication take in DFS?

I have two windows servers, one 2008 SP2 R1 ( x86 ), and the other 2008 R2 running a 2008 DFS namespace, and replicating between the two. I have approximately 600GB of data being replicated over a 1Gbps LAN. I set replication up almost a week ago,…
Russ
  • 330
  • 3
  • 8
  • 17
0
votes
1 answer

P4000 and ESX storage design

I need help and advice how to design my volumes to fit the need - good performance for sql type application, no lack of performance for file servers, remote copy or replication to dr site for protection for 90% data. my situation - site A (…
user40997
  • 77
  • 5
0
votes
1 answer

How to reduce size of Distribution database used in MSSQL replication

Size of distribution database used in transactional replication has increased significantly, it is almost double of the database being replicated. Size of replicated database is 18 GB and distribution database is 35 GB. Is this normal? If so can…
Mani
  • 146
  • 2
  • 8
0
votes
1 answer

Can I replicated 2 SQL Server database with foreign key in some tables?

Assume I've 15 databases, 1 is main database and another is database located at various site. I need to create replication between main database and another. My fellows have tested replication and they conclude that replication can't working…
Ekkapop
  • 113
  • 1
  • 4
0
votes
2 answers

No data coming from the perfmon statistic SQL Server: Replication Dist

I am trying to get the statistics from my 2008 sql server replication SQL Server: Replication Dist. statistics, but no data is coming even while replication is in full swing. I am using SQL 2008 peer-to-peer replication and use a load test on our…
Nat
  • 345
  • 1
  • 9
0
votes
2 answers

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online and learned that to fix this you either have to…
0
votes
1 answer

Problem in SQL SERVER 2008 Replication

I Synchronized a database from one server to another server by using Replication... Server1 is Publisher and Server2 is Subscriber. I have created a table in that database in both the servers. when i added a data into that table,It will also…
Suryakavitha