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

learn more… | top users | synonyms (1)

2
votes
1answer
87 views

Cannot drop distribution database in SQL Server 2012

I am trying to drop distribution database but cannot as I am getting this error: The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset ...
1
vote
1answer
50 views

MySQL replication seems to work but no data is transferred [closed]

I'm trying to set up a one way MySQL replication. All sources I looked for errors seemed fine but no data is transferred. The following sites couldn't help me: http://dev.mysql.com/doc/refman/5.7/...
1
vote
2answers
59 views

In mongodb 3.0 replication, how elections happen when a secondary goes down

Situation: I have a MongoDB replication set over two computers. One computer is a server that holds the primary node and the arbiter. This server is a live server and is always on. It's local IP ...
1
vote
1answer
17 views

mysql off-site replication ( file only )

I am new to mysql, I have extensive experience with MS Access and some with Tivoli. I have tried to search the net for my solution but there is such a massive quantity of results I can't find a ...
0
votes
1answer
77 views

SQL Server distributor server move

I need to move my distributor server to a brand new server without resnapshotting it. The scenario I have is similar to the one defined in below link. http://www.sqlservercentral.com/Forums/...
1
vote
1answer
268 views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
0
votes
1answer
133 views

Size of Binary log file in Mysql Replication

I have a master - server replication setup in Linux servers. Master Configuration details : MySQL version is 5.1 and replication mode is MIXED type. Slave Configuration details : MySQL version ...
0
votes
0answers
90 views

Simple/Easy PostgreSQL HA multi-master for high latency / unreliable network

I have an environment consisting of two servers running JBOSS and PostgreSQL. Each server writes to its own database and programmaticly synchronises some data to the other database. This causes ...
0
votes
0answers
38 views

MongoDB replicaset config info differs among replica members

I have a replicaset running in MongoDB3.0. I did some changes to the replicaset configuration a period after the initial setup. For some reason, I have different replicaset config information in ...
0
votes
0answers
40 views

ERROR: duplicate key value violates unique constraint “repl_stat”

Error messages constantly showing up in log files and I don't know what to do with them: 2015-11-26 11:08:05 MSK ERROR: duplicate key value violates unique constraint "repl_stat" 2015-11-26 11:08:05 ...
0
votes
0answers
35 views

Galera 3 node cluster - force an online state transfer without downtime on existing node

We have 3 node Galera cluster. On node 3 I wish to force a state transfer. We have out of sync issues, because table was MyISAM. Now InnoDB. Howto do that? Delete data files and restart? The cluster ...
0
votes
1answer
107 views

MySQL - Force replication to statement for INSERT to a table to fire trigger on slave

We have a PROD DB which replicates into a slave DB using mixed replication. We want to add a trigger so that a row is added to our DW when a row is INSERTed into table_a (on master). The issue is that ...
0
votes
0answers
12 views

Incremental snapshot in transactional replication [duplicate]

Is there a way to increment the snapshot at the distributor instead of reinitalizing the snapshot every time a new table is added/removed/altered? It is taking a lot of time to generate the snapshot. ...
2
votes
0answers
91 views

How to setup SQL Server 2014 replication for a demo site

Background: We have been looking at replication of our SQL Server 2014 databases for a couple of scenarios.One which just works and its hunky dory and the other which just doesn't seem to work, ...
1
vote
1answer
127 views

How to delete duplicate rows in merge replication

