Questions tagged [replication]
Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
3,521
questions
7
votes
4
answers
4k
views
Duplicate database and keep it up to date - Replication or SSIS?
I would like to duplicate a database, on the same server, and keep it up to date either by running a scheduled service once a day or having SQL Server 2008 take care of this internally.
We don't need ...
- 215
3
votes
1
answer
3k
views
master to multi-slave replication
I am looking at replication of the master database (PostgreSQL) and this is the configuration I have to setup
master -- hot-standby (hs)
|
|
--- read only slave (r1)
|
|
--- read only slave (r2)
...
- 31
5
votes
1
answer
1k
views
What are the common reasons for a Subscription to be deactivated in SQL Server 2005?
I am trying to manage database replication in SQL Server 2005. I have set up my publications, distributors and subscriptions and it seems to work properly at the start.
However, after a period of ...
- 53
4
votes
2
answers
5k
views
Can I have different publishers and one subscriber in replication?
I have the same databases in three cities which each database have three tables:
1- tbl_worker
2-tbl_workshop
3-tbl_users
and cities are:city1,city2,city3
city2 and city3 insert informations in ...
- 269
2
votes
2
answers
2k
views
Does the target for Double-Take replication require an Oracle license? [closed]
Where would Vision Solution's Double-Take product fall with regard to Oracle Licensing? It is both a backup and a replication of the database. Oracle's Software Investment Guide has a section on ...
- 23.9k
8
votes
1
answer
11k
views
MySQL high availability, failover and replication with Latency
We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...
- 1,367
3
votes
2
answers
2k
views
SQL 2008 R2 3rd Party Peer-to-Peer Replication, Global Site Distribution
We are looking at hosting 3 globally distributed SQL Server installations at different data centers. The intent is that Site A will serve web traffic and data for a specific region, same with Site B ...
- 33
6
votes
1
answer
5k
views
database duplication VS database replication
Is there a difference between duplication and replication with reference to a database?
I am not sure if I am correct at all, but duplication means to me that we are copying bit by bit without ...
- 3,361
3
votes
2
answers
6k
views
Script to Monitor MySQL Replication
G'Day,
I am looking for a bash script (using Perl - As that is already installed on the machine and I don't want to have to install Ruby, Python etc. just for this requirement) that will perform some ...
- 197
8
votes
1
answer
4k
views
MySQL master binlog corruption
We recently made some changes to our infrastructure and now I can't keep MySQL replication running. The slave complains of a corrupt binlog and resetting it doesn't help. I keep seeing entries like ...
Joseph Yancey
2
votes
1
answer
684
views
SAN Storage & Server for Oracle Replication
I need a 2-3 TB storage server group for Oracle Database. We want SAN Storage & Server for Oracle Replication, but not Microsoft Storage Server.
For example : HP DL380 G6 as a server and EMC ...
- 1,088
7
votes
4
answers
4k
views
MySQL Replication - Introduce new Slave to replication
I've recently taken on a sys admin position managing a group of 20 (or so) servers. One thing I haven't dealt with before (apart from in a test situation), is introducing a new slave to the MySQL ...
- 71
11
votes
4
answers
29k
views
Replicating a remote MySQL database to MS SQL Server 2008
I want to replicate the contents of a MySQL database to a MS SQL Server 2008 database.
Is this possible? Can anyone outline the steps required in order to achieve this?
Thanks.
- 297
10
votes
2
answers
9k
views
How can you stop MySQL slave from replicating changes to the 'mysql' database?
I have my slave set to not replicate the 'mysql' database as described in this SHOW SLAVE STATUS\G;
Slave_IO_State: Waiting for master to send event
Master_Host: 127.0.0.1
...
- 23.5k
13
votes
5
answers
5k
views
Is it unwise to run replication on same physical server?
I'm contemplating setting up a Master-Slave replication for my database. The slave server will be used for redundancy and possibly a reports server. However, one of the biggest issues I'm running into ...
- 23.5k
6
votes
4
answers
3k
views
Is there a way to measure replication lag in MySQL with a resolution less than 1 second?
Is there a way by which you can measure replication lag in MySQL with a resolution of less than 1 second?
That is, can replication lag be measured on the microsecond or millisecond level?
- 1,377
6
votes
2
answers
868
views
Best practices to run time offset delayed replication
I want to setup replication system on postgresql like #1 MASTER SERVER and two replicated servers: #2 SERVER in realtime (for load balancing), #3 SERVER delayed with some time offset (for example 2 ...
- 207
10
votes
1
answer
2k
views
What is the difference between PostgreSQL 9.0 Replication and Slony-I?
Is there still any use for Slony-I, and if so, what is it? For clarification, from 9.0 Postgresql supports built in streaming replication.
- 263
5
votes
3
answers
3k
views
With MySQL Replication, what level of resilience is possible?
I've found lots of good material on setting up MySQL replication, but not much on what to do in the event of failures. Understanding the degree of resilience I can achieve is fundamental to designing ...
- 151
0
votes
1
answer
2k
views
Sql Server merge replication primary key violations
Using Sql Server 2008. Pretend I have a publisher and 2 subscribers A and B. The replicated table has a guid on it and also a primary key that is not the guid. Frequently, updates happen at both ...
Gary
83
votes
7
answers
194k
views
How do I completely disable MySQL replication
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
David Collie