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
1
vote
1answer
119 views
Default Constraints with Merge Replication
I am using merge replication in SQL 2012.
Why can't you mark default constraints as NOT FOR REPLICATION? You can disable all default constraints for a merge article, but it is all or nothing so it ...
1
vote
0answers
70 views
Bucardo stops sync when node is offline
I'm using Bucardo 4.4.8 to replicate two PG DBs to one central master. My problem is the same as was posted back in 2011 here
...
0
votes
0answers
254 views
Potential cause for memory leak
I have a replication setup where one of those nodes started experiences a slow but steady memory leak.
The setup is kind of like this
M---->S
|
\/
FilteringSlave
| | | |
R1 R2 R3 ...
2
votes
1answer
83 views
MySQL - Partially restore binary log
I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500.
How can I do that?
0
votes
1answer
283 views
mysql “Unsafe statement”
I get a lot of following messages
Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table ...
7
votes
1answer
121 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
4
votes
1answer
1k views
Best solution for cross-datacenter MySQL master-slave replication
We are working on a new system architecture for our company. We have a HPC, which runs in our own data-center and we are planning our front-end and a fallback system on Amazon Web Service.
System ...
1
vote
1answer
71 views
How to use MySQL Server 5.6 for GeoIP replication?
I have downloaded the new MySQL Community Server 5.6 and I dont quite understand how to use it properly for GeoIP based replication across 20 nodes. I want to have one central node, then three smaller ...
2
votes
1answer
576 views
MySQL Exec_Master_Log_Pos value greater than Read_Master_Log_Pos
I am trying to repair one MySQL replication setup. One of the database's table at slave side is deleted and the updates from master side are received but because of missing table these updates are not ...
1
vote
1answer
232 views
PostgreSQL hot standby promotion, multiple hot standbys
I'm trying to work out failover and disaster recovery procedures for a
cluster of three servers. Streaming replication is being used with a high
wal_keep_segments, no log shipping is happening. I need ...
5
votes
1answer
342 views
Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?
I'd like to use InnoDB on the master, for its transactional ability, but MyISAM on the slaves for the full-text search ability. Is this possible?
1
vote
1answer
116 views
Why Regenerate Snapshots For Merge Replication
I am in the process of implementing merge replication in SQL 2012 with web sync.
I am wondering two things,
Why is it suggested to regenerate the snapshots every 14 days by
default?
With web sync ...
2
votes
2answers
162 views
SQL Replication Commands
I'm trying to figure out how i can get the number of commands over the last day for a sql server replication. Transactional / Snapshot / Merge.
I really want to be able to calculate the average ...
2
votes
0answers
133 views
SQL Server Replication :: Dedicated Distributor Hardware Requirements
Does anyone know any rules of thumb (or better) with regards to hardware requirements for a dedicated distributor server? i.e. Based on estimate metrics (e.g. number of subscribers, publishers, ...
3
votes
1answer
54 views
In SQL Server Replication, at what point is it recommended that one separate the distributor?
Is there a general rule of thumb for when it becomes good practice to assign distribution responsibilities to a separate server that is not also a subscriber?
e.g.
"At n publishers/publications ...
3
votes
1answer
1k views
Deleting bin logs in replication environment
I have a question about deleting binary logs in the replication environment:
We have an environment with 1 master and 2 slaves (running mysql 5.5). Sometimes, we run into a space issues during heavy ...
1
vote
1answer
351 views
Merge replication - can't create snapshot – timeout
I have a SQL Server 2008 database, and I need a merge replication because I want to sync with mobile devices afterwards.
So I created a replication but when it comes to start the snapshot agent, the ...
5
votes
0answers
99 views
Msg 14027, Level 11, State 1, Procedure sp_MSrepl_addarticle [table] does not exist in the current database
Before setting up SQL Server snapshot replication, I backed up the database from ServerA and restored it to ServerB. Both servers are running SQL Server 2008 R2 SP1.
In trying to setup snapshot ...
2
votes
0answers
76 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
7
votes
2answers
376 views
Merge replication fails on executing query
My merge replication was working fine this morning. Since an hour or 2 ago, my synchronisation status windows keeps showing this message:
Thread id 3108 will wait for 15 second(s) before retrying the ...
1
vote
0answers
51 views
How to Remove Articles Based on User
I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks.
I have a filtering scheme that controls which tables end up ...
0
votes
1answer
154 views
Where is sp_MSrepl_getpublisherinfo in SQL Server?
In learning about replication in SQL Server and having problems creating a subscription, I looked at the definition for sp_addsubscription. It calls sys.sp_MSrepl_getpublisherinfo, which I cannot find ...
2
votes
3answers
485 views
Transactional Replication snapshot locking Publisher db from beginning
I have recently upgraded my remote distributor to 2008r2. I am getting complete system locks when attempting to generate a new snapshot in the day when we have added an article to the publication (we ...
4
votes
2answers
1k views
Scaling Percona datacenters: setup and replication
Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you.
We have already scaled alot of our application stack: we offloaded ...
2
votes
2answers
266 views
Mysql database replication on different vlan/subnet/another site
Saw the posts for "MySQL high availability, failover and replication with Latency"
Is it possible to work it in a DR site when its not in the same vlan?
1
vote
2answers
967 views
--replicate-wild-ignore-table doesn't work?
According to the document about the replication and temporary tables, I'm setting --replicate-wild-ignore-table option to the %.norep% to prevent temporary tables from being replicated:
...
3
votes
0answers
58 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
0
votes
0answers
171 views
How To Speed up Merge Replication
I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM.
The replication process works quite well, but it is when it comes to applying the ...
3
votes
1answer
116 views
Merge replication with PDAs AND P2P replication between servers?
We're currently building a setup to scan tickets at an event. We plan on having 2 servers at each entrance but can't have a local link between the two.
We have scanners (sqlCE) and half of them are ...
2
votes
2answers
630 views
Advanced Replication vs Oracle Streams
I'd like to know what is advantages of Streams over Advanced Replication. I wanted to use updatable materialized views on my project, but on one forum I read comment that if we don't use very old ...
4
votes
2answers
451 views
Log Reader replication agents are constantly restarting
I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
2
votes
1answer
820 views
Setting up replication for MyISAM tables?
Before setting up a replication within MySQL, the data first needs to be transferred to the slave.
Since MyISAM tables can be copied as files. Would it be okay to copy MyISAM files, .myd .myi .frm, ...
2
votes
1answer
4k 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
...
4
votes
3answers
3k views
How to change a MySQL previous slave to be a master and remove slave status information?
I have a master -> slave configuration where the master failed. I've been able to reset the old-slave to be a master and the old-master to slave from it. Fine.
What I can't seem to do is to remove ...
5
votes
1answer
303 views
MySQL replication - replicate to multiple DBs on slave?
I've got a single table in a master DB that I would like to replicate to multiple databases on one slave server. Like this:
masterDB.tableA -> slaveDB1.tableA
masterDB.tableA -> slaveDB2.tableA
...
0
votes
0answers
122 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
2
votes
0answers
201 views
SQL Server 2008 replication scenario
First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;)
Until now, the scenario that I have is as follows:
In a server under our LAN, we have a database ...
1
vote
0answers
120 views
Upgrading Remote Distributor in SQL Server Replication
I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2.
Script ...
1
vote
1answer
87 views
slave issue with load data
When I use "load data infile" on master, the data is properly transferred to slave.
But when I use "load data local infile" from remote server to master, the data does not pass on to slave.
Why does ...
2
votes
3answers
517 views
Replicating only significant records to specific database
I have a remote database which holds data for various databases in various locations. I want to do database replication, but only data specific to a certain database should be replicated to it. I can ...
3
votes
3answers
460 views
What are the limits on the amount of slaves per master?
I currently have a Master with 2 slaves, all running MySql 5.5.
What are the limitations on the amount of slaves I can connect to a single master? what parameters should be taken into affect?
3
votes
1answer
82 views
Is there a way to start a script on the publisher when synchronization starts?
I am using merge replication with pull subscriptions and Web Sync.
What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process?
...
3
votes
1answer
83 views
Screwed up replication by sharing server ids
So I had my screwup for the week today. I was adding another pair of slaves and set the same server ID on the new slave as an old slave.
The layout kind of looks like
Master
| |
\/ |
oldS |
...
1
vote
1answer
415 views
Indexed View Slows Replication
I have setup SQL Server transactional replication, and then added indexed views at the subscriber, but the indexed views appear to really slow down the subscriber and almost bringing it to a halt.
I ...
2
votes
2answers
402 views
All pull subscriptions cannot connect to Distributor
recently all my PULL subscriptions have this message in the synchronization status. :-
The process could not connect to Distributor 'DISTRIBUTIONDB'
This is only happening with the PULL ...
2
votes
0answers
187 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
4
votes
2answers
433 views
Replicate DB2 table to SQL Server 2008
I need to replicate data from a DB2 database into a SQL Server Database (along the lines of about 80 tables). I can create an SSIS package, to just flat copy the data from one to another pretty easy, ...
1
vote
2answers
969 views
Error reading MySQL 5.5 binary log using mysqlbinlog
I'm having some trouble with a replication setup I'm using. It has been working fine for months, and then over the weekend, the slave stopped reading updates from the masters binlog with an error Got ...
1
vote
1answer
209 views
mongodb: replica-set processing reads on the primary
Running a replica-set with 1 primary and 2 secondaries, I wonder why the READs are also done on the primary. Shouldn't the primary mainly do the WRITEs and the secondary can share the READ-load?!
I ...
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 ...
