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
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?
2
votes
1answer
123 views
Reformatting master MySQL server and temporary solution
We have MySQL master and replication servers both running on different machines. We have noticed some system files showing integrity issues in the master machine. Temporarily we would like to make the ...
2
votes
1answer
286 views
Safely promoting master to slave
Previously I've asked the similar question MySql Switching Masters During Failover with log-slave-updates.
Let's say this is our current replication
In addition, I have few application servers. ...
3
votes
1answer
157 views
Clarification about master slave configuration in mysql
We are planning to migrate an existing MySQL database to a new server using the MySQL replication master slave procedure.
Unfortunately this will take a lot of time so we were thinking of doing a ...
1
vote
0answers
139 views
Finding differences between a master and slave when pt-table-sync fails
I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that.
Certain tables in the mix have composite ...
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
269 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?
0
votes
1answer
128 views
Slony - Wait for Event
What is the behavior of Slony waiting for an event after lock set command?
Basically I am trying to do a switchover and it takes a lot of time. We are following these steps:
Lock Set
Wait for Event ...
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
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
...
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 ...
0
votes
0answers
256 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 ...
0
votes
1answer
287 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 ...
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 ...
7
votes
1answer
122 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 ...
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
347 views
MySQL proxy and SHOW PROCESSLIST query time
I have MySQL replication currently occurring between two masters bidirectionally, one in a data center locally, another over at Amazon EC2.
Everything seems to function normally replication wise, no ...
2
votes
1answer
1k views
MySQL Bug required remedy : [Warning] Invalid (old?) table or database name '#sql-'
We have a master & multiple slave replication in our production environment. At first, I found this error in the mysql error log on the master and later on the slave. As for all the replication, ...
2
votes
1answer
582 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 ...
0
votes
1answer
155 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 ...
5
votes
1answer
344 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?
2
votes
2answers
163 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 ...
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
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
55 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 ...
2
votes
1answer
205 views
Will mysql_secure_install script block master updates to slave?
I had setup two virtual mysql database servers in two oracle linux 6 vm's, which come with mysql server ver 5.1.47
Master named prod_master & slave named prod_slave1.
I installed both the mysql ...
2
votes
0answers
77 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
...
1
vote
1answer
238 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 ...
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
100 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 ...
6
votes
2answers
1k views
Streaming replication and failover on PostgreSQL
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
5
votes
3answers
3k views
Add article to transactional publication without generating new snapshot
Using SQL 2008 R2 transactional replication with pull subscribers, when we add an article, I'd like to avoid having to create an entire snapshot (the db is ~80 GB, so this takes hours).
From this ...
1
vote
2answers
289 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 ...
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 ...
4
votes
2answers
453 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
2answers
1k views
Difference between Row based and statement based replication in Mysql?
What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave.
If I am using Row based replication then whats is 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 ...
4
votes
2answers
740 views
Are there any in-memory NoSQL databases?
Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage?
I'm looking at ...
1
vote
2answers
977 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:
...
0
votes
0answers
173 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
0answers
60 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?
...
2
votes
3answers
521 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
467 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?
2
votes
2answers
641 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 ...
2
votes
1answer
5k 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
...
2
votes
1answer
834 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, ...
22
votes
7answers
13k views
How do I completely disable MySQL replication
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
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 ...
3
votes
1answer
401 views
setup transaction replication in cross domain
I'm trying to setup transaction replication between two domains under the same active directory. The publisher server is in a DR site domain and the remote distribution server is in the main site ...
