Questions tagged [replication]

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

Filter by
Sorted by
Tagged with
2 votes
6 answers
5k views

MySQL replication out of sync

I have a master-master replication system. However, due to an auto-increment issue, I got an error in replication...and it stopped replicating. Someone told me to do: stop slave; SET GLOBAL ...
Alex's user avatar
  • 8,591
0 votes
3 answers
276 views

My system administrator set up 2 databases that sync. Master-Master. However, these two databases are not syncing

DB1 and DB2. I made changes to DB1, and it does not seem to be on DB2. When I do "SHOW SLAVE STATUS\G" on DB2, there seems to be an error: mysql> show slave status\G *************************** 1....
Alex's user avatar
  • 8,591
1 vote
1 answer
3k views

SQL Server replicating Views - Are underlying tables required to be replicated?

I have a db with many complicated tables. I've created views on this db, to simplify this data. If I replicate these views to a different server, will I need to also replicate the underlying tables?
alex's user avatar
  • 1,730
0 votes
1 answer
4k views

Replication log reader agent not running - accidently deleted job

When I look in the Replication Monitor, I see that my Log Reader Agent is not running. I right click on a publication, and click 'View Log Reader Agent Status' and it says "The proces was successfully ...
alex's user avatar
  • 1,730
0 votes
1 answer
166 views

Altering a SQL 2000 table that is replicated

