Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-replication]

104 questions
1
vote
1 answer

MongoDB not replicating properly

I am using mongoDB for my application hosted on 3 amazon instances. I have a got a Primary Node with highest priority (100) and 2 Secondaries with priority 99 and 98. A few days ago I started getting MongoCursorExceptions while accessing primary…
umair
  • 133
  • 4
1
vote
1 answer

SQL Server 2005 to Mysql Replciation DATA duplication

I set up Replication between SQL Server 2005 and Mysql 5 using following articles : http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html and error setting up replication from mssql to mysql It works fine... but there…
Abdullah Khatri
  • 11
  • 1
1
vote
3 answers

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which is 4 hours and 1 second behind). The unix date…
Mike Sherov
  • 113
  • 1
  • 7
1
vote
2 answers

Exchange 2010 mailbox server role on a secondary dc - what is your opinion

I'm looking at the database availability groups in regards to creating a constant replication of the mailbox database. Here are three options I'm thinking of (and sorry if I'm wrong with my assumptions on this). Completely new server, doesn't need…
Jeff
  • 1,089
  • 5
  • 26
  • 46
1
vote
1 answer

MySQL Database Replication and Server Load

I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL replication between my live MySQL server and…
Willy
  • 225
  • 1
  • 5
  • 9
1
vote
2 answers

SQL Server 2008 Replication - Loss Potential

Is there any type of replication over a WAN (cross-country) that can guarantee no data loss in a disaster? Are we always subject to losing a few seconds or minutes up to the point? If so, any suggested get-arounds? We are debating using cloud…
NealWalters
  • 1,333
  • 8
  • 19
  • 39
1
vote
1 answer

Is there a convenient way to manually copy the Log Shipping *.trn files from one SQL 2008 server to another?

We have a remote SQL 2008 server (ServerB) that needs to keep a warm (15 minute interval is OK) copy of production data (ServerA). ServerA is also SQL 2008. Log Shipping looks like it will do the job. We can only get to the destination ServerB with…
Rick
  • 45
  • 3
  • 7
1
vote
2 answers

Is it possible to have replication between an unknown number of databases?

In other words, can I have a single central database, that gets data from remote databases, but that does not know which remote databases exist until data from the remote database arrives? This does not sound like "replication" to me. Is there…
MJB
  • 113
  • 3
1
vote
1 answer

How to recover from failed Mysql schema update, with replication?

I have two MySQL servers configured with master-slave replication. Before we deploy a new application version we: 1) STOP SLAVE 2) Take a MySQL dump of the slave. However, if a mistake is done during the deployment of the new schema version (a table…
OmerGertel
  • 113
  • 3
1
vote
0 answers

Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?

This is a question about MariaDB (mostly) and a replication that I am considering. For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to complete, each time. During these 15 seconds, the…
GingkoFr
  • 83
  • 5
1
vote
1 answer

How to change hot_standby_feedback parameter for an existing database replica in RDS

I have a primary database instance and its read replica, both running on Amazon RDS for PostgreSQL. Recently the replica started to get a lot of canceling statement due to conflict with recovery errors due to its configuration: my_db_ro=> select…
cansadadeserfeliz
  • 113
  • 1
  • 5
1
vote
1 answer

Databases "Synchronized / In Recovery" after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). Recently, I added another server to the AG, but…
Alberto Medina
  • 299
  • 2
  • 11
0
votes
1 answer

SQL 2008 Replication

I have replicated two database in SQL2008. The last two days the distribution database from publisher server changed to Suspect Mode and the replication process is down. I read a lot from Google and tried to repair, but without success. During my…
sevenlamp
0
votes
1 answer

MongoDB - Database Profiler does not capture queries sent to secondaries replicas

I'm new to MongoDB and need some help to understand how profiler works with replication in Mongo. I have a replica set with three instances and the secondaries are used for read only by the application. When I try to profile by connecting to the…
vyosiura
  • 41
  • 6
0
votes
0 answers

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log…
Mai Tarek
  • 1
  • 2
1 2 3
4
5 6 7