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
38 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
147 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
129 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
362 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. I have a MySQL 5.6 server (community edition) on another Linux server which is slave. I have installed various ...
1
vote
0answers
41 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
245 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
177 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
184 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: job....
1
vote
0answers
172 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
54 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
70 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
196 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
84 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
83 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
40 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
140 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
503 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
140 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
79 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 Secondary....
1
vote
0answers
38 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
32 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
236 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
50 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
38 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
313 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
39 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
122 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 ...
1
vote
0answers
56 views

Replicaiton and synchronizing to a central database

My client will have many outlets and each outlet will have a local db. But there is only one outlet which will have a central db. Ideally, my client wants to put everything on a cloud but due to the ...
1
vote
0answers
115 views

Postgresql service run failure

Trying to setup replication through the wal shipping using Postgresql 9.3 x64. Used this instruction from youtube. The problem is - the slave postgresql service won't run. This is what in logs ...
1
vote
0answers
91 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
1
vote
0answers
511 views

“ORA-00936: missing expression” setting up Oracle Publisher in SQL Server

I'm trying to set up an Oracle publisher in SQL Server so I can perform replication. I've gotten connected to Oracle, the drivers work great (I have other linked servers), I can select an article I ...
1
vote
0answers
82 views

pt-online-schema-change with circular replication

So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
1
vote
0answers
173 views

Replicate/Sync Production database with Development database (no Master/Slave)

I currently use ClearDB MySQL DaaS for my production database, and a local MySQL database on my dev server for development. I need to have the production database replicated/copied/synced to the dev ...
1
vote
0answers
195 views

Replica failed with error mongo db

I am running mongo sharded cluster with two replica set as shards. One set is working fine but replica secondary on other replica set is not working. When ever i restart it it gives me this error and ...
1
vote
0answers
376 views

sqlcmd returning NUL instead of NULL for tinyint column

sqlcmd -E -d MyDatabase -Q "sp_helpsubscription" -s "," -o file.csv -W -u Column 23 which is suppose to be a tinyint (subscriber_type) is output as NUL instead of NULL when the value is NULL. I ...
1
vote
0answers
126 views

mongodb replicaset

I am adding a new member in ReplicaSet and it starts initial sync bur after certain point sync break and start resync again.this process continue and never complete its initial sync.so please resolve ...
1
vote
0answers
119 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
1
vote
0answers
208 views

MySQL replication of single DB to same server

I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source). I have dozens of databases but one of them is being hit quite hard with large selects which locks out other updates which ...
1
vote
0answers
381 views

High Availability in PostgreSQL with automated failover

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...
1
vote
0answers
92 views

replication error involving ignore-db

I have simple master/slave replication set up between two servers. The master has several DB's I wish not to replicate at this time, in fact there is only DB I am trying to replicate. I have several ...
1
vote
0answers
95 views

Sybase Replication rs_subcmp can ignore length?

I want to use rs_subcmp utility to sync one table. I've created a config file but I got the following error: Length mismatch for column #9 between the primary (50) and the replicate (100). [c/subcmp....
1
vote
0answers
213 views

PostgreSQL 9.3 slaves don't recognize hstore as a type

I am using the postgres built in replication with two slave nodes and a single master. On the master node (as well as the slaves) the hstore extension is installed. But whenever a query using hstore ...
1
vote
0answers
255 views

Data Corruption on base backups created with wal-e?

I have streaming replication setup on Postgresql 9.1 with two machines on AWS EC2. The master has a cron job that does a daily base backup using the wal-e tool and uploading it to Amazon's S3 storage. ...
1
vote
0answers
36 views

The @article parameter value must be 'all' for immediate_sync publications

I have a publication of 4 tables and many subscribers (transactional push replication), most of them being interested by one of those 4 tables. Everything is working fine as long as I create the ...
1
vote
0answers
819 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
1
vote
0answers
153 views

Replication topology advice - central subscriber

I'm seeking guidance and advice about how to set up replication in MSSQL to deal with the following criteria. We have a central server hosted at a data center - this is where our web app is located. ...
1
vote
0answers
97 views

Mysql Replication Master/Slave and Master/Master

Looking for some insight and opinions from some DBAs, as I've been tasked to look into using Master/Master replication for a single table in a database. We currently run mysql replication using a ...
1
vote
0answers
42 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
1
vote
0answers
4k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
1
vote
0answers
34 views

SQL Replication - Data not showing

Good Morning, I have recently setup SQL replication and changed some data in one of the tables on the primary table. This data however has not been replicated to the subscription server. On the ...