replication

Using SQL Server Replication for SQL Server 2005 and 2008

I have an ASP.NET application that uses replication, and uses the RMO DLLs to do this. I initially built the application against the 2005 version of the DLLs and have it running successfully against SQL Server 2005. However, when I try running it against SQL Server 2008 it doesn't work. Initially I didn't deploy the Microsoft.SqlServer....

Replication with pull subscribers fails under Active Directory policy when using a dedicated replication account

I have a replication set up with pull subscribers and it's deployed in our corporate domain. I have requested to create a dedicated account to run this replication off of. On a pull subscription client in Sql Agent job I get this error: Message Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\username, sys...

How to connect to a slave if master goes down -- Replication

Hi. I'm playing around with data replication in MongoDb, and I currently have a master and several slave nodes. All of these are running on different ports, but they could just as well be on different machines (I'm testing atm). My question is, how would I go about connecting to these from my code? Currently, I just have one instance o...

Master Log Position not moving in MySQL Replication

I have two MySQL servers configured in a Master-Slave relationship. Master -> my.cnf: server-id=1283522287 log-bin = /var/log/mysql/binary.log // There are write permissions here. binlog_do_db= foo,bar Slave -> my.cnf: server-id = 1283706035 master-host = {master internal IP} master-port = 3306 master-user = {master slave user} m...

How do I verify that EHCache's multicast auto-discovery cache-replication is working?

Hi guys, I've set up EHCache with its stock suggestion on how to set up multicast: <cacheManagerPeerProviderFactory class="net.sf.ehcache.distribution.RMICacheManagerPeerProviderFactory" properties="peerDiscovery=automatic, multicastGroupAddress=230.0.0.1, multicastGroupPort=4446"/> <cacheManagerPeerListenerFactory class="net.sf.eh...

mongoDB replication+sharding on 2 servers reasonable?

Consider the following setup: There a 2 physical servers which are set up as a regular mongodb replication set (including an arbiter process, so automatic failover will work correctly). now, as far as i understand, most actual work will be done on the primary server, while the slave will mostly just do work to keep its dataset in sync....

Mysql Replication- Master-bin log files are not updated

Hi Everyone, I am new in Mysql Replication, My problem is : When i Give SHOW SLAVE STATUS Command on Slave, Master-bin-log files are not updated, i reset it and update the Master-bin-log file with the command CHANGE MASTER TO MASTER , still master-bin-log files are not updated when i check with the SHOW SLAVE STATUS command. Addition...

Create Sql server replication with some data transformation (during or at the end)

Hi, i'm running a sql server replication to sync a table to a separate (reporting) database. In the source database, all records have a DateTime value (not so unusual) but it isn't stored as a DateTime, but as a Guid... which points to a table which contains all timestamps (one for every minute). Now what i would like to do is during ...

SQL Server Replication subscribers filter

Guys, I have a task to do for my colleague and I need to know if is possible to specify the filter to subscribers when using replication in SQL Server? What I mean is, I don't want to create 3 types of publishers, each one to each one subscriber (with filter in publisher to redirect to specific subscriber but the inverse.) I want to in...

Mysql to Mysql - Hibernate replication using db40/drs?

Hello, I would like to do Mysql to Mysql replication using drs. Is it possible to do the same without storing data in db4o? I just want to use drs replication using Hibernate. Any positive/negative experience with drs? ...

mysql replication : utilizing insert delayed

Hi , I have a batch database that i would like to replicate to a reporting database but the queries that run on the reporting database might be very long (execution time wise) to the point where they can cause a deadlock (this is happening now because both batch and reporting applications are using the same DB) , i thought of changing ...

PostgreSQL - Slony > FATAL ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey"

Just posting this here and might help the others: I got this error when we had an outage a while ago, and tried to restart the slon replication service as the replication is NOT really replicating the data from MASTER to SLAVE: FATAL localListenThread: "select "_MY_DATABASE_copy".cleanupNodelock(); insert into "_MY_DATABASE_copy".sl_n...

How to make my MySQL databases available at all times? Some expert DB advice needed!

I've been doing a lot of research, reading on replication, etc but just not sure as to what mysql solution would work. This is what I'm looking at: when my mysql fails for some reason or there are certain queries that are taking really long to execute and locking some tables, I want the other insert/update/select queries to still func...

Mysql master log pos changes during a global lock?

Hello, I have to set up a new mysql replication replicating two databases. So I have this script which locks tables, makes a dump and unlocks them. runme.sh mysql -uxxx -pxxx < 1.sql >> logpos.txt mysqldump -uXXX -pXXX db1 > db1.sql mysqldump -uXXX -pXXX db2 > db2.sql mysql -uxxx -pxxx < 2.sql >> logpos.txt first sql file locks tabl...

Can you replicate data from MS SQL Server 2005 to MySQL 5.1 one-way?

I need to set up a one-way transactional replication from a SQL Server 2005 database to MySQL 5.1 Database. I have installed the ODBC driver and started to work on creating the publication, but I am getting an error that I have not found a solution for. The error is Failed to set publication parameter @enabled_for_het_sub because...

How often session replication happens in JBoss Clustering?

Is session replication configurable in JBoss? How and where to do it? ...

bi-directional replication sql server 2008

hi all i am asking about any useful data or links to get to know about bi-directional Replication thnx ...

Mysql master-master replication

Hi, I have to try out a master-master replication for a database of four tables. Both the master can write at once, but they would not be updating the same rows of a table and the insertions will also be collision free. The replication should be asynchronous Is this behaviour possible to implement? If so, do I have to write my own code ...

Can you replicate a MySQL 5.1 master to 5.0 slaves?

Is it possible to replicate from a MySQL 5.1 master to MySQL 5.0 slaves or are the binary logs not compatible? ...

Replicating Data from One DB to another

Hey Guys, Im wondering if you could point me to a few possibilities in the best way to move/replicate data from one database on a different server to my database. Ideally any update on the other database would be immediately pushed to mine. Another thing i was thinking about ok lets say the master database has 100 tables I could build...