replication

Google Gears, replication, threading and problems

Hi all, I have recently made my first attempt at using Google Gears and performing replication to the local Sqlite database after many weeks of trial and error everything seemed to be sweet as candy. I have accomplished this using approximately 10 worker threads each of which intermittently poll a webservice and update the database as ...

i have to do the following to the database, have an idea but its not clear. help!

note:- Please read the explanation of what is to be achieved and provide initial guidance, i know there must be a lot of concepts involved, i am not asking for complete step by step solution, need help in knowing what concepts need studying and a proper path to start with. There are a lot of resources on the internet, which makes it real...

SQL Server 2005 Merge Replication with SQL Compact 3.5 sp2 Web Synchronization setup error

I am trying to setup a merge replication from SQL Server 2005 to SQL Compact 3.5 sp2. My environment: - Server: Windows 2008 R2 64bit - SQL Server 2005 installed on server - IIS 7 installed on same server with IIS6 compatibility components installed - SQL Server Compact 3.5 SP2 Server Tools installed on server I create the publication ...

Is there a way to shard and replicate neo4j data?

I am considering the option of neo4j for some of the new projects I am working for. For the given data needs (inherently graph based) neo4j fits well and a quick prototype is giving good response time for me. What I want to understand is how to scale a neo4j deployment. Specifically: How do I shard my data across neo4j deployments. Sin...

Mysql Replication

Hi I want to be able to replicate a local mysql db to an online mysql db over adsl. My adsl ip is dynamic, so I dont have static ip. I use a custom application to fill the local db, the app uses quite a lot of cpu and the on webserver that hosts the online db is suffering when I run the app online. Is there any way to do this ? Than...

Fast way to replicate a huge database table using java

[BACKGROUND] We are currently trying to solve a performance problem. Which is searching for data and presenting it in a paginated way takes about 2-3 minutes. Upon further investigation (and after several sql tuning), it seems that searching is slow just because of the sheer amount of data. A possible solution that I'm currently inves...

postgresql replication + scrubbing

Is there any an easy (built-in, add-on, open-source or commercial) to do replication on Postgresql (Master-slave) to have the data inside the slave be scrubbed for PCI compliance while being replicated across? How about ETL tools? It does not have to be instantaneous ... up to an hour lag is acceptable but the faster the better of cour...

Provider and subscriber in SQL Server 2008, can subscriber handle insert/delete?

Assuming I did all that is needed (consider complete replication) Make server "A" the provider and server "B" the subscriber Question: If I want to add, delete, update, or insert data, will I be able to do that by connecting to the subscriber? If yes, will the data change be automatically reflected in the provider? Using: C#, ASP....

SQL Server 2008 data loss with CE replication

Hi, I am using SQL Server 2008 CE replication, and seem to be suffering some data loss (i.e. records are not appearing on the CE databases after a full sync). I am getting the following entries in the application log: Replication-Replication Merge Subsystem: agent 0033007B-0043-0039-4400-440036003300 failed. Internal error: A read ope...

Is it possible to do replication of only one table with different mysql databases in different hosts?

Hi there. I'm trying to do replication of one table in a remote host in my database. Suppose there is a change in the remote database and i want it commited or replicated to my database in order to keep it up to date with the lastest changes without having to run any dumps, cron scripts or something similar. Is there any way to replica...

Replication/Synchronization Library for Occasionally Connected Systems

here is the situation I have a .Net desktop application which stores it's data on local file system (using sqllite). And there is the master database on a remote server which. The desktop application needs to synchronize data to the master database when ever there is a dial up connection to a specif server or when ever there is an intern...

Ehcache Replication

Hi, We are using ehcache in our J2EE web application deployed on Jboss server. The application is deployed on 10 servers in cluster. Ehcache is replicating cache data in 10 servers in cluster. Would replicating cache data on many server(10 servers) can create performance issue? Regards, Maulin ...

Replication between two different Application

We are using ehcache replication for two different applications. The application A has cache 1, cache 2 in ehcache.xml. The application B has cache 1 in ehcache.xml. The application B does not have cache 2 in ehcache.xml. For replication between two application, we are using same multicastGroupAddress and multicastGroupPort. What will...

Scaling Write Intensive App (LAMP, MySQL) (Catalog Style Application)

Hi, I was wondering if there's anyone out here who has experience with write-intensive data due to file import. The main requirement is for the business users to be able to import a data that represents relationships between master tables. They should be able to export the same in real-time ( as much as possible). Setup: front-end (...

Replication framework for iPad/iPhone

I need peer-to-peer replication for an iPad application (MonoTouch or SDK). The best thing would of course be suggestions.... But also hints about where to look. Normally this would be a feature of the database, but perhaps with the IOS model (multi-processing etc) it would have to be a library for my application? Would it be much the...

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 ...

What is the best solution for POS application?

I'm current on POS project. User require this application can work both online and offline which mean they need local database. I decide to use SQL Server replication between each shop and head office. Each shop need to install SQL Server Express and head office already has SQL Server Enterprise Edition. Replication will run every 30 min...

Can i set up sql server as master and my sql as slave in replication

Can i set up sql server as master and my sql as slave in replication? I can find only two subscriber ie.Oracle Subscribers and IBM DB2 Subscribers. how to add my sql>??? – Edit Sorry for not asking question properly,See we will be getting sql server backup from client every night,and we have to load it to my sql every night.so we my s...

How do I add a second subscriber to SQL 2005 Transactional Replication publication

I have setup SQL 2005 Transactional Replication, with one master database acting as the publisher, and one subscriber. It's running fine. Now, I want to add a second subscriber to this publication. I created the subscription on the second server, and created the snapshot ok, but when it starts to syncronize I get the error "Cannot d...

What type of database replication should I use?

I have 2 databases, one on local server and one on a remote server. I created a transactional replication publication on the local DB, which feeds the remote DB every minute with whatever updates it gets. So far, this is working perfectly. However, the local DB needs to get cleaned (all its information deleted) daily. THIS is the part ...