Somehow two rows in a table that is party to merge replication are identical, including their rowguid. I have no idea how this happened, it is only with two rows in my entire database (which is used ...
0
votes
1answer
48 views

Rebuild master database only in sqlserver 2012

How can I rebuild system database master only when I rebuild system database. Is it possible?
2
votes
1answer
80 views

Restoring a replicated SQL Server database in a non-replicated testing enviroment

Sorry in advance if this is already answered, but it's quite difficult to search exactly what I need. We have a SQL Server 2008R2 DB in Production. Originally, the DB didn't have replication. Every ...
0
votes
1answer
28 views

How to disable replication when Distribution db is lost?

I am in the situation that the Distribution database in SQL Server 2014 is lost and I want to disable the replication. I have found a solution how to achieve that when data files are present (also ...
0
votes
0answers
22 views

Semi synchronous Replication passes no data

My master is running MySql 5.6.19, one slave is 5.6.27 and the other is 5.6.21. Everything seems to indicate that replication is running properly, but data on the slaves is not updated. My status is:...
3
votes
1answer
77 views

What about redundancy if distributor goes down?

I'm setting up load balancing, transactional replication and mirroring. However, what I actually thought might work from the beginning, making the system redudant doesn't actually work because a ...
0
votes
1answer
113 views

How to Set Up Sync of two mysql databases without master slave

The purpose is to create the live database replication for staging server but with masking of personal identifiable information like email, mobile, passwords etc. This has to be done once daily, not ...
1
vote
2answers
115 views

Mysql sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 with replication

I'm looking into sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 to improve write performance. There is this question, but it doesn't address the specific problems with replication. I have an ...
0
votes
0answers
82 views

MySQL 5.7.9 multi-source replication

I am trying to set up multi-source MySQL replication. I need to replicate only one database to one slave instance and another database to another slave instance. If I use replicate-do-db in master it ...
1
vote
2answers
26 views

MongoDB Replica Set Failure

Some background I had an issue with my replica set the last 24 hours, where the members could not connect to each other, and I got errors such as; could not connect to .... the machine actively ...
0
votes
0answers
43 views

Modify Script to not include *_snapshot_* databases

We use the script on the website below to script out replication. I would like to add a exclusion of databases that have a name _snapshot_ in the name of the database. http://www.sqlservercentral....
0
votes
0answers
29 views

Attach replicated .MDF file with/without log after OS reinstalled

I have SQL Server 2014 DataCenter RTM Version on Windows 2012 Standard Edition for about 2 months and had migrated a database from SQL Server 2008 R2. The database had transactional replication was ...
0
votes
1answer
30 views

Mysql time shifed replication

We got a system with a Mysql database and a replication on a slave database. We got huge uploads, which will do major changes to the master database. We want to keep the slave database the old version ...
0
votes
0answers
34 views

SQL Server : distribution agent error

In my transactional replication setup, the replication monitor keeps printing this message every 5 mins: Agent XYZ is retrying after an error. 35 retries attempted. See agent job history in the ...
0
votes
1answer
24 views

MySQL Multisource slave as a master?

When deploying MySQL multi-source replication, can the multi-source slave be a master for other 'normal' slaves? I can't find this particular case covered in the documentation
0
votes
1answer
23 views

MySQL Replication Query

Imagine I have three servers. x.x.x.31 - master x.x.x.32 - slave x.x.x.33 - slave If I run a simple update in master. What does the slave servers done. run the update command or copy the updated data ...
0
votes
1answer
289 views

Redis remove slave from replication along with sentinel

I have a 3-nodes Redis replication and a 3-nodes Sentinel. I want to remove one slave. I tried stop slave and remove slaveof 10.128.130.139 6379 from configuration. But it became slave again after I ...
1
vote
1answer
682 views

DBClientCursor::init call() failed

During syncing a slave(SECONDRY) node, I have DBClientCursor::init call() failed error and it's start syncing from scratch, the full log is provided: Tue Nov 10 05:54:56.281 [rsSync] clone xxxxx....
0
votes
0answers
21 views

Mysql replication issue

I added a new replication user to my slave db and accidently spesified the master_host in the change master statement (without specifying the log file and pos). However, its the same master as before. ...
1
vote
1answer
47 views

Triggers on Slave database (in the context of replication) for auditing purpose in MySQL

I have a requirement for auditing in MySQL database. It means I am interested in what data is changed in my database and when. For fulfilling this requirement I am thinking about the triggers. I am ...
1
vote
1answer
73 views

How Merge Replication Works

I'm not DBA at all but I need to do something to synchronize four SQL server databases. I just discover there is a Merge Replication system in SQL Server 2008. At this moment I'm reading the ...
2
votes
1answer
79 views

Can I add an Arbiter node in the same server of my Config-Server?

I'm using MongoDB and I want to know if I can add an Arbiter node in the same server that I'm hosting my Config-Server. Is it possible? Let's say that I have 3 sharded clusters with 6 servers (2 per ...
0
votes
0answers
81 views

Is there replication by “pushing” instead of “pulling”?

Here is the situation: pg 9.4 pg instance "A" in intranet which is often loosing connection with WAN because of satellite problems (primary). This server has dynamic public ip. pg instance "B" ...
2
votes
2answers
65 views

Prevent SQL Server publisher from running out of disk space

I have an issue with transactional replication which leads to running out of disk space. The scenario is following. Database A is replicated to another computer via local distributor with command ...
0
votes
0answers
19 views

Mongodb slave shut down

i started a mongodb master slave but due to technical issues the slave server crashed. I restarted it and the mongod proccess as well with the host parameter, but for some reason the slave isnt ...
0
votes
1answer
335 views

MongoDB replica set: members with different versions of mongod

The primary is running mongod 3.0.6 and the secondaries running mongod 3.0.7 is a mixing of versions allowed in the same replica set? For upgrade it's best practise to not all nodes the same time.
1
vote
2answers
38 views

When one of masters is unreachable all other replica sets work too slow in mongodb 2.6.11 and web application throws error 71

When one of masters is unreachable all other replica sets work too slow in mongodb 2.6.11, also I can not list the databases on mongos servers, and that is because of one replica set. How to solve ...
1
vote
0answers
14 views

Snapshot replication error two days in a row

We have a mature replication system to move data from OLTP to BI. It's been working for years with relatively few troubles. This week we've run into the same problem two days in a row with snapshot ...
2
votes
1answer
25 views

Refreshing a table using CREATE TABLE, DROP and Rename

A read-only database (database1) is updated via log shipping every minute, then a procedure queries multiple tables in it and refreshes a large table on database2. For this process I run an "...
1
vote
0answers
79 views

Redis master and slave use different memory

I deployed a redis replica set which consist of one master and one slave. From top command output, I figure out each memory usage. master: 8176352Byte * 8.5% = 678MB slave: 2050116Byte * 75.6% = ...
0
votes
0answers
109 views

Golden Gate replication from primary to secondary database, WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rgg1ab.prm: SQL error 1403

I am using golden gate to replicate data from primary(Oracle) to secondary (Oracle). I have inserted records in the primary database, but replication abdends with error message WARNING OGG-01154 ...
0
votes
0answers
72 views

Galera Cluster crashes because of “ALTER TABLE” statement?

We use on RHEL7 # rpm -qa | grep maria mariadb-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.41-2.el7ost.x86_64 mariadb-galera-server-5.5.41-2.el7ost.x86_64 Do I analyze logs correct that Galera ...
1
vote
0answers
54 views

SQL Server 2012 Merge replication not replicating all changes

Having a problem with replicating a database between two servers, both running SQL Server 2012. We have a table where each site that stores the database updates a record every minute with the current ...
2
votes
1answer
358 views

How to recover Postgres replication slave after fatal error

On 4 Debian 8 Jessie servers, I have PostgreSQL 9.4.3 master + 3 slaves. After substantial data changes on master, slave logs showed this error: LOG: started streaming WAL from primary at 182/0 on ...
1
vote
2answers
73 views

SQL Replication across the internet give named pipe error

We've had a db replication working between two servers across the internet. Server A is sitting on our server network (Windows Server 2008 + SQL Server 2008 R2) Server B is sitting on a different ...
0
votes
0answers
90 views

PostgreSQL streaming replication with slots works for one slave, but not for another slave

Master (10.0.0.1): Edit postgresql.conf listen_addresses = '*' wal_level = logical max_wal_senders = 3 max_replication_slots = 3 hot_standby = on Edit pg_hba.conf host replication ...