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)

0
votes
1answer
44 views

Rebuild master database only in sqlserver 2012

How can I rebuild system database master only when I rebuild system database. Is it possible?
0
votes
1answer
62 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 ...
2
votes
1answer
44 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
20 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 ...
3
votes
1answer
53 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
0answers
20 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 ...
0
votes
1answer
39 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 ...
2
votes
2answers
629 views

Secondary and Arbiter stuck in Startup

I'm using MongoDB version 3.0.0. I'm trying to setup mongodb replication on our machine. Replication was initially setup but due to some changes on the VM the entire thing crashed. When I tried to set ...
0
votes
0answers
44 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 ...
0
votes
0answers
41 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. ...
1
vote
2answers
30 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 ...
0
votes
0answers
30 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
0answers
12 views

Attach replicated .MDF file with/without log after OS reinstalled [Reposting in right forum]

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
25 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
1answer
23 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
7
votes
1answer
71 views

Capturing change deltas when database replication or CDC breaks

The company I work for is in the process of implementing change data capture on a Microsoft BI stack for the purpose of capturing incremental changes that need to be loaded into the data warehouse. So ...
0
votes
1answer
1k 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 ...
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. ...
0
votes
1answer
16 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 ...
1
vote
1answer
172 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 ...
1
vote
1answer
33 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
52 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 ...
1
vote
0answers
13 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
2answers
62 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
63 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" ...
0
votes
1answer
107 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. ...
0
votes
3answers
2k views

SQL Server replication service in Amazon RDS

I have a local infrastructure with multiple SQL Servers. Some of the servers have replications services to copy some data to a master database. Is it possible to have the replication services to work ...
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 ...
0
votes
0answers
15 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 ...
1
vote
0answers
40 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% = ...
1
vote
0answers
93 views

Setting up multiple databases in Vagrant

Currently I am using Vagrant 1.4.3 in-conjunction with VirtualBox running Unix (Centos) for my development server (using MariaDB). I didn't setup the box myself (so my knowledge of setting this up ...
0
votes
0answers
63 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
45 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
40 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
115 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
45 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 ...
2
votes
1answer
134 views

Cannot start SQL Server replication as already running

I'm trying to configure a sql replication on the sql server 2012 . I am logged in as "sa", when I attempt to start replication i get the following error : How can I stop this job and restart the ...
0
votes
0answers
49 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 ...
1
vote
1answer
52 views

How to Properly shutdown and disassemble SQL Database Replication

While testing SQL Server Replication we setup Replication on our ERP Test DB from SQL Server Enterprise to SQL Server Standard. We have since got replication up-and-running on our Live database and ...
1
vote
1answer
38 views

Options for creating a read-only replica of a DB2 database

We are a dev company that develops and supports an application based on DB2 LUW 10.5 for a customer. We have a VPN that gives us access to our customer's production environment, and we often connect ...
1
vote
0answers
36 views

Is it possible to synchronize multiple databases in to 1 database with the same tables?

We are facing a situation where we have 5 different businesses with comparable data and are building 1 single application to deliver their data to common customers. In order to do this, the plan is ...
0
votes
1answer
80 views

Postgresql Streaming replication - monitoring

I have setup streaming replication for my postgres servers. I am using PostgreSQL 9.2.6. Replication seems to be working fine. I am monitoring this with two ways using nagios: Log_delay and ...
1
vote
1answer
93 views

mongo converting standalone to replica set causes services down

I have standalone node1 already running for a long time. Now I want to convert it to replica set. I followed steps in https://docs.mongodb.org/v2.4/tutorial/convert-standalone-to-replica-set/ to ...
0
votes
1answer
37 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
1
vote
1answer
7k views

MySQL slave stuck in “Reading event from the relay log”?

5.5.28-log MySQL Community Server (GPL) by Remi binlog-format=MIXED My problem is similar to this question. *************************** 2. row *************************** Id: 973415 User: ...
0
votes
0answers
88 views

Mysql dump import shows error 1556 (HY000) “you can't use locks with log tables”

I'm trying to setup a replication slave for an existent MySQL server. Therefore I dumped all data from the master like this: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob ...
1
vote
1answer
34 views

Replication not updating all tables

Master db MySQL db Server 2012 Slave db MySQL Win7 XAMPP DB size 500MB Table count 42 I have setup the replication successfully however it stopped last week and my slave was showing the error ...
1
vote
2answers
35 views

Should I convert timezones when moving data to a report server/data warehouse

I'm writing an SSIS Package to take data from a production DB to a reports server/data warehouse. The other databases on my reports server are all in Mountain Time but this DB is in UTC should I ...
1
vote
2answers
66 views

MySQL replication - database size is different

I have enabled MySQL master-master replication with 2nd master acting as read-only. Recently I checked the out the size of the databases in both master and slave and I found that database size in two ...
1
vote
1answer
27 views

How to setup multi master replication in mysql

After hours of searching I find lots of tutorials that do only 2 server Master Master. Now I wonder how to setup multi master setup because this is more suitable in my business. Because when the WAN ...