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
2answers
181 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
63 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 ...
3
votes
1answer
78 views

How to upgrade MySQL (5.5) production DB to 5.6 with minimal downtime

Our existing Database size around 200GB. We want to use consistent, parallel backups methods. For testing, I migrated my Development DB from 5.5 to 5.6 by running mysqldump with option ...
0
votes
0answers
101 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 ...
0
votes
1answer
145 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 ...
6
votes
1answer
144 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
64 views

Is it any good for performance to have master and slave on the same server

There are similar questions on this site, but they mostly cover server failure and data backup aspects. I'm concerned only as far as query performance. If master and slave share the same resources, ...
-1
votes
1answer
78 views

MySQL Replication

i try to search around the internet to find out what's a "Master -> Slave" Replication of MySQL want to do? Can sombardey maby explain it for me? what i can read is what happen are when i have a ...
0
votes
0answers
2k views

MySQL relay log corrupted, how do I fix it? Tried but failed

A MySQL v5.1.61 relay got corrupted when the machine suddenly shut down. I tried to fix it but it didn't work. — How do I fix it? Did I do something wrong? As far as I've read, corrupted MySQL relay ...
0
votes
1answer
125 views

Backing up MySQL w/MyISAM on Amazon RDS

So, for various good reasons, we're maintaining a mySQL database using a MyISAM engine on Amazon RDS. I've just taken over this application, and I'm concerned we're not getting good backups, since ...
0
votes
1answer
170 views

MySQL Master Slave Replication and backup

I would like to implement the following backup solution as highlgihted on the mysql site: To use replication as a backup solution, replicate data from the master to a slave, and then back up the ...
2
votes
1answer
528 views

Cannot get my slave - replication server to start

My replication server will not start. I have followed the instructions here: http://opensourcedbms.com/dbms/setup-replication-with-postgres-9-2-on-centos-6redhat-el6fedora/ As well as several other ...
2
votes
0answers
70 views

Replication slave re-reading WAL on restart

I have a standard streaming replication setup going with PostgreSQL 9.1. It works fine. However, if I stop the slave cleanly (to move it or perform other maintenance) and restart it a short time ...
1
vote
0answers
128 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
1answer
117 views

Snapshotting Database Tables

I have a reporting database (in SQL Server) that takes nightly snapshots of the production data (Oracle) for users to query against for the next day, but now the requirement is getting to be that they ...
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 ...
0
votes
1answer
203 views

How can I keep two databases on different sites in sync?

I'm working on a web application that exists at two sites. Each system is hosted on it's own LAMP stack, with access restricted to specific users on the network. When content is updated via user ...
0
votes
1answer
41 views

CRC checkup in MongoDB

I am newbie to MongoDB and currently working on a project. I read tutorials about mongoDB but unable to find any information about Cyclic Redundancy Check (CRC) check in mongoDB. My question is that ...
0
votes
0answers
31 views

log-slave-updates doesn't write in relay bin with replication-ignore-table option

Here my MySQL circular replication : db1 -----> db2 -------> db3 ignore table db2.t1 db1, 2 and 3 are the same database. db2 ignore t1 table. (replication-ignore-table) Every server has ...
0
votes
1answer
110 views

How to remove orphaned Log Reader Agents from Replication Monitor?

How do I remove the two Log Reader Agents with errors from the Replication Monitor? As you can see, the job does not exist (Error message produced by right click > Properties on errored Log Agent ...
1
vote
1answer
88 views

.NET error when trying to create snapshot for transactional Replication

I encountered a bizarre prob today while creating a transactional publication on a SQL 2012 server running on Windows Server 2008R2. I had just had some success creating and initializing some Merge ...
0
votes
0answers
37 views

Create extra databases on a MySQL slave (RDS)

Is there any trouble I can get into with switching off read-only on an MySQL slave (on Amazon RDS), and adding a few extra databases for unrelated use? While we need a read replica for ...
2
votes
3answers
974 views

Is replication possible on two different domains?

I am implementing a database replication between different geograhical locations where each one is on a different domain. After going through all the process, when I start the agent it runs and stops. ...
0
votes
1answer
201 views

mariadb-galera-server with Aria?

With Galera now somewhat supporting MyISAM replication, does that also mean that it will replicate Aria databases with storage engine (which is more or less feature complete to MyISAM, and a drop in ...
1
vote
1answer
203 views

Approaches for Real time copy of database on same SQL Server instance

I have a draft of requirements that look like this: Production database should be copied in real-time to "Pre-prod" database The Pre-prod database should be available to read and update It should be ...
0
votes
1answer
33 views

Replicating MongoDB server on windows

I have a main server(windows-27017) and on that i replicated my data on different port (37017) but same server. Now i am trying to add my notebook as a replicate server on mongodb and installed ...
0
votes
1answer
1k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
4
votes
1answer
198 views

How do I monitor PostgreSQL WAL shipping if I'm not using streaming replication?

We have a fairly simple setup to replicate from our on-premise master PostgreSQL database to our presentation tier in AWS. We're using WAL shipping using the archive_command setting. Basically the ...
0
votes
1answer
64 views

re-enabling a table for mysql replication

We were able to setup mysql master-slave replication with the following version on both master/slave: mysqld Ver 5.5.28-29.1-log for Linux on x86_64 (Percona Server (GPL), Release 29.1) One day, ...
1
vote
1answer
63 views

Can I change the default settings for SQL Server Replication

Is there a way to change the default setting in SQL Server replication? Example when I create an new article I want to have the create Non-Cluster set to true all the time.
0
votes
0answers
85 views

MySQL Slave with erratic Read_Master_Log_Pos during binlog rotation?

I have two mysql servers setup with default my.cnf config apart from server-id's and enabling binlogs on masters. Replication is setup and working and i have a simple bash scrip on master feeding in ...
0
votes
1answer
205 views

Replication - Binary log parsing(Tableid generation, ON DELETE CASCADE handling, Changed columns for update event)

I am using MySQL 5.5 with InnoDB engine. I have set binlog format as row-based replication. I have some doubts regarding replication: 1) How is the tableID generated? Is it stored somewhere? 2) ...
1
vote
2answers
78 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 ...
0
votes
1answer
144 views

SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent

I'm trying to create replication subscriptions to and SQL Server 2008 R2 via a script. There are 3 subscribers so this script creates the subscriptions by calling sp_addmergesubscription and then ...
0
votes
2answers
108 views

How to copy a table during replication in MySQL?

I have two MySQL servers; db1 and db2. db1 is production and db2 is for reporting. I have setup replication where db1 is master and db2 is slave. This current setup works fine. I was given a new ...
0
votes
5answers
1k views

Mirroring vs. Log Shipping

The software company I work for is planning to migrating our infrastructure into the cloud. Our current focus is to find the best database replication method. Current Servers: SQL Server 2008 SE - ...
1
vote
0answers
125 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 ...
0
votes
1answer
59 views

Replication with two side update but one side insert

I have server A and server B. I want server A can see data and changes on specific article on server B . But server B just see its own data . And also I want to update server B's data on both servers ...
0
votes
0answers
54 views

Merge replication web sync pull error

I have some problems with web synchronization for the Merge Replication. I repeated every step described here but I have always the same error: Security Error ....Unable to connect to the URL ...
0
votes
0answers
52 views

PostgreSQL Failover Issue

I have 3 PostgreSQL (9.1) server's, 1 master and 2 slave. I have configured streaming replication between them. Now when i shutdown the primary server and convert one of the slave to act as primary ( ...
0
votes
1answer
356 views

SQL Server Transactional Replication over Internet

I have 2 instances with SQL Server 2008R2 and i would like to build Transactional replication between those server, one is in the Local Network (Local_Instance) and the second server is over Internet ...
0
votes
1answer
64 views

Multi-master and multi slave

I have been having some issues creating a redundant multi master setup. Here's the proposed layout: The problem I'm having is when something is written to master1 it replicates to slave1 and ...
1
vote
1answer
106 views

MySQL: records, inserted via phpMyAdmin, do not replicate

As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or ...
1
vote
1answer
286 views

SQL Server Data Transactional Replication of huge data, locking down table

We have setup data transactional replication from Server-A(SQL Server 2008 R2) to Server-B(SQL Server 2008 R2). We have a SQL Job scheduled to run everyday on Server-A, which executes single UPDATE ...
0
votes
0answers
28 views

Accessing Database from Slave server

I have an application running in one server eg: My Server's Ip is 192.168.10.10, and I have the MySQL database server in the same machine. The application connects database server as localhost. ...
3
votes
3answers
286 views

Initializing Transactional Replication From two Different Database Backup

I have two different large Database (200GB for each) which I want to replicate their data to a central database (3rd DB). I followed this link and it was very useful for a single database. But my ...
2
votes
1answer
191 views

Double queue reader or is it still busy?

I came across this line in the verbose log on replication QueueReader Agent job startup. The Queue Reader Agent has encountered the error 'Another queuereader agent for the subscription or ...
2
votes
2answers
1k views

Snapshot for transactional replication taking too long for large database

I want to establish a transaction replication of a large database (200GB). But when I create the publisher and the snapshot agent starts, it takes very very long time and it sticks on the following ...
0
votes
1answer
180 views

How can I verify that MySQL's slave_compressed_protocol is working

I've set slave_compressed_protocol=1 on both my master and slave. Using SHOW VARIABLES, I can see that it's set. How can I check that it's actually working?
0
votes
1answer
413 views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...