I have a database that is published, and a seperate server subscribes to this publication. We are using Transactional Replication (as far as I can tell) I need to alter a column on ServerA (the ...
alex's user avatar
  • 1,730
1 vote
3 answers
411 views

repairing mysql replication

We were running out of the disk space on slave because of relay-bin files, so I stopped the mysql server, deleted the relay-bin files. changed my.cnf file to point the relay log to another ...
user avatar
2 votes
1 answer
2k views

Changing Recovery Model in Replicated Database

I now am the proud owner of two servers that replicate with each other. I had nothing to do with the install, but (of course), now i have to support the databases. Both databases are in the Simple ...
Rob's user avatar
  • 201
0 votes
1 answer
1k views

Removing Replication on SQL Server 2008

I have replication set up between 2 SQL Server 2008 servers, but I would like to reconfigure it again. Is it safe for me to remove replication during normal activity or should I wait until a low ...
Jonas Stawski's user avatar
0 votes
1 answer
3k views

Error 207 - invalid column name 'msrepl_tran_version' with Sql Server Replication

I'm setting up transactional replication with updatable subscriptions on Sql Server 2005. I setup the database with a backup, and haven't changed the schema or even changed the data since making the ...
ristonj's user avatar
  • 153
1 vote
1 answer
1k views

SQL Server Change Tracking between two Express servers?

Can I replicate my data (sql server 2008 express) using SQL Server Change Tracking to a read-only server?
Carl Hörberg's user avatar
1 vote
2 answers
322 views

Novell sles replica problem

We have a sles10 sp2 oes2 sp1 server that is in eDirectory as a replica server. However in our ds ring it is not showing up. It shows up as synched for time but it will not show up in our replica ...
lilott8's user avatar
  • 496
0 votes
1 answer
219 views

Sync mysql databases to master server

I need to do a database synchronization from each store to central store. Each store employee should be able to do this sync once or twice a day, due ISPs unavailability here. Owner would check at ...
Enrique Becerra's user avatar
0 votes
2 answers
2k views

wordpress on clustered (replication) servers

We have a clustered environment that our web sites run on. There are two web servers that are load balanced and one db server. All code is deployed to the primary server and automatically replicated ...
user avatar
0 votes
1 answer
2k views

Sql Server 2005 Replication: How to setup subscription with a sql script?

When going through the replication setup wizard, I can choose Generate script at the end. The script works fine for the Publication setup, however, when I run the generated script for Subscription ...
Nathan's user avatar
  • 306
29 votes
2 answers
40k views

Reload my.cnf without restarting MySQL service

I have to configure a MySQL server to act as a replication-master. I modified my.cnf to activate binary logs, but now in order to reload configuration I have to reload the service with /etc/init.d/...
David Espart's user avatar
-1 votes
1 answer
142 views

Weird TPS peaks on SQL 2005 replicated database

When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases - I'm seeing the TPS increase to 1000 and then immediately drop back down again - this happens every 5 ...
SuperCoolMoss's user avatar
0 votes
3 answers
1k views

SQL Merge Replication - Compress Snapshot

I have Merge Replication set up at our company with a central SQL 2005 as the Publisher/Distributor and the clients are all SQL 2005 Express. In our remote branches we are having difficulty with ...
Refracted Paladin's user avatar
1 vote
1 answer
139 views

What is the accuracy of the SQL Server 2008 Replication Merge:Conflicts/Sec performance counter?

We have SQL Server 2008 Merge Replication enabled, and I wanted to monitor any merge conflicts that arose. I setup a SQL Server Agent Alert following the instructions here. However, what I've found ...
GuyBehindtheGuy's user avatar
0 votes
4 answers
3k views

Does mySQL Replication: Master DB Name have to be the same as the Slave DB name?

I have set the Master DB Name as MDB and in the Slave server I set to replicate-do-db=SDB, but this did not work. But when I set it up as the same DB name it works. Is there any solution out there to ...
hkshambesh's user avatar
2 votes
2 answers
3k views

Schedule Recreate Snapshot and Reinitialize Subscriptions - SQL 2005

Monthly I have to generate a new snapshot for replication and reinitialize subscriptions in SQL 2005. I would really like to automate and schedule this, but I'm not having much luck discovering how. ...
Scott C. Reynolds's user avatar
1 vote
3 answers
551 views

Standby/Backup Exchange 2003 Server

(Yes, I know Exchange 2007 does replication but migrating is pretty expensive.) I'm looking to set up a backup Exchange 2003 server in my VM farm to help increase recoverability. Our email needs are ...
Matt Rogish's user avatar
  • 1,512
0 votes
2 answers
188 views

Monitoring replication using System Monitor

I have an MS SQL 2000 server that uses transactional replication and a request to user System Monitor and check if replication is doing ok and not affecting performance of the server. Any tips on ...
Paul's user avatar
  • 714
2 votes
2 answers
6k views

How to use a distributed PostgreSQL database on a web site?

I want to host a web site, the back end will be a PostgreSQL database server. I would like to have multiple web servers, in different data centers for redundancy. I would then round robin DNS each web ...
Anthony D's user avatar
  • 145
0 votes
2 answers
143 views

Light weight file replication

I have a request to create a back up web server, my idea is to copy all the web sites files from the source to the destination on some predefined schedule. Does anyone have any recommends for ...
Rob's user avatar
  • 101
2 votes
1 answer
291 views

Shadowing MySQL and PostgreSQL to each other

I have a project currently based on PostgreSQL 8.1. However, some of the data processing for it needs to happen on a server for which 7.4 is the latest version (for now, only official packages via yum ...
warren's user avatar
  • 18.7k
2 votes
2 answers
426 views

Should I avoid SQL Server Replication?

I have an app that is used by people in the US and in China and the database sits in the US. The people using it in China complain that the performance is poor, so I was thinking of using SQL Server ...
Chris Burgess's user avatar
1 vote
3 answers
1k views

Mysql slave fails to resume from master if master restarted

I have replication setup between two mysql servers, one is a master and the other is the slave. This works well unless the master is restarted for any reason. When it comes back up the slave doesn't ...
Wizzard's user avatar
  • 342
0 votes
2 answers
136 views

Is replication suitable for this scenario?

The case: An industrial IT system, controlling and storing data on two production lines There is one server per production line. Each server runs the automation objects for that production line. Each ...
codeape's user avatar
  • 485
0 votes
4 answers
349 views

sql server 2005 Replication

We have a sql server 2005 which contains 4 to 5 databases which are updated everyday externally, Currently we are backing up the Database and attaching to a different server and working on it in order ...
user avatar
1 vote
1 answer
3k views

SQL Server Sync Jobs Betwen Primary and Secondary Server

I am setting up a Standby Server for disaster recovery and high availability reasons. My product relies heavily on SQL Jobs, as such, these jobs need to exist (Disabled) on the Standby server. I have ...
MrEdmundo's user avatar
  • 291
0 votes
2 answers
290 views

Installing Replication on SQL 2005 SP3

I think I screwed myself on the setup of SQL 2005. I installed Database Services, but forgot to install replication. I then installed SP3. Is it possible to install replication after sp3? Or do I ...
user avatar
2 votes
3 answers
2k views

High Availability and Replication for Web Servers

I have a 3-layer web solution like this: Frontend with load balancing + proxies + static content Backend with 2 Apache web servers each one serving different sites Publishing System that pushes ...
hdanniel's user avatar
  • 4,313
4 votes
4 answers
306 views

Best way to replicate / mirror 100s of databases in SQL 2005

I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, ...
user avatar
1 vote
3 answers
2k views

can sybase replication be used to synchronize sybase and mysql databases?

I see that mysql replication can synchronize from sybase, but can sybase replication server write to and read from sybase? I'm trying to figure out a migration path of a big old legacy sybase system ...
Stu's user avatar
  • 2,218
1 vote
1 answer
642 views

Merge Replication Publishing Subscriber Scenario

I have a merge publishing subscriber topology of SQL 2008 -> SQL 2000 -> MS Access 2003. In one database at the SQL 2008 level, I have an updateable publication (called catalog) that is unfiltered, ...
Brian Dunzweiler's user avatar
1 vote
4 answers
8k views

moving a mysql slave to a new host : Failed to open the relay log

I have a master-master setup which I want to move to a new pair of servers (from linux to opensolaris). linux boxes names are shard1-1 and shard1-2, and osol boxes names are shard1-1-osol and shard1-2-...
Omry's user avatar
  • 685
2 votes
3 answers
754 views

Mysql Replication - are per-database threads possible?

I manage a MySQL server hosting over 100 databases. We have set up standard master-slave replication, but the SQL Thread tends to break every so often, and requires manual intervention to re-start ...
Brent 's user avatar
  • 23.3k
0 votes
1 answer
500 views

sql server 2008 snapshot agent problem

I've just installed mssql 2008 sp1 x64 on windows 7 RTM, and have the problem with creating snapshots, whenever I try to launch the snapshot agent (i.e. to setup transactional replication publication),...
user avatar
0 votes
2 answers
558 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...
Jonathan K's user avatar
0 votes
2 answers
227 views

Replicate ALL databases in SQL SERVER 2005

We have a SQL SERVER 2005 with 700 databases running. Our idea is to replicate all the databases on the server with the SQL SERVER Replication Services (http://msdn.microsoft.com/en-gb/library/...
vfportero's user avatar
  • 115
0 votes
1 answer
254 views

Sql 2005 Detach Log File w/ Replication

SQL 2005 I want to move a log file to a different location. However, the database is the publisher for replication. What is the easiest way to move the file without having to recreate the ...
user avatar
2 votes
2 answers
1k views

mysql_upgrade on multiple instances of mysql

I'm running 5 instances of mysql (backup replication server), and I need to run mysql_upgrade on server id=3 (port 3303). When i try doing # mysql_upgrade -P3303 The script runs on the #0 (id=0) ...
Ian's user avatar
  • 335
0 votes
2 answers
276 views

Why is there a delay before my replica DB sees inserts?

I am using SQL Server 2005 Standard Edition. I have a primary DB and a read-only replica with Transaction replication configured. My understanding is that with transactional replication that the '...
AgileJon's user avatar
  • 445
1 vote
3 answers
343 views

FRSdiag.exe install by an end user?

Why would an end user (non-admin, but knowledgable) attempt (but fail) to install FRSdiag.exe on their workstation? Is there a security issue here?
user avatar
10 votes
2 answers
8k views

How do MySQL logs compare to Postgresql logs?

MySQL has quite a few logs: InnoDB transaction log Binary log General query log Error log Slow query log I know about Postgresql's WAL, which is equivalent to InnoDB's transaction log (correct?). ...
Continuation's user avatar
  • 3,130
1 vote
3 answers
837 views

Is MySQL Replication on Windows reliable?

We played a bit with postgresql and slony for a master-slave-slave replication setup on windows. But we hit a wall with failover/switchover which is very unreliable. How about MySQL? How reliable is ...
EricSchaefer's user avatar
5 votes
6 answers
2k views

Making Active Directory changes atomic

I've got a Windows 2003 Active Directory infrastructure, and there are times (such as when terminating an employee) that I want instantaneous propagation across both of my AD servers. Currently, I ...
Matt Simmons's user avatar
  • 20.5k
1 vote
3 answers
4k views

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication ...
Refracted Paladin's user avatar
2 votes
1 answer
4k views

MySQL replication of only one database

I just wanted to check on the replication setup I've got working. The plan was to replicate just one database, so per the MySQL documentation I used the replicate-do-db flag in my MySQL configuration. ...
Coops's user avatar
  • 6,105
0 votes
2 answers
262 views

Lots of tiny mysql-bin.NNNN files

We're using mysql 5.0.somethin with a binary log and replication. However /var/log/mysql is full of lots of tiny 141 byte sized mysql-bin.NNNNN files. using mysqlbinlog I can see that they are empty ...
Amandasaurus's user avatar
  • 32.3k