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)

1
vote
2answers
48 views

With MySQL 5.6, Is there any way to keep a replication slave X seconds behind_the_master?

It'd be really nice for disaster recovery to be able to set this up. We are doing snapshots, but this seems like it'd be a really nice backup to have. For example, I'd like to always keep a ...
1
vote
2answers
430 views

ERROR Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

We are facing the issue in replication that we are not getting any error in Show slave status\G output rather facing the following issue in Error Log File [ERROR] Error reading packet from server: ...
3
votes
1answer
38 views

Clarification on Database Replication

SQL Server 2008 I have to do database replication which is a new for me. Goal is have mirror database on servers 2 and 3. When we set up database replication in the Server 2, 3 from Server # 1, ...
3
votes
2answers
47 views

Replication DB move

I have 2TB of DB involved in SQL Server transactional replication. I want to move publisher DB files to a newer disk with minimum amount of downtime and without breaking replication. Please let me ...
1
vote
0answers
24 views

After disabling replication, should I disable binary logging?

I have a master-slave setup currently but am going to remove the replication DB server. The DBs are running on MySQL 5.6. I have a couple of questions about removing the replication: 1) I have read ...
1
vote
1answer
12 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 ...
1
vote
2answers
36 views

Database mirroring with fixed set of tables without sql server replication

We have requirement of mirroring the database with some fixed set of tables. We do not want to use sql server replication for that purpose. Do we have any solution for that or any software for this ...
1
vote
0answers
21 views

Replication of Database in PostgreSQL

I want to Replicate my PostgreSQL, in the website there far too many options, I want to know which one to choose. I have a main server which the database is stored at. Inserting, editing and deleting ...
3
votes
1answer
349 views

MySQL master slave replication not working

I had MySQL master slave running and working fine but suddenly it stopped. I don't know which commands have been executed but now replication is not working. I am very new to MySQL can anyone help me? ...
1
vote
3answers
328 views

postgreSQL hot_standby pg_dump on slave

I have master-slave (hot_standby) pgsql configuration and I want to make backups from one of my slaves. I don't want PITR, just good old database dump. I switched to postgres from MySQL. With MySQL ...
0
votes
0answers
30 views

Merge Replication with Static Filters - Does not Delete from the subscriber database?

I have a merge replication setup, I have applied static filters so as to send only specific rows to the subscribers from a publisher (table) say 'X' the filter is " where Name Starts with 'T' ". Now ...
0
votes
1answer
40 views

How can I use Oracle Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database?

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
0
votes
1answer
16 views

Automatically purging binlogs after successful replication

I have a dedicated server hosting a MySQL database, and want to use replication to have an always up-to-date backup somewhere. I chose to use Amazon RDS as my replica, and I'm following this guide: ...
1
vote
2answers
33 views

mysql replication master - slave

I have a setup of two databases, master - slave. Slave was stooped for about two weeks and old binlogs binlogs purged from master but copied on another fs before purging. Slave can't catch up the ...
0
votes
0answers
15 views

Problem with MySQL Delayed Replication

I am testing out MySQL Delayed Replication. But it's not working. I have a Master DB (5.5) and a Slave DB (5.6) both set up as a normal master/slave setup with statement based replication. On the ...
0
votes
1answer
19 views

mysql ssl replication - fails while attempting to connect to master

I'm trying to troubleshoot why my slave cannot connect to the master. This is what I see in the output from the command "show slave status \G" mysql> show slave status \G; ...
0
votes
2answers
45 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 ...
1
vote
3answers
195 views

Replication taking too much time between requests

We are using transactional replication in SQL Server 2014 with one master (publisher), 1 distributor (dedicated server), and 3 slaves (subscribers). All writes are made to master and reading is done ...
1
vote
0answers
33 views

Query slow on subscriber but fast on publisher (Merge Replication)

As the title suggests, I am having issues with performance with my subscriber. I run the exact same query (it's a recursive query with a few joins but nothing too serious). I can run this query on my ...
1
vote
2answers
37 views

Merge Replication - Deleting from the subscriber database?

I have 2 SQL Server instances where I use merge replication on a database. A developer accidentally inserted data to both the subscriber and publisher at the same time. Now I have data in both ...
0
votes
0answers
40 views

Bucardo Postgresql replication master-master windows

Is it possible to use Bucardo installed on linux PC to replicate master-master postgresql 9.4 for two windows servers.
2
votes
1answer
48 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 ...
0
votes
0answers
23 views

Postgresql hot standby what happens when Master is down

Beginner question. When Master is down hot-standby become automatic master? When old master is up what happened to hot-standby and meanwhile data insert in hot-standby how is transfer to the ...
2
votes
1answer
46 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 ...
2
votes
1answer
4k views

MySQL: What happens to the row when skip-errors=1062 is set

I found out that I can set skip-errors=1062 in the my.cnf but I need to know what happens to the row when the error happens. Does it get silently dropped? Or is that config option the equivalent to ...
1
vote
2answers
30 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
33 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: ...
2
votes
0answers
31 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, ...
0
votes
1answer
41 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
1answer
33 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. ...
1
vote
1answer
67 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
0answers
41 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
24 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
27 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 ...
1
vote
4answers
65 views

Execute a script after transactional replication setup completes

We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute ".SQL File" at subscriber database. Please help on this. ...
0
votes
0answers
10 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
49 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. ...
7
votes
5answers
2k 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
30 views

Galera cluster: fix out of sync tables

I have a table XXX, this table has on all 3 nodes different number of records. This table uses auto_increment key. I wish to resync this table from master to slaves. # yum install ...
1
vote
1answer
61 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
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
58 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
43 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
38 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
611 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
39 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 ...