Each server in the cluster has a a search index that is synced from one of the servers every 15 minutes. This was done because appending to an index can't happen on a nfs because of flock; see documentation (or else the index would be on a shared folder that all servers access). The issue that I'm running into is that if an action is t...
I have a database that I'm publishing to a remote site using Snapshot replication (only method that will work given the application and database schema). Because the replica database tables are unavailable while the database is refreshing, I am taking and delivering snapshots twice daily. For the target user population this is okay 99%...
I have a database infrastructure where we are regularly (at least once a day) replicating the full content of tables from a source database to approximately 20 target databases. Due to the replication code in use (we have to use regular oracle queries, no control or direct access to source database) - this results in 20 full-table sorts ...
First, I will outline my issue in case someone has an alternate fix. The Problem: I have a winform app that uses MergeReplication. This is working great except I needed to make changes to the columns and Primary Key on 5 Tables. I dropped them from the Articles and then made my changes. I then re-added them to the Articles and set t...
I know a view is composed of tables. Can I replicate a view anyway? ...
Currently we only use one database server, and that should be all we need for quite some time. However if I was to convert the database to use HiLo for a POID strategy is there anything I can do now that would make sure I don't have problems with replication later? Is HiLo even compatible with replication? I am actually having quite a...
We need to run reports at a scheduled time of the day. The application runs 24*7 and so there is not "off-peak" time as such. Therefore, running the reports should not add undue load on the system. The application runs on WebSphere v6.1 and the database is Oracle 10g R2. I have the following approaches at my disposal A set of de-nor...
In Program.cs I have the below method that is checking and the Syncing 5 SQL db's with the central server. Each one is separate from the other so I thought to speed up my program's load time by having them all run at the same time. Unfortunately it is very flaky working one time then not the next. The local DB is SQLExpress 2005 and the...
Hi, I have two servers, one in the office and another on a dedicated server that drives our website. The office runs SQL Server 2005 and the dedicated server is 2005 Express. Until now I've automated backing up our office database, FTP'ing it to the dedicated server and restoring it. This has worked fine but it's now taking around 45 ...
I have a brand new database on an ISP which I intend to use to build an ASP.NET data-driven website. However, I would like to build the whole thing locally and transplant the database to the ISP. I have TCP/IP access (i.e. I can connect to the remote database directly thru SQL Server Management Studio Express), but I do not have Termin...
I'm trying to setup replication between two SQL Servers and I'm almost there but stuck on a permission error (it appears). The servers are connected via VPN. Publisher/Distributer = W2003 + SQL2005 (Domain Controller) Subscriber = W2008 + SQL2008 (Stand Along Server not on a domain) I have set it up to Pull rather than push only beca...
I plan on updating some table names by create a synonym of the old name and renaming the table to what I want it to be. Can replication properly reference a synonym? Also as a side question, is there an easy way to see if a specific table is actually being replicated? (via a query perhaps) ...
After having many disasters with trying to getting merge replication to get work with occasionally connected mobile devices and PDAs using SQL CE we've decided to give the Synchronization framework a go. We have a scheduling application which has a master SQL 2005 DB which updates SQL CE DBs on multiple mobile devices. The master sched...
OK when working with table creation, is it always assumed that creating a table on one database (the master) mean that the DBA should create the table on the slave as well? Also, if using a master/slave configuration, shouldn't data always be getting replicated from the master to the slave to synch? Right now the problem I am having is...
Hello, I have multiple databases using merge replication with , @publication_compatibility_level = N'90RTM', @replicate_ddl = 1. I have a backup job on the publisher database that does a full backup nightly. I have another job that backs up the transaction log every 3 hours and runs DBCC SHRINKFILE (N'TheDatabaseName_Log' ) on the publ...
I've got a new client, blah blah blah, I need to break SQL Server 2000 replication from their home office to another database that they are going to completely drop (at some hosting place, it is no longer needed). The one at the home office is the "Publisher", I believe. Honestly, I think we could just delete the other database and the...
Hi, I am having a problem with my SQL Server 2005 database. The database must handle 1000 inserts a sec constantly. This is proving to be very difficult when the database must also handle reporting of the data, thus indexing. It seems to slow down after a couple of days only achieving 300 inserts per sec. By 10 days it is almost non func...
I would like to use Ehcache replicated cache, first as the backend to Hibernate second level cache, second as a cache for any data. I know how a distributed cache like memcached is working, and I know it can scale to large clusters, but I cannot find how Ehcache replication behaves on large clusters. Has someone a pointer to some info...
for ten years we've been using the same custom sorting on our tables, i'm wondering if there is another solution which involves fewer updates, especially since today we'd like to have a replication/publication date and would'nt like to have our replication replicate unnecessary entries. i had a look into nested sets, but it does'nt seem ...
I am tasked with building an application whose database backend needs to be replicated in both directions over an unknown number of clients who are usually offline. Before I explain in detail, my question is whether MySQL replication is feasible for this project or if I should look into other technologies. Here's the general use case: ...