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

how to force MySQL unsafe replication warnings to throw an error

I understand that MySQL WARNING statements, with respect to replication unsafe statements, are not 100% valid. That is, if you know what you are doing, if you understand the schema, there are indeed ...
1
vote
0answers
15 views

Minimizing downtime during MariaDB Replication Setup

I have the task of setting up MariaDB (10.0) replication from a master running in a datacenter to a slave running out in an AWS VPC. Reading up on the instructions on Setting Up Replication - MariaDB ...
1
vote
0answers
48 views

MongoDB replicaSet keep 'syncing to' and only can be connect with shell

Hi I am new with MongoDB 2.6 Replica Set I have three DB service in Docker and DB work in Replica Set It works great I can connect to DB Read,Write in C#,MongoVUE but I didn't know why my db will ...
1
vote
0answers
19 views

PostgreSQL Multi Master Single Slave Replication

I have multiple transaction PostgresQL 9.4 databases and a single publication read-only database. Is there any replication mechanism (asynchronous) to push every updated transaction from every ...
1
vote
0answers
37 views

SQL Server 2012 AG replication issues

We just went away from SQL Serer clusters in SQL Server 2008 to SQL Server 2012 with AG – have five servers with replicas in a secondary datacenter and syncing over a dedicated eline/LAN layer 2 ...
1
vote
0answers
26 views

Is log shipping good for periodic synchronization?

I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
1
vote
0answers
23 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
1
vote
0answers
14 views

Classic vs. GTID replication MySQL 5.6 - how to identity which one used from errors?

Is that true? In classic replication (SQL_SLAVE_SKIP_COUNTER=1) you never see UUIDs in logs and show slave status like 3e11fa47-71ca-11e1-9e33-c80aa9429562:1-5? When you see an UUID, there is GTID ...
1
vote
0answers
23 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
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
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
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 ...
1
vote
0answers
12 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 ...
1
vote
0answers
39 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
39 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 ...
1
vote
0answers
35 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
0answers
38 views

Restoring MySQL Master-Master Replication

I am trying to restore Master-Master MySQL 5.6 servers. The replication failed between DB1=>DB2 and so DB2 went out of sync. GTIDs are enabled. I have done an export and import from DB1 to DB2 and ...
1
vote
0answers
56 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
1
vote
0answers
35 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
1
vote
0answers
35 views

Effect of upgrading windows server 2012 data center

I have a production windows server 2012 data center server where IIS and SQL server was installed and replication was configured in SQL Server. It is infected with a malware. After cleaning it with an ...
1
vote
0answers
78 views

Merge Replication: Error “The insert failed. It conflicted with an identity range check constraint”

For one of our SQL server 2005 enterprise, configured with merge replication, we suddenly start seeing the below error message: The insert failed. It conflicted with an identity range check ...
1
vote
0answers
88 views

SQL Server using Linked Server to Oracle - table definition not updating with refresh

Is there some trick for SQL Server Linked Server to update the ODBC connection to a changed table? SQL Server provides Oracle with a view. Oracle runs a materialized query to basically make a table ...
1
vote
0answers
195 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

1. I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. 2. I have a MySQL 5.6 server (community edition ) on another Linux server which is ...
1
vote
0answers
40 views

Transactional replication taking hours to replicate

I have a bunch of tables replicated from my_publisher to my_subscriber via my_distributor. Some of these tables, not all of them, when updated on my_publisher, take a couple of hours to be updated on ...
1
vote
0answers
119 views

mysql master/master replication problem

I am having a problem with one of my MySQL servers running CentOS 7. I have it almost setup with a master master replication status. But I keep getting this: MariaDB [(none)]> show slave status\G ...
1
vote
0answers
129 views

MySQL Master-Master Crash-Safe Replication: Slow UPDATE times

Environment 2 MySQL version 5.6.26 Dedicated MySQL Servers connected on a LAN. Servers Have 16 Cores with 32 GB RAM each and are really fast. Master-Master Crash Safe Replication is setup on both ...
1
vote
0answers
89 views

SymmetricDS scheduled sync

I am trying to configure SymmetricDS to run a scheduled replication from one postgres database to another. I've seen people suggesting doing that by setting these fields in node config: ...
1
vote
0answers
161 views

MariaDB multi-master replication (star topology) - Bizarre out-of-sync behavior

This may look familiar, I've been learning about this stuff for a few days - but this is a new question. I have a setup like this: Every node is a master, and I have them all replicating to each ...
1
vote
0answers
122 views

Master/Slave and Master/Master replication - MySQL

What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication? Also, what are the issues ...
1
vote
0answers
27 views

