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.
1,044
questions
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 ...
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....
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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/...
-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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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, ...
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-...
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 ...
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),...
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, ...
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/...
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 ...
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) ...
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 '...
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?
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?).
...
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 ...
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 ...
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 ...
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. ...
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 ...