Mailing List Archive: OracleStorage shared

OracleStorage shared

Sep 12, 2005, 12:27 PM

Post #1 of 3 (1474 views)

Hi all,
I would like to get some infos about an OracleStorage senario:
I have 2 zope servers: server A and server B.
Both are running same zope version (2.7.5).
In front of the servers there is a "load balancer" that choose at which
server pass the web request (based of some internal "hidden to me"
algoritms).
The data should be in an Oracle DB. Please, don't ask me why. It's a
"planning tie" :(
I need the 2 servers to be able to read/write to the Oracle DB at the
"same" time (the load balancer will alway switch the server...).
By now, Just THE FIRST server I run Zope can have read/write permission
on DB, but the SECOND one can only read (an error occurr when I try to
create or modify any portal object).
I should not use Zeo, because using Zeo I need to assign a Master and a
Client server, and if the Master fail, the client will not work :(
Please, any suggestions? Did anybody ever used a configuration like this?
Thank you all very much.

Jure
aka Giorgio Pieretti
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: OracleStorage shared [ In reply to ]

chris at simplistix

Sep 23, 2005, 1:41 PM

Post #2 of 3 (1361 views)

Permalink

Giorgio Pieretti wrote:
> In front of the servers there is a "load balancer" that choose at which
> server pass the web request (based of some internal "hidden to me"
> algoritms).
> The data should be in an Oracle DB. Please, don't ask me why. It's a
> "planning tie" :(

Well, then you're going to suffer a slow and lingering death under a
mound of OracleStorage woe.

Seriously, it's turnip, hasn't been supported in YEARS...

> By now, Just THE FIRST server I run Zope can have read/write permission
> on DB, but the SECOND one can only read (an error occurr when I try to
> create or modify any portal object).
> I should not use Zeo, because using Zeo I need to assign a Master and a
> Client server, and if the Master fail, the client will not work :(

Well, here's a plan:

load balancer
|
+--------------
| |
ZEO Client 1 ZEO Client 2
| |
+--------------
|
ZEO storage server with OraceStorage mounted
(seriously, you're gonna suffer!)
|
Oracle

You can then have multiple ZEO storage servers running off Oracle, with
one or more clients attached to each, leaving the load balancer and
Oracle as the single points of failure.

For the record, your situation is crazy, and you will pay an extremely
high penalty for it...

Chris

PS: Did I mention what you're trying to do is nuts? ;-)

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: OracleStorage shared [ In reply to ]

chris at simplistix

Sep 30, 2005, 6:23 AM

Post #3 of 3 (1350 views)

Permalink

Giorgio Pieretti wrote:
>
>> For the record, your situation is crazy, and you will pay an extremely
>> high penalty for it...
>
> I know.... but customers does not always accept experts suggestions :((((

If you customer put a gun in their mouth (or yours for that matter!) and
told you they wanted you to pull the trigger, would you?

> Have you ever used OracleStorage with Zeo???

No, I refuse point blank to use OracleStorage.

> Can you send me a zeo.conf
> example???

No, it probably doesn't work at all by now...

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db