Puakma: Under the hood

I'm Brendon Upson, jack-of-all-trades, master of one or two. I'm talking about life running a small ISV tackling business issues and leaping technology hurdles in a single bound.

webWise Network Consultants is based in Sydney, Australia and develops the groundbreaking Tornado Server technology.

Relational Database Replication

Filed under: by Brendon Upson on 2005-11-15

We are working on a project at the moment that is crying out for Notes' replication abilities. Unfortunately, the data model is very complex and would be a complete nightmare to implement in Notes. The customer wants a stand-alone system to be installed at each site and to have the databases merge at specified intervals.

Naively I had assumed there was some addon product that would allow this to happen magically (yes, OK, I was spoiled by Notes...). Truth is that even those products that do the magic (Oracle), the programmer must still ensure the keys are unique. Well duh, that's the hard part!

I am now in the process of retrofitting the application with new primary keys (SiteCode+IncrementingNumber, eg WNC199).Previously I was simply using an integer. This is a massive change to the structure.

Once the data model is updated, then I'll have to write the replication logic. I am hoping this will be quite easy and I can tackle it in a generic fashion. I am going for a hub/spoke topology with everything replicated through the head office server. The replicator will run as a seperate task as a scheduled action in a utility application.

I never did want an easy life...