Re: OpenBase & WebObjects for scaling
Re: OpenBase & WebObjects for scaling
- Subject: Re: OpenBase & WebObjects for scaling
- From: Chuck Hill <email@hidden>
- Date: Wed, 14 Jan 2009 10:47:49 -0800
Hi Joe,
On Jan 13, 2009, at 10:11 AM, Joe Moreno wrote:
Andrew,
Another thing that's impressed me with OpenBase is the clustering
failover. I doubt many people have used this feature.
Any SQL written to any database in the cluster is automatically
propagated to other OpenBase databases in that cluster within five
seconds without any primary key collisions.
Do you know how OpenBase handles that? This is usually quite the
problem with clustering and replication. Does it need to have a GUID
as the primary key, or does it work with integers?
Additionally, if the master database fails your WebObjects app will
automatically begin using another database in the cluster (no code
needed to handle this case). Once the master database recovers, its
SQL, from the other databases, is updated and it resumes handling
the WO app's SQL.
That sounds quite interesting.
Chuck
On Dec 30, 2008, at 00:39:27, Andrew Lindesay wrote:
Hello Joe;
I think this problem may be slightly different as it is not
necessarily to do with PK's. My understanding is that
"OpenBasePKPlugIn" is there to get EOF to use the OPENBASE PK-
generation scheme rather than EO_PK_TABLE.
cheers.
I think I ran into the exact problem you mentioned about the
deadlock in OpenBase 10 using the default primary key generation.
Scott Keith advised me to compile the WO apps against the
OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and,
even under heavy load, I've never had a problem using OB 10 with
the plugin. I just had to add a single line to my Application.java:
JDBCPlugIn
.setPlugInNameForSubprotocol
("com.webobjects.jdbcadaptor.OpenBasePKPlugIn", "openbase");
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden