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
26 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 ...
3
votes
1answer
63 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
74 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
76 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
68 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
25 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. ...
0
votes
0answers
25 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
33 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
22 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
192 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
490 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 ...
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
41 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
63 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
63 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
73 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
64 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
18 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
216 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
35 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
66 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
88 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
62 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
47 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
237 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
59 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
67 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
72 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
56 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
51 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 ...
1
vote
1answer
187 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
0answers
156 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 ...
0
votes
1answer
45 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
2answers
39 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
1answer
28 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 ...
1
vote
1answer
47 views

Postgres 9.3 copy data from another table with relation [closed]

Hi I have two tables in my database which is related, which is forms and qa_forms. forms ->id ->name -address -phone -calldatetime and then ` qa_forms ->id ->forms_id ->name ...
1
vote
1answer
61 views

Replication: Procedure or function sp_MSupd_PROC has too many arguments specified

Source is one service pack behind destination (2012). I know service packs can be issues here, but it looks like this is only for versions 2000 and 2005. When using sp_helptext sp_MSupd_PROC the ...
0
votes
0answers
88 views

Remove column from transactional replication

I have a situation where in I need to remove 1 column from transactional replication without actually dropping the column from table. Is it possible to remove it? When I try to do it from GUI it ...
0
votes
2answers
31 views

Replication Setup what's the value of MySQL auto_increment and offset in my.ini

I have setup master master MySQL replication to sync changes in both servers. Now I want to setup 6 servers, is that possible? I'm making 6 because when an area lost it connection over WAN it will ...
1
vote
2answers
115 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 ...
0
votes
1answer
113 views

Error “The publication '[Name]' does not exist.” running sp_article_validation

DECLARE @p SYSNAME, @a SYSNAME SET @p = N'[NAME]' SET @a = N'[ARTICLE]' EXEC sp_article_validation @p,@a I'm using the exact name of the publication provided by the table MSpublications (even using ...
1
vote
2answers
31 views

Replication fails exactly after a week

We are application developers trying to decode why replication is failing. It fails every week on the same day pretty much same time. This has been happening for about a month now and our vendors ...
0
votes
2answers
33 views

Distribution Server (1) Replicating Source Server (2) To Destination Server (3)

I'm setting up replication from a source server to a destination server using a third party distribution server. I've added the source server to the list of publishers on the distribution server ...
0
votes
0answers
35 views

postgres: async statement based replication?

I've noticed that all SBR replication solutions listed on PG site are also synchronous. Is it a mere coincidence? Can there be an async SBR? e.g. a statement is received by a master (or some ...