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

0
votes
0answers
35 views

Ways to monitor Replication messages in SQL Server 2012

I have a question for the Replication gurus here. Replication is a massive evil (but absolutely necessary) in my company. What are the various ways to monitor replication performance. I know viewing ...
2
votes
1answer
97 views

Mysterious missing transactional replication tokens

I am looking at implementing Transactional Replication subscriptions in an AlwaysOn AvailabilityGroup. I tried to use this as a guide: ...
1
vote
0answers
29 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 ...
0
votes
1answer
118 views

Native replication from Percona XtraDB Cluster to a standard stand-alone slave

I'm replicating from one node of a three-member Percona XtraDB cluster to a separate slave, using regular MySQL replication. The node is set to write binlog in ROW mode, with log_slave_updates=true ...
0
votes
1answer
211 views

How to add an article to existing replication

This is the first time I am going to add tables to replication. I have outlined the below steps to add a new table to existing replication. Please correct me if I am wrong. The table is just created ...
0
votes
0answers
55 views

Fast-Failover in Mysql

I need experts suggestion on this. I see fast-failover option is available from Mysql 5.6.5 onwards. I have a requirement asking to go for Mysql auto-failover of vip and database within Mysql itself. ...
0
votes
2answers
31 views

Transactional Replication Update process

I need to create report using ssrs. for that i create the main table contains the values from nine other tables which is the Source tables. Now the new source tables which are used for main table are ...
4
votes
2answers
74 views

Masking or substring data while replicating data

I have a table that has some unencrypted data that needs to be replicated to another server. I want to do : Mask the data with an x except the last 5 characters e.g. xxxx12345 just replicate ...
3
votes
1answer
128 views

Transactional Replication: can create 52 publication, but creating 53rd leads to problems

My apologies in advance for a long post, but I was really trying to make sure I do my due diligence before turning to the community for help, so here it goes. I am working on a proof of concept with ...
0
votes
1answer
295 views

row-based replication with slave triggers

I'm replicating a prod MySQL database to an analytics one. I need to drop several tables with sensitive data from the analytics and also redact several columns of several remaining tables, replacing ...
0
votes
1answer
447 views

SQL Server - Snapshot Agent won't start [closed]

I have successfully set up Replication. The problem is Snapshot Agent won't start. When I try to start it manually I always end up with "The agent has never been run." Publication runs under the ...
1
vote
1answer
96 views

Postgres streaming replication to a different schema on another server?

We've got a system with about a dozen Postgres 9.3 databases representing a dozen different applications. In order to do reporting across systems, we have a script that dumps each database and loads ...
0
votes
2answers
279 views

SQL Server replication service in Amazon RDS

I have a local infrastructure with multiple SQL Servers. Some of the servers have replications services to copy some data to a master database. Is it possible to have the replication services to work ...
1
vote
1answer
98 views

SSIS v/s Replication v/s logshipping

I have 2 SQL server instances, on different servers. One is Production instance and gets lots of reads and writes daily. Another one is for external applications to use a copy of few of the tables ...
1
vote
1answer
45 views

Automatic Failover without data replication

I have a need to be able to automatically failover my databases and most need data replication. However, one database does not need data replication and so, for performance reasons, we do not include ...
0
votes
2answers
41 views

mysql replication

I have a master mysql server (M1) with two replicating slaves behind it. I also have another master mysql server (M2) with it's two slave servers. The slave servers currently replicate everything from ...
0
votes
0answers
22 views

mysql safe mode running caused replication failure

I have been using database replication (Master-Master) in two of my server's running Mysql over Ubuntu 12.04 LTS server edition. I had to reset the database root user password of one of the server ...
1
vote
2answers
177 views

How much RAM should you allocate a MySQL replication slave?

Our MySQL master is allocated 24GB of RAM (innodb_buffer_pool_size = 24GB), but was curious if there was some standard amount to allocate to a replication slave? Right now the slave is just used to ...
0
votes
2answers
55 views

SQL Server replicated databases swap

I have a SQL Server 2012 database. I would like to be able to make changes to this database or to it's replication, then make the replica, the real one. The point here is to have 0 downtime on ...
-1
votes
1answer
48 views

Making data from one schema available to another schema

I need to make data that is currently in one schema available to a different user in the same Oracle database. Does this require that we replicate data from one schema to another? Or is there a ...
0
votes
1answer
49 views

How can I find out if any cluster member is offline in mongodb cluster?

I have a mongodb cluster with 1 master machine(running mongos and config service) and 3 slave machines(used as data store).But now,I find that one of 3 machines (192.168.10.11) is down because I can ...
1
vote
0answers
24 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
2answers
1k views

MySQL:How to correct a corrupted MySQL binary log on Master server?

We are using MySQL DB with one master and one slave. We are using this setup for months now. The slave sync stopped today and the error we got was: Last_IO_Errno: 1236 Last_IO_Error: Got ...
3
votes
1answer
72 views

Log Shipping in lieu of replication

I have two SQL Server 2008 R2 systems that, due to network restrictions, cannot use SQL Server replication. However, data needs to be shared between these systems. It may be possible to send a file ...
1
vote
0answers
58 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 ...
0
votes
0answers
97 views

Replication Monitor Missing Subscriptions in Watch List

