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.

sclability of the cluster version

2 posts in Cluster Last posting was on 2008-09-30 16:55:03.0Z
Golan Nahum Posted on 2008-09-26 19:07:58.0Z
Sender: 5c1f.48dd3244.1804289383@sybase.com
From: Golan Nahum
Newsgroups: sybase.public.ase.cluster
Subject: sclability of the cluster version
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48dd330e.5c3c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Sep 2008 12:07:58 -0700
X-Trace: forums-1-dub 1222456078 10.22.241.41 (26 Sep 2008 12:07:58 -0700)
X-Original-Trace: 26 Sep 2008 12:07:58 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:96
Article PK: 48378

HI All,

I would like to hear from DBA who tested the cluster version
in production site.
what's the scalaiblity of this new version?
if you have 4 cpu machine and you add another 4 cpu machine
- what's the power you get , 5,6,7 cpu ?

yours
Golan Nahum
http://www.twingo.co.il


Chris N. Brown Posted on 2008-09-30 16:55:03.0Z
From: "Chris N. Brown" <chris.dot.brown@sybase.dot.com>
Subject: Re: sclability of the cluster version
Newsgroups: sybase.public.ase.cluster
References: <48dd330e.5c3c.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: <48e259e7$1@forums-1-dub>
Date: 30 Sep 2008 09:55:03 -0700
X-Trace: forums-1-dub 1222793703 10.22.241.152 (30 Sep 2008 09:55:03 -0700)
X-Original-Trace: 30 Sep 2008 09:55:03 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:97
Article PK: 48379


On Fri, 26 Sep 2008 12:07:58 -0700, Golan Nahum wrote:

> HI All,
>
> I would like to hear from DBA who tested the cluster version in
> production site.
> what's the scalaiblity of this new version? if you have 4 cpu machine
> and you add another 4 cpu machine - what's the power you get , 5,6,7 cpu
> ?
>
> yours
> Golan Nahum
> http://www.twingo.co.il

I'm not a DBA (anymore, but I was once!), but I've been working with the
product for nearly a year now, and done several POC's so I'm going to
reply even though I work for Sybase :).

It's generally not realistic to expect linear scalability with any
cluster solution, whether it's Sybase ASE or "someone else" (if you don't
believe me, check tpcc benchmarks, they prove this out). So, you won't
get the same scalability with 4 machines @ 4 CPU's each as you will with
a 16-way SMP machine.

HOWEVER you may see increased scalability, depending on how the
application is used (and how it's accessed). Some customers that I've
worked with have seen good linear scaling, some haven't seen what they
had hoped to but in every case it depended on the application, and how it
was accessed / used.

Generally speaking the less cache-to-cache transfer, contention, and
conflicting updates you have, the better the scale-out. The more of that
you have, the less scale-out you'll get ... no matter who the DBMS vendor.

Others may have different views but that's what I've seen so far.

-Chris