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
199 views

Got fatal error 1236 Slave has more GTIDs than the master has, using the master's SERVER_UUID

We are testing replication using GTID's on two servers running MySQL 5.6. Replication was running fine, but now it is not functioning. When I run show slave status\G on the slave, I get the following ...
6
votes
1answer
70 views

How do I replicate a database over 2 geographical sites?

Disclaimer: I have no idea what I'm talking about here, or if what I'm doing is the correct thing to do. Long story short, my superior has asked me if it's possible to replicate our internal database ...
1
vote
1answer
68 views

Masters database not replicating on slave after restarting client

I'm trying to implement master slave replication and It's works fine with no errors, database is replicated on slave, but when I close my servers and open them again and add something in masters ...
3
votes
1answer
37 views

Is it possible to use Change Tracking on a Replication target?

We have a setup where the production SQL Server databases are replicated to an offsite location using SQL Server Replication (transactional replication). I am looking at using SQL Server Change ...
2
votes
1answer
507 views

Slave can not handle replication events with the checksum that master is configured to log

My slave is not connecting to the master and is showing the error Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum ...
2
votes
1answer
40 views

How to make most of aws?

I'm new to aws (just one day old). I'm impressed with aws free tier and want to utilize to its best. As of now I'm done with installing mongodb on aws micro instances and mongod EC2 instances are ...
1
vote
1answer
49 views

master-master replication or master slave replication?

We have right now one server with a database. A device and a website are accessing that database causing load What I want is to create two servers master-slave where master databases are replicated ...
1
vote
2answers
33 views

Master Slave database syncronization

Hi I have just started reading about this replication concept and one thing I want to ask is that when we change something in the slave db how is it going to effect the master db? Is there a sync algo ...
0
votes
1answer
60 views

mysql replication master-slave with 2 or more users in master

I've just configured mySQL replication master-slave. I have into master instance 3 user: root (with all privileges and grant), admin(with all privileges) and slaveUser(with replication salve ...
2
votes
0answers
22 views

a story about a bad replication issue - insight needed MYSQL

A id val B id A_id We are not sure of what happened but it appears that when replication occurred on a series of these two table datasets, that A failed replication, but another insert got the lost ...
0
votes
0answers
26 views

Slony PostgreSQL replication from Chile to US (between datacenters)

We are moving from a datacenter in Chile to one in AWS (in USA). We've already moved most of our servers but the database (PostgreSQL). As the source server is in a VMWARE environment, we took a copy ...
1
vote
2answers
51 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 ...
3
votes
1answer
39 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, ...
1
vote
0answers
35 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 ...
3
votes
2answers
54 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
2answers
38 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 ...
0
votes
0answers
37 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 ...
1
vote
1answer
82 views

Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs

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

Mysql Replication Grant Privilages and Different row records

I followed the steps answered in the following question Setting Circular Replication in mysql I applied this steps in only two nods not three nods I was trying to add commend answer ...
0
votes
1answer
19 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: ...
0
votes
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
21 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 ...
1
vote
0answers
58 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 ...
0
votes
1answer
23 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
0answers
83 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.
1
vote
3answers
207 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 ...
0
votes
0answers
28 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 ...
1
vote
2answers
83 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 ...
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 ...
2
votes
1answer
65 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
38 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: ...
1
vote
2answers
37 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
15 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
57 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
179 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
95 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
77 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
31 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
37 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
25 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
81 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
64 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
103 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
46 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
65 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
25 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
73 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 ...