replication

Clustering on WebLogic exception on Failover

Hi all, I deploy an application on a WebLogic 10.3.2 cluster with two nodes, and a load balancer in front of the cluster. I have set the <core:init distributable="true" debug="true" /> My Session and Conversation classes implement Serializable. I start using the application being served by the first node. The console shows that the...

Alternatives to Red Gate SQL Comparison SDK?

I've been using the Red Gate SQL Comparison API in a project that's getting long in the tooth. We use a fraction of its abilities and I am evaluating other options. Our scenario is basically this: We have two SQL Server 2008 databases that can be assumed to have identical schemas. The databases are tiny. Most tables have less than 1...

Replication SQL SERVER

In my Production Server i have replication which working fine, i do have Distributed Database which as 2 subscriber db . My data is replicated from Production envi (working fine) but while data gets replicated to Distributed database in Subscriber it throws an Error Err msg = Replication-Replication Distribution Subsystem: PRD01-XYZ-VR...

Background Worker Process With WCF (Caching)

Hello All, I am tasked with building a process which will compensate for replication delays on our LDAP system. Currently, there is one write server and 4 read servers. After writing an entry to the write server there can be up to a 4 second delay on the system before the entry is replicated to the read servers. Therefore, if I call ...

Microsoft Sync Framework between Sql Server(Client) to SQl Server (Server) with change tracking possible?

I want to realize an offline scenario where client and server are SQL Server databases. Preferably with SQL Server Change Tracking. Is that possible and a reasonable option at all? From trying out it seems to me the only sql server to sql server sync is in collaboration mode and doesn't leverage sql server change tracking. (SqlSyncProv...

How much time does Tomcat take to replicate sessions on redeploy

Hi everyone, We have a Tomcat cluster with two instances (version 5.5.25) running on a single machine. We use this to make sure our web page is available and that all sessions survive during redeployment. We were wondering if sessions could be lost during this procedure. Here is what we do: a) Application is running on tomcatA and t...

unitialized subscription while replicating database

Getting this warning when trying to setup a transactional replication. This error occurs when setting up a subscription from sql server express using non impersonated login to the distributor. this works using sql server developer subscrption to sql server workgroup publication but not from sql express to sql workgroup. Im not sure if it...

Home workstation cloud computing solution on Ubuntu

Hello everyone! I want to make a cloud computing testing environment on my in-house network. I'm using Ubuntu (just to work on; i don't want to watch Gentoo compile screens all time:) and I plan to make an Eucalyptus installation for a cloud platform. I want to get the most of my Core2Quad and Core2Duo machines:) What I need a cloud for...

SQL Server equivalent of MySQL multi-master replication?

Is there an MSSQL equivalent of MySQL's multi-master replication? If so, is it available in SQL Express 2008? I've also seen it referred to as two node circular replication. Basically, I have an in-office database that I want to be perfectly (relatively :) )in sync with a cloud database (we will have access via VPN). Reads and writes oc...

Why does my solr slave index keep growing?

I have a 5-core solr 1.4 master that is replicated to another 5-core solr using solr replication as described here. All writes are done against the master and replicated to the slave intermittently. This is done using the following sequence: Commit on each master core Replicate on each slave core Optimize on each slave core Commit on e...

AppFabric Cache for large files

Hi, I'd need a solution like AppFabric to store large files (up to 500 MB) on multiple servers. I briefly explain the context: there is a central server (let's call it CS) where users upload files. These files may be consumed by devices which connect to other servers (let's call them RS1...RSn). The problem is that the bandwidth between...

How do large sites(Google, Facebook, etc) propagate information to all servers in realtime?

I'm looking for some technologies to research. I'm amazed that you can go into [insert large site here]'s interface, update a setting and within seconds it's pushed out so it's live across the board. A good example of this is adwords. If you go into adwords and change a campaign those settings are stored on the server with a unique id. ...

International Replication Timestamps

Hi all, My scenario is as follows. I have a client and server. The client pulls data from the server by using a value that is stored locally called LastReplication. This value is passed to the server whenever a request for replication data is made and the server compares it to a field in my database called LastUpdated and returns and r...

sql server replication: transfer rate, latency, amount of data

Hi! I'm working on a project that requires wireless mssql replication. Does mssql have tools for measurement of transfer rate, latency, amount of data transferred, average and peak values, etc. Or how such measurements are usually performed? ...

Keeping multiple installations of a system synchronized

We work on a large client-server system, implemented using C++/MFC/DCOM. It's planned to roll this out to multiple locations (for years it has been a single location) and have ability for some data to replicate between systems, i.e have a central server which talks to each system and is informed of changes so it can pass them on. Exampl...

How to reset(?) a (out-of-sync)DB on a MySQL master-master replication

I have a master-master MySQL replication. It was delicious until yesterday but, for some reason which I could not figure it out yet, they lost synchronization. I've been wandering around forums and several tools, tips and advices but it seems like I cannot not figure it out myself in time. So I have the idea just to reset the problemati...

What happens when HBase node fails?

HBase is wonderful, but... What will happen to the data when a node (explodes/burns down/gets stolen/Torn into pieces by mad IT on the loose)? Is the data lost? Can the cluster auto recover? Can I add new nodes without downtime? Thanks guys, Maxim. ...

MySQL replication best practices

Hi! I'm setting up MySQL replication via binlog. It's a master / slave setup. I have a few questions on how to do this the best way. Should information_schema be replicated, if yes/no, why? Should mysql db be replicated, if yes/no, why? If it all should be replicated, no binlog-do-db needs to be set? Cheers. ...

MySQL RENAME TABLE behavior when 'replicate_do_table' is set under replication

I have a MySQL master machine, and several slaves. One of the slaves is only replicating two tables. I've set this up in my.cnf using: replicate-do-table = db.table_old replicate-do-table = db.table_new Now, I understand only queries effecting table_old and table_new will be reflected on this server. That's what I want. However, now...

Sql Server replication over wan

Im looking at developing a simple ecommerce platform and need to replicate product and customer data to the web host over the internet so the website can run disconnected. The two options i can think of at present are using enterprise messaging and database replication. Im leaning towards database replication over enterprise messaging ...