MongoDB user account required for arbiter?

I have a test environment with two mongo v2.6.5 instances (#1, #2) and an arbiter instance in a replica set. I have a a common key file configured for all three instances. I have created an admin ...
1
vote
0answers
62 views

DatabaseRestart

I have strange problem, we are using circulation replication, between 2 different network with 5.6.25 and 5.6.22 version of MySQL and RAM is 64GB with 45GB innodb_buffer_pool Master Server is running ...
1
vote
0answers
74 views

Setting up mysql replication (Master->Slave one direction)

I am struggling with the setup of a one way replication for a single mysql table. What I have done so far: Master: Added this into my my.cnf: server-id=5668439 log-bin=mysql-bin ...
1
vote
0answers
109 views

Unicode character replication MSSQL to MYSQL in Symmetric DS

I'm doing replication from MSSQL to MYSQL using symmetricds and it is working fine. Now , the problem is: In the SQL Server table , I have a column defined as NVARCHAR(20) which accepts unicode ...
1
vote
0answers
57 views

Keep selected tables synchronized across MySQL databases

I've a need that requires me to keep a number of tables from a database (db1) synchronized with another database (db2). db1 & db2 have different structures and a set of tables and their data from ...
1
vote
0answers
57 views

Can PostgreSQL with synchronous streaming replication get behind on the WAL logs?

I have 2 Postgres 9.4 servers running on 2 identical VMs that I am using to learn how to setup replication before it gets used in production. Hot standby isn't required but it would be preferred. I ...
1
vote
0answers
34 views

Replication Data Issue

After configuring replication all the data from tables has replicated from publisher to subscriber. Now my requirement is whenever I insert new record in publisher only that record should replicate ...
1
vote
0answers
106 views

BDR Replication issue

I am trying to setup 2-node BDR replication and i am getting the following error while running bdr_init_copy. /usr/pgsql-9.4/bin/bdr_init_copy -d "host=10.10.145.111 dbname=apimgtdb port=5432" ...
1
vote
0answers
328 views

Replication slowness: massive MSrepl_commands table?

Background: I have a SQL Server 2005 transactional replication setup that pushes normal traffic fine, but occasional larger processing batches have been a problem. Obviously the changes take longer ...
1
vote
0answers
90 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 ...
1
vote
0answers
52 views

Replica Set In Mongo Are All Primary

So I saw a thread on here for when all the replica sets are Primary. The fix was to do rs.Add(hostportStr) on the master server before you do rs.initiate() on the server you want to become a ...
1
vote
0answers
34 views

Error on slave2 after promoting slave1 to master in cascaded streaming replication

I've a setup like MASTER -> SLAVE1 -> SLAVE2. MASTER and SLAVE2 are running on different ports on single server. SLAVE1 in on another server. For testing purpose I've powered off my first server ...
1
vote
0answers
91 views

MySQL replication error: Table doesn't exist

I just run a MySQL database master-slave replication using these instructions. The process seemed to be ok, but when I run some queries on the slave server I get this message on 3 of my tables. ...
1
vote
0answers
335 views

FATAL: terminating walreceiver due to timeout

1/ DESCRIPTION: Machine 1 (slave): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Local) Machine 2 (master): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Cloud) Machine 1 (slave) and machine ...
1
vote
0answers
26 views

Does an “update-update” conflict get created from the same node in P2P replication?

I have been told that an update-update conflict is being created in a production environment, which is set up using p2p replication, because of concurrent update by stored procedures. The msdn ...
1
vote
0answers
191 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
1
vote
0answers
46 views

choosing between the slaves on streaming replication

We are building a new streaming replication setup on postgres 9.3 integrated with pgpool for load balancing and failover, and repmgr for replication business. We have seperate daemons running on all ...
1
vote
0answers
35 views

Transfer Data between 2 organizational domain

Please consider the following scenario: Company A manages the IT Infrastructure of Company B. Company A is located in US and has SQL Server 2014 Enterprise Edition. Company B is located in UK and has ...
1
vote
0answers
222 views

SQL Server transaction replication agent error

We are running transaction replication on SQL Server 2008 R2 SP3. Distribution agents are reporting : "Agent is retrying after an error. 3 retries attempted" every 10 minutes. Tried changing ...
1
vote
0answers
38 views

Replication / Bulk Update between Servers

I'm looking to update several tables between two servers daily to have a replica of the data available. My question is, what is the least resource heavy and most effective method to implement this? ...
1
vote
0answers
105 views

Why database replication fails when database mirroring is broken?

I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008. Here is current environment: (don't ask me why it was done this way or to change it) Server A: SQL ...