database-replication

Mysql Master Slave Replication on Large Database table (how to sync initial data)

We have a production server and a dev server. We have found that backups are nearly impossible on the production server because of the query volume we experience. So, we're looking at setting up replication with our dev server being the slave. This is ideal because we can afford to lock the tables on that server and additionally it will ...

Scalability design question - master/slave databases

Hi! I just finished a database layer based on redis that offers to select between multiple databases, but I have no experience by myself on what should be common sense to do. Reliability is my biggest focus. How is writes and reads commonly organised in applications where both a slave and a master database is available? How do the big...

Replication SQL SERVER

In my Production Server i have replication which working fine, i do have Distributed Database which as 2 subscriber db . My data is replicated from Production envi (working fine) but while data gets replicated to Distributed database in Subscriber it throws an Error Err msg = Replication-Replication Distribution Subsystem: PRD01-XYZ-VR...

SQL Server 2005 replication - indicate data is replicated

Hi I am using SQL Server 2005 replication to replicate data from one table on a server to the a table on a remote server. This is happening in real time. i.e whenever the data is changed at the publisher, it is then replicated to the subscribers. From the publisher's server I need to know what data has been replicated to the subscrib...

unitialized subscription while replicating database

Getting this warning when trying to setup a transactional replication. This error occurs when setting up a subscription from sql server express using non impersonated login to the distributor. this works using sql server developer subscrption to sql server workgroup publication but not from sql express to sql workgroup. Im not sure if it...

SQL Server 2005 - are stored procedures named sp_MSdel_ related to replication?

I have a server here in my home office setup to receive push subscriptions from a server at our company HQ. I was looking through the list of stored procedures today and see many of them with 'sp_MSdel_' prepended. Are these related to replication? Can they/should they be deleted or left alone? I don't see any of these types of store...

NHibernate: read/write splitting

I would like to connect NHibernate to a MySQL master-slave replication configuration, so I would like to send writes to the master, and reads to the master and slaves. Is this possible? I am also planning on having a load balancer to balance the reads. (ldirectord) ...

sql server replication: transfer rate, latency, amount of data

Hi! I'm working on a project that requires wireless mssql replication. Does mssql have tools for measurement of transfer rate, latency, amount of data transferred, average and peak values, etc. Or how such measurements are usually performed? ...

Transactional Replication For Write Heavy Medium Sized Database

Hi, We have a decent sized, write-heavy database that is about 426 GB (including indexes) and about 300 million rows . We currently collect location data from devices that report to our server every couple of minutes, and we serve about 10,000 devices - so lots of writes every second. The location table that stores the location of each ...

SQL Server 2005 replication of DBs cross-server -- need to know when a row was inserted/updated on the target server

I am BI Manager on top of a SAP installation. I have a SAP DB which the SAP application writes data to. In order to get an environment to query without loading on the sap, I have mirrored the SAP DB on a server, and it works fine. Each night I do a full load of data, and it works fine for now. I know that somewhere down the line, I will...

Syncronizing MS Access databse file

I am developing a database with about 10 tables in it. Basically it will be used in 2 or 3 distant geographical locations (let's call them A,B and C). The desired work flow will be as follows: A,B and C should always have the same database. So when A does any changes he should be able to send those changes over to B and C. Emailing the e...

Disadvantages of Snapshot replication ?

can anybody specify the dis-advangtes of SNAPSHOT replication >? ...

Cannot create sql server replication subscription due to timestamps and queued transactions, but that's not right

In Sql Server 2005, we have a publication of a few tables. This publication has 3 push subscriptions to DB2 databases (using connector from HIS2009) and has had for several months. Attempting to add another subscription, virtually identical to the existing ones except it's a distinct server, we get: SQL Server could not create a subscri...

SQL Server replication drop vs truncate of target tables

The sp_addarticle stored procedure, used to create publication articles in SQL Server speak, has a parameter @pre_creation_cmd through which dropping the table or truncating data at the target server can be specified for a snapshot. What circumstances are appropriate for each? ...

MySQL Replication

Shall i use MYSQL replication to synchronize local database and remote database. if so, how to setup master/slave ? or any other methods available to do this ...

Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Here is a related question. Why do I get this error even when I have not installed SQL Server replication ? The strangest thing is, when I run the fix sp_configure 'max text repl size', 2147483647 Go RECONFIGURE GO it works and I no longer get this error ...

MySQL Replication woes - slave not updating

mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: 10.0.6.55 Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bi...

Why do only 2 records appear in the MSmerge_identity_range table for each table using identity ranges when there are 4 subscribers?

When I compare the sysmergesubscriptions table there are 5 entries, 1 for the publisher and 4 for the subscribers. I then look in the MSmerge_identity_range table and only see 2 records for each table that has managged identity ranges and the subid is the publishers is from sysmergesubscriptions. Shouldn't there be 1 record for each tab...

How reliable is master-slave replication?

I was watching this screencast at RailsLab where the presenter claims that it's possible to have a master DB for write operations and a slave DB for read operations. While for certain types of Web sites (e.g. blogs, social networks, Web 2.0 sites, etc.) it is acceptable for the master and slave DBs not to be 100% synchronized for short p...

Who is my slave database's master?

I'm trying to set up replication on a couple databases and have just run the change master command. I got very little feedback from the command: Query OK, 0 rows affected (0.07 sec) I want to know whether this step has succeeded or not. So, is there a way to find out who my slave db thinks is its master? Thanks. ...