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....
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...
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...
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...
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...
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....
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...
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 ...
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...
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? ...
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 ...
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...
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...
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...
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...
Is session replication configurable in JBoss? How and where to do it? ...
hi all i am asking about any useful data or links to get to know about bi-directional Replication thnx ...
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 ...
Is it possible to replicate from a MySQL 5.1 master to MySQL 5.0 slaves or are the binary logs not compatible? ...
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...