Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How is Sybase ASE CE diff from Oracle RAC as far as CIPC management and performance.

4 posts in Cluster Last posting was on 2009-07-07 16:00:18.0Z
Mpaul Posted on 2009-06-25 21:25:12.0Z
Sender: 5ae3.4a3bf882.1804289383@sybase.com
From: Mpaul
Newsgroups: sybase.public.ase.cluster
Subject: How is Sybase ASE CE diff from Oracle RAC as far as CIPC management and performance.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a43eb38.442f.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 25 Jun 2009 14:25:12 -0700
X-Trace: forums-3-dub.sybase.com 1245965112 10.22.241.188 (25 Jun 2009 14:25:12 -0700)
X-Original-Trace: 25 Jun 2009 14:25:12 -0700, forums-3-dub.sybase.com
Lines: 3
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:155
Article PK: 48438

I need the salient features that makes ASE CE a better
engineered product that ORACLE RAC. as far as CIPC is
concerned.


Chris N. Brown [Sybase, Inc.] Posted on 2009-06-26 18:58:22.0Z
From: "Chris N. Brown [Sybase, Inc.]" <chris.dot.brown@sybase.dot.com>
Subject: Re: How is Sybase ASE CE diff from Oracle RAC as far as CIPC management and performance.
Newsgroups: sybase.public.ase.cluster
References: <4a43eb38.442f.1681692777@sybase.com>
User-Agent: Pan/0.132 (Waxed in Black)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a451a4e$7@forums-3-dub.sybase.com>
Date: 26 Jun 2009 11:58:22 -0700
X-Trace: forums-3-dub.sybase.com 1246042702 10.22.241.152 (26 Jun 2009 11:58:22 -0700)
X-Original-Trace: 26 Jun 2009 11:58:22 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:156
Article PK: 48440

I guess I'm not totally sure what you are looking for here...?

Are you looking for differences between how locks are managed, pages
(blocks in Oracle-speak) are transferred back and forth, or how workload
is managed in relation to the cluster interconnect?

Another question I have is what might you specifically be looking for
with ASE CE (vs Oracle RAC)? Scalability? High Availability? Workload
management / consolidation of workload onto the cluster?

--Chris

On Thu, 25 Jun 2009 14:25:12 -0700, Mpaul wrote:

> I need the salient features that makes ASE CE a better engineered
> product that ORACLE RAC. as far as CIPC is concerned.


Chris N. Brown [Sybase, Inc.] Posted on 2009-07-07 16:00:18.0Z
From: "Chris N. Brown [Sybase, Inc.]" <chris.dot.brown@sybase.dot.com>
Subject: Re: How is Sybase ASE CE diff from Oracle RAC as far as CIPC management and performance.
Newsgroups: sybase.public.ase.cluster
References: <4a451a4e$7@forums-3-dub.sybase.com> <4a4ba8a6.57c4.1681692777@sybase.com>
User-Agent: Pan/0.132 (Waxed in Black)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a537112$3@forums-3-dub.sybase.com>
Date: 7 Jul 2009 09:00:18 -0700
X-Trace: forums-3-dub.sybase.com 1246982418 10.22.241.152 (7 Jul 2009 09:00:18 -0700)
X-Original-Trace: 7 Jul 2009 09:00:18 -0700, vip152.sybase.com
Lines: 48
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:160
Article PK: 48442

I'm going to try and NOT post a really long answer to this --- if you
want more detailed information, feel free to email me directly (see
address in my "From" line above.

The big difference -- based on the questions you asked -- really isn't in
the lock management (we do it like Oracle does --- fully distributed).
We use 2 interconnects between nodes for fault tolerance and performance.

Workload management is really the huge difference here. We are much more
fine-grained than they are, we can move connections singularly, we can
divide up the cluster logically better, our metrics are gathered at the
server level (and load balancing / load distribution is done by the
server, not the client), etc.

Email me directly if you truly are interested in more detailed responses.

HTH,
Chris

On Wed, 01 Jul 2009 11:19:18 -0700, Mpaul wrote:

> I was on vacation so I am late in replying.
>
> Yes Chris , you did understand me correctly .
>
> I am really looking a good technical comparison of the Sybase ASE
> Cluster against the ORACLE RAC as to how they each manage cache
> coordination & synchronization and lock management and interconnect
> network performance ( is it too chatty ) as also the workload management
> paradigms.
>
> I overheard the Oracle RAC DBA that oracle uses a single interconnect to
> sync its caches etc and since its too chatty its really safe to have at
> max 2-3 nodes with full oltp funtionality and in Sybase ASE CE we now
> ( ver 15.0.3) max have 4 nodes too but it uses 2 interconnect for CIPCs
> .how efficiently I am curious.
>
> I understand in both cases you need to partition your data and appln
> logic to get performance but for ASE CE is it just possible to use
> ASE's new symantic partitioning ( the ver 15 partitioning ) to partition
> the data as per some application logic and just point the respective
> application to separate nodes via some profile and we can get a
> effective ASE cluster running.
>
> - MP.