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
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
417 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
1k 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
666 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
221 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
568 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, ...
0
votes
1answer
77 views
Re-subscribing to a merge publication after edits made offline
Hypothetical Question - To help scenario planning.
Let's say I have a 2008 R2 Merge Publication with 5 active subscribers. The publication is deleted and all subscriptions are removed. A week or so ...
0
votes
1answer
48 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
1
vote
2answers
660 views
MySQL Table level Replication
I have 3 servers, say A,B &C. All have the equivalent data(same data). Now what I want is to make A as the master and B,C the slaves.
But the scenario is that I only want to replicate some of the ...
4
votes
1answer
83 views
Autogrowth and Merge Replication
We are using Merge Replication with SQL 2005. It seems I need to change the Autogrowth settings on the Publisher but I am wondering what the impact is to Replication.
Will it force an Initialization? ...
2
votes
1answer
81 views
MySQL : Does 'bytes_sent' and 'bytes_received' include mysqldump data?
I'm trying to estimate my db traffic not including backups (mysql 5.1.41).
I use show global status; to get the parameters bytes_sent and bytes_received.
Questions
Do these numbers include ...
1
vote
1answer
191 views
SQL Server Merge Replication - Safely shrink transaction log
I have a couple of SQL databases running in merge replication. My publishers HDD is full due to the transaction log of the database being replicated which is causing my snapshot agent to fail (out of ...
2
votes
2answers
487 views
Will an ALTER TABLE ADD COLUMN on a slave break replication?
I need to add a last_modified column to a MyISAM table tbl_items. The crux of this problem is that tbl_items houses several gigabytes of data. Also of note, I am using a master-slave deployment with ...
4
votes
1answer
76 views
Has Replication Stalled?
What Happened:
I reinitialized a subscription 16 hours ago. I had about 1.2M records to transfer, so I was expecting it to take a while. The Replication Monitor was saying "N transactions with N ...
1
vote
2answers
155 views
Can I replicate views with Slony?
Can I feed some SQL that creates a view to Slony?
I have some SQL that does CREATE OR REPLACE VIEW name_of_view and so on, passes it to slonik_execute_script, and then tries to run slonik_create_set ...
1
vote
2answers
423 views
Slave settings not working
I have this machine as slave. Below is the command I ran and stuck. I done the change on the config file and set the id=2 too. Anything else I am missing here?
slave start;
ERROR 1201 (HY000): Could ...
3
votes
2answers
147 views
Reinitializing Subscription Performance
I have 4 Servers, Servers A, B, C, D.
Server A publishes a Replication instance, and Servers B, C, D have Pull Subscriptions to it.
Server B's subscription needs to be Reinitialized, but I am ...
2
votes
1answer
115 views
How not to distribute reads in pgpool
I want to use pgpool to replicate one database to another. I want to do my processing on my master database (reads/writes/inserts/deletes), replicate that database to another database as it is ...
2
votes
2answers
165 views
Distribution database compatibility level
Using SQL Server transactional replication with a distributor on 2008R2, and publishers/subscribers all on SQL 2005. Does the compatibility level of the distribution database matter? Should it be ...
1
vote
2answers
135 views
Seconds Behind Master in Cloud Service
I have few mysql servers in replication master-salves in cloud service.
The problem is even thought all configuration, mysql versions, server's resources are the same, still I have inconsistency in ...
3
votes
1answer
484 views
Sql Server 2008 Replication “Generate Scripts” option not available
All,
On Sql Server 2008, I have Transaction Replication going from Server1 to Server3 (with Server2 as distribution).
I have an option to "Generate Scripts" on Publication on Server1. But I do not ...
2
votes
1answer
276 views
MySQL SBR vs RBR
Assuming a mixed replication of statement based replication and row based replication in MySQL 5.5. How exactly does it work in a master-master scenario?
Does the master that receives the query ...
1
vote
2answers
929 views
Master-Master Replication in MySQL
Good day everyone!
I want to clarify something about the behavior of master-master replication in MySQL, with respect to the logs i.e. bin-log and relay-log, it use in performing replication.
I ...
2
votes
1answer
312 views
Replicate SQL Data Inside Firewall to Outside Firewall - Suggestions
Currently I have an internal CRM application that houses all my data and runs my entire company. The front end is ASP, and the back end is SQL. The external site will run SQL
What I'd like to do ...
1
vote
1answer
320 views
3 Databases, Best Replication Setup?
We have 3 DB servers, two of them i.e. db1, db2, are located in the same data center. The other one i.e. drdb, is located in a different site. Currently, the replication setup for these servers is of ...
2
votes
0answers
479 views
Oracle GoldenGate replication is stuck
I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change ...
6
votes
2answers
3k views
Replicate RDS-MySQL to a non-amazon host?
I have a fairly large MySQL (5.1) database running in Amazon as an RDS instance. I'm working on migrating it out of Amazon. To do that smoothly I'd like to set up the new hardware as a read-only ...
1
vote
1answer
347 views
Copy SQL table to other server identity becomes int
I just built an Umbraco website. This uses a not-that-small SQL Server db. I copied this DB using the export data function built in in SQL Server 2008.
This copies all the tables and their content ...
2
votes
1answer
137 views
Replication and REPAIR TABLE
When running a repair table on a corrupted or damaged table, will this guarantee replication to break?
Documentation says "in the event that a table on the master becomes damaged and you use REPAIR ...
4
votes
2answers
650 views
Out-of-sync Replication in Sql Server
Okay, a little complex:
One local DB table is being replicated to another local DB with same table. Worked for years. User account on replication job is gone, so job was failing. I updated it to a ...
0
votes
1answer
531 views
Problem with Error: InnoDB: page … log sequence … number is in the future!
i know this question was asked before, but i am at a point where i am really stuck and do not know how to continue with this problem and i would really like to know, what causes this error to come up.
...
4
votes
1answer
873 views
PostgreSQL: Unable to run repmgr cloned database
I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave.
I am using the instructions on this guide: ...
2
votes
4answers
1k views
Creating Archiving database for old data in MySQL
I Have a Master and Various Slave Servers.
There is a huge amount of the data on all the servers and I wish to create an Archiving system for our Data.
Scenario is :
I want that only Last one year ...
1
vote
2answers
796 views
Transactional Replication - table does not have the identity property
I have a one way transactional replication set up between two 2005 MS Sql servers. Recently I have started to receive the following message in the replication monitor from the subscriber:
Table ...
2
votes
1answer
338 views
Preventing replication of alter table command to change engine
I am in the process of switching a MySQL table from MyISAM to InnoDB and I do not want the slave to perform the alter table command until I execute it manually. The intention is to have a backup for a ...
3
votes
1answer
142 views
MySQL chain replication
I have 3 servers A, B and C. What I want to do is replicate databases like this A->B->C, where A is replicating DB1 and DB2 to B and B is replicating those same databases to C, but I would also like ...
1
vote
1answer
112 views
MySQL replication risks for the master
I have a production MySQL server, fairly heavily loaded with an INSERT-only load on one of its databases. I'd like to attach a non-production (sitting on my desk, more or less) replication slave to ...
2
votes
1answer
307 views
ACID-compliance of MySQL master-master replication?
I've created two MySQL 5.1 servers, replicating off each other (log-bin) in a low latency environment (different AZs within an EC2 region). All tables that are being replicated are using the InnoDB ...
3
votes
2answers
355 views
Rows already DELETEd on MySQL slave; How to DELETE on master?
I have a handful of rows that exist in my MySQL master but not in my slave.
Replication is running ok and these rows are unlikely to ever be referenced as it is a store-and-forget type of table. ...
2
votes
2answers
1k views
MySql - Read only on slave
I want to make my MySql slave read only, i've been looking and found the read_only option, but its says that users with super privalges can still write (if i understand the text correctly), here is ...
0
votes
2answers
611 views
MySQL replication fails due to duplicate keys after master is restarted
I'm new to MySQL load balancing, I want to try the master-slave concept.
Whenever I setup master-slave for the first time, and both have up-to-date fresh data, that works perfectly fine. However, ...
2
votes
1answer
413 views
Is the “load data infile” command in MySQL unsafe in general, or just when using statement based replication?
I'm also trying to understand why MySQL considers "load data infile" unsafe and switches to RBR if running in mixed mode, does that mean it is only unsafe when using SBR?
3
votes
1answer
900 views
How do I diagnose missing rows on a MySQL slave?
I'm running traditional master/slave replication on MySQL 5.1.52, my master is set for statement based replication. A few tables are missing rows on the slave (differing row counts), these tables are ...
5
votes
1answer
1k views
PostgreSQL Failover - What tools should I use?
Here is the scenario:
There are two machines running CentOS 6.2 - machine0 and machine1
Both have PostgreSQL 9.1 installed.
One of them should be active, as a master system and through asynchronous ...
2
votes
2answers
138 views
Temporary replication of data between continental datacenters
I need a way to temporarily replicate data between two data centers on two continents for a small number of large tables in Oracle. The data in the tables is around 30Gb but the transfer rate is only ...
9
votes
2answers
109 views
What objective factors indicate it's time to implement SQL Server replication?
I am trying to strike a balance between high performance of our database and ease of maintenance. We are considering using replication to improve performance, by replicating our SSRS reports to a ...
0
votes
1answer
77 views
What DML commands can be allowed / limited on a reporting server?
I have a largish database (PostgreSQL 9.1) which I'm preparing to replicate using streaming replication. The 2nd server will be used for reporting and backup purposes. When building reports, it's ...
0
votes
3answers
137 views
Alternative of replication in internet disconnection period of time
Hi 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.
0
votes
1answer
50 views
Start Windows Service If Replication Fails
Setup:
We have SQL Server Management Studio 2005 SP3 on all of our Servers.
We have 1 Main Server, and 1 Secondary Server that has the database from the Main Server being replicated on it. (If it ...
