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
0answers
6 views

Is it possible to replicate a trigger but prevent it from running during synchronisation?

We are using SQL Server 2008r2 as the publisher and Express editions as subscribers, with merge replication and pull subscriptions. A replicated table has an update timestamp, as a datetime column. ...
0
votes
2answers
330 views

Postgresql Chained Slaves and Slave Promotion

So I have a setup like Master -> Slave1 -> Slave2. Slave1 replicates from Master and Slave2 replicates from Slave1. If I promote Slave1 to master is it possible for Slave2 to continue replicating from ...
3
votes
3answers
312 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
0
votes
1answer
1k views

SQL Server 2008R2 - how to install replication components

I am trying to install the Replication components for SQL Server 2008R2, on technet website it says: On the computer that is running IIS, insert the SQL Server 2008 R2, SQL Server 2008, or SQL ...
1
vote
1answer
392 views

Slave Waiting to reconnect

I have added new slave host to master for replication, but missing some of the parameters. mysql> show slave status\G *************************** 1. row *************************** ...
0
votes
0answers
5 views

MongoDB unrecoverable replication error

One of member of my MongoDB replica set decided it would not restart, with the following error (reformatted for readability): Starting rollback due to OplogStartMissing: our last op time fetched: (...
0
votes
1answer
351 views

Using non-replicated read/write databases on a MySQL slave server

I have a MySQL slave server that has two databases being replicated from a master. What I'd like to do is add a third database that I will exclude from replication and use as a read/write database. ...
0
votes
0answers
5 views

empty Galera cluster with mysqldump backup - what does “WSREP: Provider paused at” and “WSREP: Provider resumed” mean?

We operate an empty Galera cluster (without customers): MariaDB [(none)]> SELECT table_schema "DB Name", -> Round(Sum(data_length + index_length) / ...
0
votes
1answer
195 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
1
vote
1answer
159 views

How to measure or estimate the streaming replication lag in Postgres 9.2

I've been asked to reverse engineer an app that uses postgresql in the back end. I can see that there is some database replica tion going on... based on my reading, I *think it's called streaming ...
1
vote
0answers
13 views

Is there a way to synchronize mysql databases that are missing a few days worth of data

I have a primary-primary MySQL server setup that is connected to a load balancer. At one point, a failure occurred to where the replication wasn't happening and data was being written to one server ...
0
votes
1answer
11 views

Postgresql: replica and HA

I've postgresql 9.4. I'm aware that there are many answer on DBA and SO, I'm aware of the wiki and the documentation. But anyway, I can't understand in a simple way what's the right way to have a ...
1
vote
0answers
90 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
10 views

SQL Server Replication with AWS EC2 and On Premise [on hold]

Is this going to be seamless as if not using AWS? Main concern: 1) Different domain. 2) Usage of Instance name. I know we can do it even on RDS using this 3rd party tool, https://aws.amazon.com/...
4
votes
1answer
3k views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
1answer
127 views

Laggy slave OK to have only one system user in processlist?

In all the examples of a processlist on a mysql slave I've seen, there are two system users. I have a slave that is very far behind the master. When I do show a processlist, there is only one system ...
0
votes
1answer
608 views

MySQL 5.6 replication causes 'waiting for table lock'

All of the sudden queries on slave server stopped with status "Waiting for table level lock" I restart mysql service and stop replications and locking does not show up anymore. Once I turn ...
0
votes
0answers
13 views

View-Specific MySQL Replication

I'm trying to replicate only a portion of a table on Computer A (running an instance of MySQL) to a MySQL instance on Computer B, something that could easily be represented by a view. I know it is not ...
1
vote
1answer
119 views

PostgreSQL streaming replication lag for synchronous standbys

We use PostgreSQL 9.5 in a master + synchronous hot-standby setup, i.e., using synchronous_commit = on and using synchronous_standby_names='*'. Consequently, the standby has sync_state = sync in the ...
0
votes
1answer
9 views

Why do cross-database statements break replication when using filters?

For example, say you you have table A and table B on the master and on the slave you've set up replicate-do-db = A. Now if I do something like this: USE B; DROP TABLE A.sometable; Why should this ...
1
vote
1answer
3k views

Permanent count of waiting tasks (2) in Activity monitor

Now I'm observing in Activity Monitor permanent count of waiting tasks: and at "Resource waits" tab I see next: so, my question is: How to find and resolve this wait tasks? I suspect that it ...
0
votes
0answers
11 views

MongoDB HA by reading from Last Secondary not working

Our topology is (1 MongoDB server at each location) Primary Datacenter (main server, priority 10 ) DR datacenter (active standby, priority 5) On-Prem datacenter ( When shiz hits the fan, priority .5)...
1
vote
1answer
168 views

Write-lock a whole table during transaction

I need to perform a delicate operation to my table in which I will solely insert, delete and select upon all of my rows and no God may interfere with the table during this operation: the table will be ...
0
votes
1answer
12 views

repmgr 3.0.4 and postgres 9.4 on ubuntu (ERROR: replication slot “repmgr_slot_2” does not exist)

I'm not a DBA but I have been tasked with setting up a database and streaming replication and repmgr is the tool I have decided to use. The master goes on fine and I can see it registered in the ...
1
vote
1answer
31 views

Replication from Enterprise to Standard edition

