I have a 2 node cassandra cluster with a replication factor of 2 and AutoBootStrap=true. Everything is good during startup and both nodes see each other. Let us call these nodes A and B. Add a set of keys and columns (lets call this set K1) to cassandra through node A. Connect to node A and read back set K1. Same on Node B. Success - G...
Hi, i'm running 12 sql server replications, 11 of which have 1 subscription, and 1 has 2 subscriptions. Now i have a problem with a very large transaction log which i want to shrink, but i get the messages that the transaction log is in use. I suspect that the replication (publication, maybe the subscription too) is causing this problem...
I have two SQL servers that I need to have identical. Sync should occur maybe a couple times per day, automatically. The two servers have no "direct" connection between them, so no linked db etc. (They are on totally diff machines, networks, domains, with firewalls between etc) You can use the Internet though, like Web Service, FTP... ...
The situation is as follow : Our company works two main production sites, communicating via WAN. We develop a software internally which uses about 100Gb of disk space on our servers (application data deployed to our customers with a lot of images). In order in improve performance, our network administrators choosed DFS replication (ever...
I have a server with about 3 replications configured. 3 databases being published to about 3 other servers there's a central Distributor I need to know if I can change the distributor for one of the publishings and let the others or if I can only change all of the replication distributors at the publisher server. And How to do this...
Hello, Is it possible to do Incremental syncronization for occasionally connected clients using JDO. I stumbled upon JDOReplicationManager but not sure whether is solves the following needs, Replication to be initiated from an web application. Replication should be a two way process. i.e. Synchronization If there is a failure in netwo...
Hi, I work in a small supermarket chain (4 stores). Each store has its own local database which contains information of each product, prices, and transactions that have ocurred on the store. In addition, each store needs to replicate this information back and forth to a central location. Right now we are using something called SQLRem...
How can I configure my mirror database to publish its data to the same replication database that my primary has ( I need to take my primary database offline for maintenance purposes.)? ...
I've got a database from SQL Server 2005 that I am programmatically attaching to an instance of SQL Server 2008 R2, then re-establishing replication on some tables (via some pre-baked scripts that have worked for a small lifetime) with another server still running SQL Server 2005. Suffice it to say it's just a particularly convoluted bu...
Right now I have a DB where the PK's are int IDENTITY. I recently, in the last year, was tasked with adding these to a Replication Topology. This has worked out quite well with the exception of the IDENTITY fields. I want to explore my options for changing or replacing them with a uniqeidentifier(GUID). Is it feasible to insert a NEW ...
I have just lost pretty much a day and a half trying to get pull replication going for an off site server. After experiencing the pain that was this experience I am now thinking it shouldn't be this hard so maybe I am doing it wrong. I never did get it to work, I had to go to push replication. Here is the situation. We have a virtual...
I would be interested in some timing details. FOr example I place in session some container, whcih can keep different data. I do change of content of the container frequently. How can I assure that the container session value get replicates across nodes for any change? ...
Hi, when I run the app on server I get: Could not load file or assembly 'Microsoft.SqlServer.Replication.DLL' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1) Description: An unhan...
I have a Merge Replication with ~200 subscribers. I am trying to determine what would be appropriate Identity Range Sizes on some of the tables. You see I inherited a DB structure that was not designed for Replication therefore all table PK's are int IDENTITY's. Unfortunately some of these tables were built WITHOUT any tracking fields...
Hi, I want to "replicate" a database to an external service. For doing so I could just copy the entire database (SELECT * FROM TABLE). If some changes are made (INSERT, UPDATE, DELETE), do I need to upload the entire database again or there is a log file describing these operations? Thanks! ...
Hi! After setting up mysql replications with master/slave db scheme, I noticed that the slave db server is not read-only. Of cause, after that I configured it manually in /etc/my.cnf file. I just can't understand: isn't it the default behavior that the slaves are always running in the read-only mode or it should be always configured by ...