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
0
votes
1answer
66 views
MySQL slave seems confused as to just how far out of date it is
I have a slave that claims, in SHOW SLAVE STATUS, to be zero seconds behind the master.
However, it also says it's on Master_Log_File binlog.009636, which is 46.9 gig behind where the master is. I ...
0
votes
2answers
691 views
Some queries slower in MySQL 5.5 than 5.0?
We have an exceptionally inefficient process (1.3 million selects, 232k updates) that I'm now recoding to be 1 select and 50 updates. In the meantime, though, today's process ran.
We recently updated ...
1
vote
2answers
284 views
How would I run DELETE queries on a Master Without Executing Same DELETEs on a Slave?
As it is obvious in the title of the question, I am looking for any solutions, even an alternative, to how I am trying to solve it.
I am open to ideas, and I would appreciate any advice and insight ...
4
votes
2answers
3k views
Easy Postgresql master/slave replication with automatic failover on Linux?
I need a reliable SQL DB for our application and have been looking at Postgresql's streaming replication support. It seems that it's not hard to setup master/slave replication and you can use the ...
1
vote
1answer
113 views
PostgreSQL Replication for small, low-usage database
I have PostgreSQL 8.4 installed on a headless Ubuntu 10.04 server. Sometimes the server is not available. I would like to continue working on the database, so I thought of installing PostgreSQL onto ...
1
vote
1answer
384 views
Syncing two (or more) PostgreSQL 9.1 clusters
This question assumes the use of PostgreSQL 9.1.
Say I have two PostgreSQL database clusters. Each cluster contains three PostgreSQL servers. A master, a slave synced via synchronous replication and ...
1
vote
1answer
150 views
`SELECT FOR UPDATE` in master-master mysql setup
I am benchmarking a database schema with a dozen workers processes and was wondering what a SELECT FOR UPDATE does in a master-master configuration.
For the moment it seems to work, but I am either ...
0
votes
0answers
280 views
MySQL Multi-Master Replication with federated tables failing
Overview
We are trying to implement multi-master replication with MySQL using Federated tables (see explanation below). We have one central Linux server with a LAMP stack. We currently have two ...
1
vote
1answer
62 views
MySQL Replication - replication issues; procedures registered on master not giving same result on slave in MySQL 5.5.20
I am not able to replicate procedures registered in the Master to the Slave in MySQL 5.5.20
The Procedure is registered on the Master and can be seen on Slave. However, results fetched using the same ...
3
votes
2answers
247 views
MongoDB: Replica Set - master vs. slave
We think about moving from a master-slaves to mongodb with replica-set.
Now I wonder if mongodb replicas are also set up like read-only slaves or if each mongos is able to write and sync the others ...
4
votes
2answers
329 views
Massive peer-to-peer replication topology?
We have a client that's geographically distributed in remote communities, with somewhat unreliable network/internet connectivity between each of the physical locations. There is a single central ...
3
votes
1answer
297 views
Best Approach for Mirroring Data from SQL Server to MySQL
I need help in regards to replicating data from a third party point-of-sale system with a SQL Server backend to a MySQL DB.
Specifically, can anyone suggest a best way to mirror data from SQL ...
1
vote
0answers
47 views
Replication Fails due to Warning
I'm getting the following warning when executing usp_ReplicationMonitor within a job:
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
A ...
2
votes
1answer
219 views
Configured MySQL replication but its not working
I have configured MySQL master and slave replication setup on 5.5.x.
But for some reason data is not getting replicated properly. What might be the reason?
At Master:
/etc/my.cnf
[mysqld]
...
0
votes
1answer
329 views
SQL Server Replication Stored Procedures sp_MSdel_db, sp_MSupd_db, sp_MSins_db
I have 2 production servers and 2 development servers. All SQL Server 2008 r2.
In production, I had one of our DBAs create a replication publisher and distributor on ProdServer1 and Subscriber on ...
2
votes
2answers
434 views
Streaming Replication in PostgreSQL
I'm trying to set up two PostgreSQL servers on one machine and perform a streaming replication. I have succeeded once, but when i've tried again following exactly the same steps it doesn't work.. ...
3
votes
4answers
429 views
What options exist for copying data between servers on a regular basis?
My apologies if this has already been answered. I've searched SO and of course here on DBA, and am surprised to find no close matches. Specifically, I'm looking for a solution which survives schema ...
1
vote
1answer
62 views
SQL 2005 Replication Create/Delete Tables, Views, and Procs
I have replication setup on a couple SQL2005 servers.
According to http://msdn.microsoft.com/en-us/library/ms151870(v=sql.105).aspx replication works when changing an item.
How do I have ...
1
vote
1answer
250 views
replication warning: transactional replication latency alert not working
I have set up a predefined replication alert (as outlined here) in SQL Server 2008 and the alert for Replication Warning: Transactional replication latency does not appear to work. This is triggered ...
1
vote
1answer
125 views
SQL 2005 Replication - How do I get the DA Profile MaxBCP option to work with a Transactional Publication?
I have two publications on a database. One is a transactional publication, the other is a snapshot publication. We have a stand-alone Distributor (separate from the publisher) and both publications ...
1
vote
0answers
21 views
JBoss/Alfresco cannot write on slave after failover [duplicate]
Possible Duplicate:
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration. I want ...
2
votes
1answer
377 views
Replicating Triggers
I am doing some analysis on merge replication and triggers for a project.
I have two tables, Product and Audit that I am replicating.
I have an update trigger on the Product table which is ...
1
vote
1answer
237 views
Slony initial subscription is causing out-of-memory kernel panics. Why?
Context:
We run Slony 2.0 with Postgres 8.4 on two CentOS 6 servers--one master, and one slave. Our database is about 30GB in size, which isn't unusual, but we do have a couple of tables that are ...
7
votes
1answer
329 views
Transactional replication from SQL Server 2000 to 2008
I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication.
The 2008 server is not in the same LAN, so I am ...
4
votes
2answers
410 views
replication monitor: why is current average performance poor?
I am a replication rookie. We have a very simple transactional replication set up in SQL Server. I am looking at the Replication Monitor on the subscriber and one of my subscriptions show Poor ...
3
votes
1answer
160 views
What Happens When Identity Range IsExceeded?
I am using identity columns in my merge replication solution to give people an id they can tell us over the phone (i.e. to support staff). A rowguid column would be too hard for this.
I have noticed ...
2
votes
1answer
164 views
Multiple Publications for Merge Replication?
I am designing a system which will have one SQL server 2012 central database.
Each client will user merge replication to take an offline copy of their data to edit on the road.
If I add a ...
1
vote
1answer
99 views
Circular Replication, prevent failure
I recently needed to setup MySQL replication across 4 servers, so that each one is a slave of another.
After several hours of tweaking I finally got this working - it was actually quite simple. I am ...
1
vote
1answer
254 views
Replication Broken, List Out of Sync Tables
In a master-slave setup on MySQL 5.5 on RHEL 6.1, when db replication breaks (for whatever reason), what is a good way to:
check (and alert) replication is broken?
get a list of tables that are out ...
2
votes
0answers
213 views
What is causing all of the msrepl_tran_version columns to become out-of-sync between locations in transactional replication setup?
I have been having a recurring issue with transactional replication setups at the firm I work for. We use SQL 2008 R2. Seemingly without warning or any replication errors, all of the ...
1
vote
1answer
117 views
Is there a way to make the subscriber database read-only when using Transaction Replication?
I have set up Transaction Replication and its working well.
I have a few different web apps that connect to the publisher and subscriber database and I am concerned that if they use the subscriber ...
2
votes
1answer
304 views
New foreign key and merge replication
We are experiencing an issue when creating a new foreign key to an existing table, which is being replicated to another SQL Server 2008. More specifically, we are adding a new foreign key to this ...
1
vote
1answer
359 views
The primary key issue with slave
The slave is not working due to primary key error as shown below:
Last_SQL_Errno: 1062
Last_SQL_Error: Error 'Duplicate entry '550696860' for key 'PRIMARY'' on query.
Default database: ...
3
votes
2answers
918 views
Trying to understand SHOW SLAVE STATUS\G
I have slave setup and looks like it is running fine. Below is a snapshot of it.
show slave STATUS\G;
*************************** 1. row ***************************
Slave_IO_State: ...
6
votes
3answers
155 views
How to handle reporting of an extreme amount of databases in SQL Server 2005?
I'm looking for some advice on how to handle reporting for our environment. We currently have 16 servers with 20 instances of SQL Server 2005. We have over 6,600 databases and growing across these ...
2
votes
1answer
607 views
PK Violation after transactional replication
I have an application set up with transactional replication being pushed to a standby machine that will be used for emergency failovers. The replication appears to be working, any inserts made to ...
2
votes
1answer
191 views
Schedule replication of SQL Server views to MySQL remote database
I have a Microsoft SQL Server 2005 Database inhouse I have to publish some information on the internet and I can't (for security policy) query this database from the web server.
So I came up with the ...
0
votes
0answers
462 views
Slave IO Thread not running but check port 3306 is open on master server
I have setup a slave machine and check the port 3306 on the master is open. The problem on the slave is keep showing me this. I have drop and add this user on the master again but still the same.
...
0
votes
1answer
873 views
Slave start to generate relay log files but not master server
I am settings up two new servers. One is the master and the other is the slave. Below is the config file for both.
Master DB
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...
2
votes
3answers
208 views
MySQL - Master/Slave Replication with different server specs
I have a Master/Slave replication (using MySql 5.1 / InnoDB).
Currently both my master & slave are running on the same type of server (32 GB RAM, 2 x Intel Xeon 5520 Quad Core 2.26 GHz (8 cores)) ...
-1
votes
2answers
166 views
MongoDB replication to one machine
Does MonogDB supports replication where I have many machines with MongoDB that have different data and I want to replicate this data to one, and only one MongoDB?
1
vote
1answer
141 views
Getting slaves of a master-master setup stopped in sync
I have a master-master setup where each master has it's own slave. They layout might be illustrated as:
M1 <===> M2
| |
\/ \/
S1 S2
That is both S1 and M2 slave ...
0
votes
1answer
144 views
RAID vs Replication [closed]
I'm kind confuse about it, can some one give me a hand with this...
Differences.
Which one is better.
Which one do you use and why?
Personal Opinion and advise.
2
votes
1answer
60 views
MySQL replication constantly checking tables
I recently moved one of our slave databases to a new server, the database is purely used for offsite replication/backup and doesn't handle any of the live traffic.
Since moving, the new server seems ...
1
vote
2answers
1k views
Shell Script / Tool to check the MySQL Replication Status? [duplicate]
Possible Duplicate:
Monitoring replication on mysql
I am running with MySQL Master/Slave Replication on Linux.
Is there any tool/Shell script which monitors the Replication Status and send ...
2
votes
2answers
409 views
Setting Circular Replication in mysql
I have 3 MySQL servers say A,B,C.
What I want to do is that I want to make all of them master as well as slave.If there is update on any of the MySQL Servers it should be replicated to all of the ...
1
vote
3answers
996 views
Monitoring replication on mysql
I have managed to setup master and slave replication.
It is working fine. What are the possibilities that it might go down?
Is there any alerting tool to monitor that?
Another thing: Can I run a ...
1
vote
1answer
663 views
Keeping 2 tables in sync
I need to write a trigger that will keep one table synced with 2 other tables. I have table_a, table_b and table_c on slave. The master has only table_a and whenever this table is updated on master, ...
4
votes
1answer
220 views
Mirroring and Availability Groups in SQL2012
I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via ...
2
votes
2answers
566 views
ETL: extraction strategy for 200 source databases
What is the best extraction strategy for approximately 200 SQL Server 2005 source databases (same schema) for a daily load into a staging area in preparation for data warehouse cleansing, ...
