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
192 views

Error configuring SQL Server as Distributor

I'm trying to configure replication on a new install (moving to SQL 2012) and I keep getting the same error even after messing with the service name, folder permissions, etc... Using the Configure ...
0
votes
0answers
36 views

Mongo Memory mapping file size issue

I am witnessing some performance issues in my Mongo Sharded cluster. I checked the serverStatus for the memory uses on my shards This is the output Shard one Primary RAM size 512 GB "mem" : { ...
1
vote
1answer
444 views

exception: hosts cannot switch between localhost and hostname

I created a replication set. I added localhost in the set in the beginning, but when I try to edit the member with the actual hostname. I get error "exception: hosts cannot switch between localhost ...
1
vote
1answer
79 views

Mysql Master-Slave replication catchup and bin_logs

I have set up MYSql Replication using 2x 128gig ram 24 core cloud servers. we have a massive live database that cannot experience down time due to the high volume of data input. I have found while ...
0
votes
0answers
60 views

Did this trigger break replication?

I added a trigger to a replicated database. DELIMITER $$ USE `database`$$ DROP TRIGGER /*!50032 IF EXISTS */ `some_ins_after`$$ CREATE /*!50017 DEFINER = 'user'@'%' */ TRIGGER ...
1
vote
1answer
48 views

Setup MongoDB replica servers with different power?

Is it a good practice to setup replicas with the same machine size (wrt. CPUs, RAM, Bandwidth, etc.) or can replicas be based on smaller machines? One usecase might be to have a small non-voting ...
0
votes
1answer
108 views

PostgreSQL replication with fsync disabled?

I need to run PostgreSQL in-memory (for performance reasons), so I intend to disable fsync, which means that no writes will be sent to the WAL. However, as part of my scheme to meet another ...
2
votes
1answer
109 views

Start mongod instance on replica set as background job

I have setup a Mongodb replica set with 1 secondary node. When i execute on secondary sudo mongod --replSet rs0 --dbpath /data --port 27017 --oplogSize 700 The primary and secondary nodes are ...
0
votes
1answer
44 views

MySQL - Migrating from Master-Slave replication to Master-Master

We currently run 2 large mysql master-slave replication trees. Each tree is built with one master, several 'middle' slaves replicating from the master, and 'end' slaves replicating from the 'middle' ...
0
votes
0answers
50 views

Replication Strategy for Multi-Office Database

I'm considering options for setting up a repository of large spatial datasets that can be used by employees across our company. We have offices scattered around the US. Our employees utilize ...
1
vote
0answers
38 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 ...
0
votes
0answers
35 views

What exactly should I backup in MongoDB when using replica sets?

I have several instances of MongoDB replica set servers with a primary and a failover machine for each replica set. The primary machine makes daily backups by creating an LVM snapshot and copying all ...
2
votes
3answers
1k views

postgreSQL 9.3 streaming replication delay

I'm running a fairly simple WAL streaming replication setup between two postgreSQL 9.3 servers that are on a private 1Gb LAN, but recently I've noticed that there is an increasing amount of ...
3
votes
1answer
145 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
0
votes
1answer
52 views

Mysql 1 way replication master lost data replication still has

Had a master mysql on (windows) improper shutdown. Many records could not be recovered and investigation found slave had records master did not have. Did not restore over master - left as was. As if ...
0
votes
0answers
21 views

MySQL replication error when an event is expired and dropped automatically

I have an event that ends at 2014-01-21 10:00:00, and a replication error was caused by drop event *** statement, coz the slave complains that the event does not exist at all. A little bit more ...
2
votes
1answer
52 views

PostgreSQL Replication delay debugging

I've got a cluster of 9.1 servers running streaming replication and using WAL-E based log shipping for when that falls behind. Generally speaking it's a pretty solid setup and does not fall behind, ...
0
votes
2answers
841 views

How to run a cold backup with Linux/tar without shutting down MySQL slave?

I run the following before tar-ing up the data directory: STOP SLAVE; FLUSH TABLES WITH READ LOCK; FLUSH LOGS; However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
1
vote
1answer
46 views

Initialize replication from multiple split backup files

We are creating a new Node within our existing P2P replication setup. To be able to create the backup and copy the files I am Backing up to 9 files - each will be about 72Gb: e.g. BACKUP DATABASE ...
0
votes
1answer
107 views

PostgreSQL SELECTs not returning correct result following recovery?

I took a copy of the current database from a live slave using pg_basebackup and recovered it to a brand new isolated computer following the instructions in the docs. Once the new database had started ...
0
votes
2answers
1k views

MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?

We have a large mysql database (about 100GB on disk) that we would like to spawn a slave for. Our typical process for creating a slave is: Create a slave server Load in a mysql dump of the master ...
1
vote
1answer
202 views

table partition in order to solve frequent deadlock issues - how would I know if it will work?

I use sql server 2005 enterprise edition and have a subscriber DB - part of a transactional replication - that is used for Business Intelligence purposes - they run reports out of it, and SSIS ...
0
votes
0answers
34 views

Mongodb replication behind a gateway

I have a replicaset with 3 servers and I need to move two if them behind a gateway. The final setup would look something like this, Server 1 (PRIMARY) ________ | S | _____________ | _ _ _ _ _ _ _ ...
1
vote
1answer
716 views

Replication Monitor Information using T-SQL

The image below shows a transaction replication problem that I am currently investigating. The image comes from the Replication Monitor. How can I get this information using T-SQL?
1
vote
1answer
74 views

Transactional Replication - Replication Order of Related Tables

** This was previously asked on Stackoverflow - I removed it from there and recreated here ** I have an issue with SQL Server Transactional Replication. My topology is as follows (and this cannot be ...
1
vote
0answers
27 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 ...
0
votes
0answers
53 views

Saving replication latency for monitoring purposes

I have SQL Server 2012 Enterprise edition, transactional replication. many servers, many DBs. This morning I come to the office and been told the latency on some databases was about 30 min behind. I ...
0
votes
1answer
117 views

Is it possble to replicate MySQL server on Azure virtual machines

I have two Windows Server 2012 R2 virtual machines on Azure. I need to replicate the database on each of the windows servers. I have followed this link but I am not getting the connection between the ...
1
vote
0answers
133 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
36 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? ...
0
votes
1answer
95 views

Mysql Percona 5.6 slave lags gradually

I have got into slave lag gradually say every minute it lags around 5secs on slave. So it started morning 10AM the Seconds_behind_master was 13. Now at 4:30 PM it has reached to 560. No variable ...
1
vote
1answer
54 views

MySQL replication slave of slave not receiving updates

I have 4 servers: A, B, C and D. A and B are in a master-master setup. C is a slave to B and D is a slave to C. Changes on A or B get to all nodes other than D. I need them to get to D Changes ...
4
votes
2answers
4k views

Which Postgresql Replication Solution to Use? (Asynchronous Multimaster / Bucardo?)

First, I'm not a DBA, so pardon me if any of this question seems "off." I've written a peer-to-peer multiplayer game (the client) which connects to one of multiple servers for match making. ...
1
vote
1answer
45 views

Mysql replication problem after export/import on already working replication

I have 2 databases in master - slave replication. I had some errors in the replication due to inserts in the slave, so I corrected it and executed: stop slave; set global sql_slave_skip_counter=2; ...
1
vote
0answers
74 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
1answer
3k views

Strange MySQL replication error 1146 (Table doesn't exist)

I'm getting a very weird MySQL replication error No. 1146 for a REPLACE INTO query on a slave host replicating all tables in all databases from a master, and I'm having a bit of a hard time ...
0
votes
0answers
45 views

Error “Slony-I creation script not avilable ; only joining possible” in SlonyI replication using pgadmin3

I am facing the above issue while Creating a base replication objects like database etc.. As a workaround i have done the changes like editing the options of Binary Paths in Pgadmin Console but no use ...
1
vote
1answer
466 views

Upgrading mysql percona server from 5.5.40 to 5.6.71

2014-12-26 05:18:20 13215 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2014-12-26 05:18:20 13215 [ERROR] Native table ...
1
vote
1answer
34 views

MySQL replicated tables for Cognos BI

the Business Intelligence guy is asking for faster machines, latest software etc. and some of his customers are complaining of query times in excess of an hour. The tool is Cognos/Insight and the DB ...
1
vote
1answer
371 views

Mysql binlogs exists, show binary logs is empty

I am working on a replication setup and have turned on bin-logs. I have moved my mysql datadir to a new location as well as the binlog path From my.cnf datadir = /vol/data/mysql ...
1
vote
1answer
32 views

SQL Server 2008 R2 - Change distributor schedule

We have configured SQL 2008 R2 replication. Distributor is configured in continuous mode, publisher is scheduler is set to execute after every six hours. Now we want to change distributor schedule ...
7
votes
1answer
5k views

Temporarily Disable Sql Replication

Due to a business need, I may need to disable transactional replication in my environment (Sql 2k -> Sql 2008). Functionally, I understand this to mean that I will need to drop subscriptions and ...
0
votes
1answer
52 views

Mysql Master-Master Replication Error

Configured Master-Master Replication But both servers slave shows the below error !! Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ...
2
votes
1answer
11k views

MySQL: InnoDB keeps crashing - how to recover?

# free -m total used free shared buffers cached Mem: 48289 35288 13000 0 347 30399 -/+ buffers/cache: 4541 43747 ...
0
votes
0answers
54 views

What should be the ideal network configuration for a Postgresql Streanming Replication and PgPool HA setup

I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover. .-----. .--------. | | ...
0
votes
1answer
537 views

Huge size on mongodb's gridfs. Should I compact?

I’m running MongoDB and grid.fs to store small files (less than 20mbs). These are part of a replica set. I currently have more than 350000 files stored. I’ve noticed that the chunks collection takes ...
0
votes
1answer
308 views

Percona XtraDB Cluster/MariaDB Galera Cluster - replication suddenly stops working, cluster thinks it is in “Synced” state

We are trying to populate an empty Galera cluster using myloader. We use the latest version of myloader from repo trunk, the command is as follows: /root/mydumper/myloader -d ...
1
vote
1answer
1k views

The process is running and is waiting for a response from the server - transactional replication

I could not yet figure it out why one of my transaction replication subscription is constantly coming out with the following annoying message: The process is running and is waiting for a response ...
1
vote
1answer
110 views

Is it possible: MySQL semisync and async replication on same master-slave pair?

I want to use master-slave MySQL (or MariaDB) replication to remote server as data protection from hardware failures. I have two goals: to keep low response time and don't lose important data. Good ...
5
votes
2answers
2k views

How could one monitor MySQL replication?

I am not a DBA, but I am interested in knowing how replication monitoring is done on MySQL severs. In order to know if a slave is in sync with its master, one would typically check ...