Can I define transactional replication while the Publisher and Distributor are both Enterprise Edition and the Subscriber is Standard Edition? What do I need to consider in case it is possible (given ...
3
votes
1answer
418 views

Bi-directional replication for the same MySQL table

AppA stores/retrieves data from dbA.tableA AppB stores/retrieves data from dbB.tableA tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA (...
0
votes
1answer
16 views

Trying to understand MySQL Replication with SSL

I'm trying to get my head around the use of SSL with MySQL replication. I've spent all day reading blog posts / articles about this, and I'm still no closer to getting an answer to this question: ...
1
vote
0answers
13 views

Replication prioroty

I have two MongoDB instances running on two servers (instance1 and instance2) and they are configured as a replica set. Instance1 is the primary and instance2 is the secondary. When instance1 was ...
0
votes
1answer
383 views

MySQL - Enabling Scheduled Event on Master and Slave Simultaneously

This may seem a bit strange, but I am trying to get a Scheduled Event to execute on both Master and Slave. I have two databases set up in a Master (A) to Master (B) replication environment. Master A ...
0
votes
1answer
25 views

SQL Replication, transactions Replication

I have configured a SQL transaction replication to create two subscribers and one publisher, the question is that after any deployment and changes that made on the SQL "alter procedures" on the ...
2
votes
1answer
489 views

Can a slave with a dynamic ip update the master

How can I setup mySQL replication in such a way that a slave on localhost with dynamic IP can update the master as well as get updates from the master which has a static IP. The slave will not be ...
0
votes
0answers
12 views

Galera segments relay node — is there a way to prefer one?

I have geo-distributed cluster with 2 segments. Main segment is in Singapore, secondary -- in Europe. Recently I found out, that one node of main segment has RTT to Eu node about 5 times less, than ...
0
votes
1answer
16 views

Database Replication/Mirroring for Reporting Purposes

I am pretty green to the administration end of databases, but I was hoping you guys could direct me on the right path. I have Server 1, 2, and 3. They both identical versions of SQL Server, with an ...
0
votes
1answer
226 views

How to setup sync between MongoDB and C# .NET Application

What is the best practice to synchronize a MongoDB remote database with a C# .NET App that would allow queries to be responded to within the local file system and update itself when there is a change ...
1
vote
1answer
304 views

mysql replication missed quite a lot SQL statement

I have set up a master/slave with mysql-5.1.73 The master's binlog format is "statement". The master and slave seemed running very well with slave status: Slave_IO_Running: Yes ...
0
votes
1answer
83 views

How could duplicate entry on unique key happen if only one master is active?

Say, I we have master-master replication with only one master active at a time. We have users table: create table users ( id int auto_increment, email varchar(255), primary key id(id), unique ...
1
vote
1answer
2k views

Replicating data from Oracle to MySQL

I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has ...
9
votes
6answers
3k views

Transaction Log won't shrink, DB thinks it is replicating

I've got a SQL Server 2008 R2 Express database running Kaspersky Security Center, and I have no idea under what circumstances the install happened, but the database appears to think that it's being ...
0
votes
0answers
32 views

MySQL replication: Master to Multiple Slaves with table filtering

I have 2 separate web systems (A, B) that will end up using the same 5 tables. I'm using MySQL. System A has only one database (A1). System B has at least 3 databases (B1, B2, B3) on different ...
1
vote
5answers
441 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
0
votes
0answers
8 views

Pervasive v10 - DXDeact Error - System DSN found but no longer valid

I've inherited a Pervasive database (v10.21.0025) that replicates between two servers. Recently the replication became corrupted. I attempted to re-sync the two databases but immediately ran into an ...
2
votes
1answer
216 views

MySQL slave server getting stopped after each replication request from Master

Basic master-slave MySQL configuration has been done on Windows machine. Master and slave servers are running on localhost with different ports. Now when executing update or insert in master server, ...
0
votes
1answer
115 views

Error while doing in replicaset in windows (mongodb)

I tried doing the replicatset in windows, but im getting the below error. I checked the mongo process and killed the existing process. Even though the error exists. help me on this pls Thx ...
1
vote
1answer
164 views

Indexed view doesn't exist on the subscriber

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...
0
votes
1answer
103 views

MongoDB replication doesn't work using Java driver

I have a three instance replica set and i am using the following code to insert values in my mongodb database constantly. MongoClient client = new MongoClient(Arrays.asList( new ...
0
votes
0answers
3 views

Pervasive Replication - DXDeploy Error - Failed to butil-copy file

Pervasive database (v10.21.0025) that replicates between two servers. Recently the replication became corrupted. At the advice of the previous DBA, I attempted a manual clean up of the replication job ...
0
votes
0answers
30 views

Postgresql promoting slave server to master

I am trying to setup Postgresql(9.4) master-slave cluster. I am using the following tutorial: http://linux.xvx.cz/2014/10/loadbalancing-of-postgresql-databases.html The issue I am facing at the ...
0
votes
1answer
18 views

MySQL replication on slave server Broken/Stopped without error

(Hi; sorry for my English) My question is: how can I restart MySQL replication on a slave server. At first sight everything seems to be normal but when I check with SHOW SLAVE STATUS\G besides ...
1
vote
1answer
7k views

MySQL slave stuck at 'System lock' most of the time, high CPU usage

Let me describe what we are facing now: We have a MySQL Master-Slave, Row Based Replication setup and at the moment, the slave is stuck with a perpetual System Lock. The Master is an active server ...
1
vote
1answer
519 views

Syncronize mysql databases between local and hosted servers automatically

We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one ...