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
113 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
43 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
28 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
154 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
37 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
83 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
44 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
65 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
142 views

How to keep the sync active with Bucardo

I have a master-master sync setup between 3 nodes or 3 different host machines using bucardo. All works good. However when one of the database or a host is not reachable or goes down for some reason, ...
1
vote
0answers
57 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
386 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
202 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
1
vote
0answers
61 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
90 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
143 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
563 views

Replication of a remote MySQL database to local MySQL database

I'm the developer of my employers corporate private website, a HTML5/PHP/CSS powered site for company reports etc. The site, hosted on a shared hosting package, connects to a remote read-only MySQL DB ...
1
vote
0answers
235 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
103 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
364 views

Error to connect mongos when trying to create replicated sharded cluster

I'm trying to create an replicated sharded cluster in mongodb. Initially I've created two shards and there are a replica set with three members in each shard. And all the shards and replicasets run in ...
1
vote
0answers
83 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
145 views

“Replicate” Table structures with sp_addscriptexec

In our customers environment is a massive central server (running SQL Server Enterprise 2008R2) and some distributed PCs (running SQL Server Standard 2008R2). The central server has a replication for ...
1
vote
0answers
131 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
65 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
62 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). ...
1
vote
0answers
166 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
191 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
230 views

Master and slave tables with different character sets - will replication break?

We have some huge tables in our MySQL 5.6 database that have latin-1 as their character set, and want to convert them all to UTF-8 (along with converting the database's global character set). The ...
1
vote
0answers
31 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
95 views

SQL Server replication - recommendations for stability

We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
1
vote
0answers
593 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
111 views

Data replication vs parallel shard query

I'm not a DBA, and I'm wondering how a SQL Server database can scale to fit the needs of a social network. I'm not interested in NOSQL, and I understand that caching plays an important role in ...
1
vote
0answers
99 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
76 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
36 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
3k 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
28 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 ...
1
vote
0answers
126 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
1
vote
0answers
513 views

Log file growth due to replication issue

I have one primary database and it's getting replicated to another server. Both servers are SQL Server 2008 R2 with SP1. Replication was running fine till last week. We have transaction log backup ...
1
vote
0answers
202 views

How to upgrade MySQL 5.0 to 5.5 with master-master replication?

I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31. The release notes state: SLE 11 SP3 introduces the upgrade of the MySQL ...
1
vote
0answers
35 views

sp_spaceused and replication question

I have been replicating data from a table to 2 different locations and was just looking at sp_spaceused to see the size of the tables. I have noticed that the replicated tables are smaller than the ...
1
vote
0answers
157 views

Row not being deleted from the publication when it's deleted in a subscription

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
1
vote
0answers
108 views

MySQL Replication fails - commands received in wrong order?

The other day, I had this issue with one of our MySQL 5.1.60 master and 5.1.61 slave setups: Last_Error: Error 'Can't create table 'foobar.#sql-4b87_2' (errno: 150)' on query. Default database: ...
1
vote
0answers
605 views

Transactional Replication Failing Suddenly - Distributor Error

I have two databases (both SQL Server 2008 R2) taking part in transactional replication. This exists to pass data to a customer of ours, so I am troubleshooting from the Publisher side. Replication ...
1
vote
0answers
115 views

MySQL Master-Master Replication Table Row COUNT() Inconsistency

I have two MySQL servers replicating to each other in a Master-Master typology. This has been working fine for several months now. Recently I've noticed some drift in one Master. There is a row ...
1
vote
0answers
609 views

SELECT + INSERT + Query Cache = MySQL lock up

MySQL server seems to constantly lock up and stop responding on certain types of queries and eventually (after couple of minutes of not responding) give up with an error "MySQL server has gone away", ...
1
vote
0answers
530 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
1
vote
0answers
81 views

Setting up replication alerts

I 'm trying to configure alerts for replication. Currently on my test setup I run everything under user 'sa'. When I try to set up alert for agent failure I get the following error Login failed for ...
1
vote
0answers
37 views

How to use a database across two availability zones

I have servers in the USA and Japan for my website. At the moment they are both connecting to a MySQL server in the USA, which is obviously perfect for my local USA clients but quite slow for my ...
1
vote
0answers
380 views

How to switch Quiescing to Normal Mode in Oracle?

I have two instance database Oracle, they are ORCL11 and ORCL10,.... I've configured them, it looks like correct. Then, I connect to replication user admin ORCL10 conn repadmin/repadmin@orcl10 And ...
1
vote
0answers
142 views

Any solution to fix circular replication fail-over?

I've developed a point-of-sale system for our corporation, which has 25+ branches across the country. Each branch has its own MySQL POS database on a WAMP server. I want every event that occurs in ...