Eclipse Community Forums: EMF » [CDO] Server/Clone Architecture advise needed

Home » Modeling » EMF » [CDO] Server/Clone Architecture advise needed([CDO] Server/Clone Architecture advise needed)

Show: Today's Messages :: Show Polls :: Message Navigator

[CDO] Server/Clone Architecture advise needed [message #878467]

Tue, 29 May 2012 07:25

Tom Bauwens
Messages: 10
Registered: May 2012

Junior Member

Hi guys,

I am working on designing an application for a retailer. The application will be built with RCP and will be responsible for the store part of the retailer, i.e. registering product sales, customer info,...

I have an architecture in mind and would like to verify this with you as I have no CDO experience. I would appreciate it very much if you give me some feedback...

The app:
This retailer has 2 physically different located stores and in each store there are 4 or 5 cash tills or cash registers (these cash registers are PC's or Mac's wtih 4gb of mem). The data (DBStore), however, has to be shared across both stores. The communication between the stores is via WAN and as such is unreliable. It is absolutely vital that each cash register works even with WAN failure (maybe also LAN failure, but many things will break if there is no LAN such as printers...so it's off lesser importance).

For this it would be ideal (I think) if the clients (the cash register PC's) all have an embedded CDO server and synchronize with the CDO Master (will be located in one of the stores).
Actually, I would make the embedded CDO's of store 1 sync to a CDO Server Clone located in store 1 which syncs to the CDO Master located in store 2 and the embedded CDO's in store 2 would sync to the CDO Master as well.

My questions are now:
- is this approach is ok or would you advise another approach
- is there info on the reliability of such a CDO architecture (has anyone done this?)

(I was actually looking into database clustering until I saw that CDO had this cool feature Smile

)

Thanks a lot for your comments.
Tom

Report message to a moderator

Re: [CDO] Server/Clone Architecture advise needed [message #878480 is a reply to message #878467]

Tue, 29 May 2012 07:59

Eike Stepper
Messages: 5153
Registered: July 2009

Senior Member

<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Tom, 
 
I can well imagine something like this (and have actually seen it in
reality): 
<img src="http://www.eclipse.org/forums/index.php?t=getfile&id=9939" alt=""> 
 
Getting all that technically right may be a challenge, though ;-) 
 
Cheers 
/Eike 
 
---- 
<a class="moz-txt-link-freetext" href="http://www.esc-net.de">http://www.esc-net.de</a> 
<a class="moz-txt-link-freetext" href="http://thegordian.blogspot.com">http://thegordian.blogspot.com</a> 
<a class="moz-txt-link-freetext" href="http://twitter.com/eikestepper">http://twitter.com/eikestepper</a> 
 
 
 
Am 29.05.2012 13:25, schrieb Tom Bauwens:
<blockquote cite="mid:jq2bo0$t8u$1@xxxxxxxxe.org" type="cite">Hi
guys,
 
 
I am working on designing an application for a retailer. The
application will be built with RCP and will be responsible for the
store part of the retailer, i.e. registering product sales,
customer info,...
 
 
I have an architecture in mind and would like to verify this with
you as I have no CDO experience. I would appreciate it very much
if you give me some feedback...
 
 
The app:
 
This retailer has 2 physically different located stores and in
each store there are 4 or 5 cash tills or cash registers (these
cash registers are PC's or Mac's wtih 4gb of mem). The data
(DBStore), however, has to be shared across both stores. The
communication between the stores is via WAN and as such is
unreliable. It is absolutely vital that each cash register works
even with WAN failure (maybe also LAN failure, but many things
will break if there is no LAN such as printers...so it's off
lesser importance).
 
 
For this it would be ideal (I think) if the clients (the cash
register PC's) all have an embedded CDO server and synchronize
with the CDO Master (will be located in one of the stores).
Actually, I would make the embedded CDO's of store 1 sync to a CDO
Server Clone located in store 1 which syncs to the CDO Master
located in store 2 and the embedded CDO's in store 2 would sync to
the CDO Master as well.
 
 
My questions are now:
 
- is this approach is ok or would you advise another approach
 
- is there info on the reliability of such a CDO architecture (has
anyone done this?)
 
 
(I was actually looking into database clustering until I saw that
CDO had this cool feature :) )
 
 
Thanks a lot for your comments.
 
Tom
 
</blockquote>
</body>
</html>

Attachment: gjiegjbb.png
(Size: 18.15KB, Downloaded 41 times)

Report message to a moderator

Re: [CDO] Server/Clone Architecture advise needed [message #878495 is a reply to message #878480]

Tue, 29 May 2012 08:31

Tom Bauwens
Messages: 10
Registered: May 2012

Junior Member

Hi Eike,

So you are agreeing with the design? Cool! Smile

Thanks also for the image! It is exactly what I had in mind. Now I can just copy/past it in my documents Smile

We love challenges! But now I'm curious, maybe I'm underestimating the effort, but why do you say challenging? I've already did some small tests with your offline examples and it seems to work... Maybe, I'm missing something?

Can you also possibly give more info on who used it this way and what kind of application it was?

Thanks,

Tom

Report message to a moderator

Re: [CDO] Server/Clone Architecture advise needed [message #879679 is a reply to message #878495]

Thu, 31 May 2012 12:12

Eike Stepper
Messages: 5153
Registered: July 2009

Senior Member

Am 29.05.2012 14:31, schrieb Tom Bauwens:
> Hi Eike,
>
> So you are agreeing with the design? Cool! :)
>
> Thanks also for the image! It is exactly what I had in mind. Now I can just copy/past it in my documents :)
>
> We love challenges! But now I'm curious, maybe I'm underestimating the effort, but why do you say challenging? I've
> already did some small tests with your offline examples and it seems to work...
Great ;-)

> Maybe, I'm missing something?
There are some TODO comments on SynchronizableRepository.java.

For large master repos with out-of-sync clones there are pending some performance optimizations (to be committed soon).

Make sure you use raw replication mode.

There may be other challenges. Feel free to ask here if you encounter one. And, if you have time, it would be awesome if
you summarize your findings in a small wiki article ;-)

>
> Can you also possibly give more info on who used it this way and what kind of application it was?
Companies often don't want to have their technology stack posted publicly ;-(

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] Server/Clone Architecture advise needed [message #880077 is a reply to message #879679]

Fri, 01 June 2012 07:28

Tom Bauwens
Messages: 10
Registered: May 2012

Junior Member

Hi Eike,

Thanks for your reply. We will soon get going on the implementation of such an architecture. And don't worry, we will make the technology stack publicly available. After all, i'm sure we will be very proud of it Smile

Regards,
Tom

Report message to a moderator

Re: [CDO] Server/Clone Architecture advise needed [message #880089 is a reply to message #880077]

Fri, 01 June 2012 07:57

Eike Stepper
Messages: 5153
Registered: July 2009

Senior Member

Am 01.06.2012 13:28, schrieb Tom Bauwens:
> Hi Eike,
>
> Thanks for your reply. We will soon get going on the implementation of such an architecture. And don't worry, we will
> make the technology stack publicly available. After all, i'm sure we will be very proud of it :)
Then all the best and keep us updated ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Previous Topic:	[CDO] Backends and query languages
Next Topic:	EMF on existing database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 10:59:04 EDT 2013