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

3
votes
2answers
36 views

Is my Publisher database my actual source database or is it a new database?

I am setting up transactional replication for the first time and am working through my backup policies I need to set. Is my Publisher database my actual source database? Or is it a new database that ...
0
votes
1answer
22 views

MySQL how to change a slave to a new master?

I have a MySQL active master (lets call it Alpha), a passive master (called Beta), and a slave (called Gamma). Topology before change: I am going to switch the active master and the passive ...
0
votes
1answer
35 views

Is the MySQL replica's data consistent if the Master was switched to binlog_format = MIXED but the Slave's relay logs were rotated sometime later?

The accepted answer to this question is very helpful but it's not clear to me if one should be concerned about the replication that occurred from the time the Master's binlog_format was changed to ...
2
votes
1answer
97 views

Postgres: Purpose of archiving in master?

I am reading tutorials on how to setup streaming replication in Postgres from master to slave. Some tutorials recommend setting up archiving in the master (and restoring in slave) . In the master, ...
4
votes
3answers
920 views

Are there any in-memory NoSQL databases?

Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage? I'm looking at ...
3
votes
2answers
889 views

Running pg_dump on a hot standby server?

Disclaimer: I admittedly haven't tried this yet, but I'm not sure I would know if it wasn't working correctly, so I wanted to ask. I would like to run a nightly backup job (via pg_dumpall) from a hot ...
1
vote
1answer
51 views

automatic transactional replication failover to noce2 with AG failover

I am working on to set up high availability group like SQL01,SQL02,SQL03(DR) and SQLRPT01 as the reporting server which has our reporting DB. * From SQL01 to RPT01, I am running transnational ...
2
votes
1answer
50 views

How can I compare the server impact of transaction replication

We are developing a system that must extract data from an existing SQL Server 2008 R2 cluster. One of our design goals is to limit the performance impact on that cluster as much as is practical. ...
1
vote
0answers
42 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 ...
2
votes
1answer
861 views

Update MySQL slave when changing the hostname/IP of master

I have one master and one slave replicating great, but the master is about to have both it's hostname and IP changed. In master.info on the slave server I see the current hostname for the master, if I ...
1
vote
0answers
37 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. ...
2
votes
1answer
42 views

SQL Server Merge Replication Dummy Update issue

We have SQL Server 2005 SP4, using merge replication. We started getting this error when the subscribers try to replicate (not all of them but most): The process could not deliver dummy update ...
2
votes
3answers
80 views

Replicating tables for reporting purpose

We have 5 tables in a database on Server A that we would like to replicate to Server B for reporting purposes. We would like to create different indexes on the destination copy so we can get better ...
0
votes
0answers
20 views

How to efficiently synchronize MySQL slave with secondary mater?

I have a database setup with chained replication: +-----------+ +-----------------+ +----------+ | A: master | <-- | B: slave/master | <-- | C: slave | +-----------+ ...
0
votes
1answer
45 views

Excluding the standard MySQL databases from replication

I have a prod database, say appdb, and I only care about the data in that db. Is it safe to declare replicate-ignore-db for each of mysql,information_schema,performance_schema,test, as some tutorials ...
1
vote
0answers
31 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 ...
0
votes
1answer
19 views

How to restart mysql slave node?

i have 8 slave servers and i need to restart one of them but in my.cnf file master-host, master-user etc. variables dont exists. So if i restart server as indicated here replication will start again?
0
votes
0answers
30 views

“Oneway” Replication from Oracle DB to TimesTen

currently I'm really stuck into a problem and I not able to finde a nice way to realize that. I need a suggestion to replicate from oracle db (some tables) to a TimesTen. A connection is only ...
0
votes
0answers
34 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
91 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
27 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
41 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
95 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
47 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
29 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
59 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
99 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
118 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
108 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 ...
0
votes
1answer
40 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
95 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
74 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
39 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
37 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
12 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
86 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
1answer
646 views

MySQL Slaves lag behind master

I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
2answers
49 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
41 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
28 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
21 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
361 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
59 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
50 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
50 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
213 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
48 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
19 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
1k 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 ...
5
votes
1answer
93 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 ...