In Replication Monitor, for one of our publications (transactional replication), none of the subscriptions are showing up in the Subscription Watch List. This is new behavior that just started ...
0
votes
1answer
682 views

Master - Master replication Duplicate entry

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days... My setup is as follow: One server in The ...
2
votes
1answer
78 views

How to know if logreader agent already exists?

I'm creating a script to recreate a database for test purposes, and the database has some publications. In order to create or not the logreader agent I need to know if the current database already ...
1
vote
1answer
25 views

Permission error replica set

I'm having some trouble with intentionally removing a secondary from a replica set. I'm trying to simulate unexpected shutdown. My replica set consists of one primary and 2 secondaries. When I shut ...
9
votes
3answers
2k views

Snapshot Replication Retention

I've got Snapshot replication set up on my SQL Server 2008 production server, and I just noticed that there are snapshots ranging back to a year ago in the snapshot folder. How can I change the ...
6
votes
1answer
147 views

Can we use old primary to sync with standby after failover in PostgreSQL?

If my standby (postgres) is behind by few seconds before failover. What is the easiest way to sync back my old primary after failover in PostgreSQL. In Oracle we have the option of Reinstating a ...
0
votes
1answer
90 views

Mysql replication dump without down time? empty sql file

I try to create dump as replication master data and use followed command to create dump, but sql file only contains paramters and there is no data and structure. The command is : mysqldump ...
4
votes
1answer
2k views

PostgreSQL streaming replication broken: invalid magic number, out-of-sequence timeline ID

For some reason, my PostgreSQL slave no longer streaming-replicates changes on the master. It was working before, for a while, but I recently noticed that the slave's database contents is old, and ...
0
votes
1answer
302 views

MySQl master - master replication not working [closed]

I'm trying to setup a master - master setup and I see both masters connect to each other in workbench: server 1: -- Thread Id: 112 -- User: slave -- Host: 207.244.73.38:55164 -- DB: None -- ...
2
votes
0answers
61 views

SQL Server 2012 Replication

Please help me out with a problem I am facing. I have a table T. I altered the table to alter the column C from varchar (10) to varchar (100). Now, there is a view V that is schema bound and selects ...
1
vote
2answers
518 views

Replication fails because of a non-existent foreign key

I have been trying to get a previously working replication to start working. I have tried many settings, but I can't seem to make it work. Here is the scenario. I dropped all the FK constraints ...
1
vote
1answer
38 views

Moving large database to another drive, how to measure performance before, and setup some type of replication for fast fail back?

Sorry if this is kind of more than question at a time, but here goes. Running SQL Server 2008 on windows server 2008 as well. We have a large database just over 200gb right now (it holds images of ...
0
votes
3answers
179 views

Alternative of replication in internet disconnection period of time [closed]

I'm looking for an alternative of merge replication that work without internet connection, something like red gate sql data compare but not in uniq direction.
1
vote
1answer
45 views

Changes to main Database during Transactional Replication

Can you please advise how can I keep slave database up to date while it's in transactional replication with master. I mean what If I change indexes, columns, tables or sthm else in master dabase? ...
1
vote
1answer
76 views

How do Identity Columns get Replicated?

During Transactional Replication, we have data going from Server A to Server B. Say we were to reseed an Identity Column on a Table on Server A (for whatever reason), how would this affect the data ...
0
votes
2answers
184 views

What locking can I expect with DBCC CHECKIDENT(RESEED)

I'm working on a project that has hit a bit of a snag: I'm replacing some replication with a home built system so that if replication goes down we don't blow our SLAs with our customers and shell out ...
0
votes
1answer
126 views

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live

We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours. And I am ...
1
vote
2answers
80 views

Postgres: What happens if your slave DB went down temporarily?

I have a master DB that is replicated to a slave DB through binary replication. What happens if this slave DB were to go offline for a period of time? Would it eventually catch up with the master as ...
4
votes
1answer
487 views

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then ...
0
votes
1answer
84 views

Max allowed packet changed still replication not starting

Suddenly I notice my replication stopped and first I got some primary key duplication error when I checked using the show slave status\G. Then I remove those lines and restarted and ending up now with ...
1
vote
1answer
123 views

Copy few rows from one database to another

I have two PostgreSQL databases on two different machines and the network connection is slow. I would like to copy few selected rows from the first instance to the second. Unfortunately, the full dump ...
5
votes
3answers
547 views

Using SQL Snapshot Replication to refresh TEST databases from PRODUCTION. Why not?

What are the drawbacks and downsides? We want to schedule automatic nightly refreshes of 20 databases, approximately 1GB each, from the PRODUCTION server to the TEST server. We're setting up SQL ...
0
votes
1answer
64 views

SQL Server 2000 Replication, Performance, and Query Priorities

I'm a developer and wanting to confirm the following: Does anyone here have experience with SQL Server Replication (transactional) on 2000? We are trying to convince the DBAs to allow this in a ...
0
votes
0answers
102 views

Slave fail first due to duplicate primary key then corruption error

I have a mysql db running the slave very well for few months. Suddenly today I notice it stopped since 18Nov. I check the status it was showing me the primary key duplication error. SO i stop slave ...
1
vote
1answer
296 views

When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?

In my particular case, I'm using Heroku Postgres (repackaged Amazon EC2 instances running PostgreSQL), but platform-agnostic answers are also good! Heroku's instructions describe the process for ...