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.

Sybase ASE CE questions from a newbie

3 posts in General Discussion Last posting was on 2011-08-12 15:26:24.0Z
Jean-Pierre Dareys Posted on 2011-08-11 00:54:29.0Z
Sender: 23b2.4e4327e4.1804289383@sybase.com
From: Jean-Pierre Dareys
Newsgroups: sybase.public.ase.general
Subject: Sybase ASE CE questions from a newbie
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e432845.23c4.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Aug 2011 17:54:29 -0700
X-Trace: forums-1-dub 1313024069 10.22.241.41 (10 Aug 2011 17:54:29 -0700)
X-Original-Trace: 10 Aug 2011 17:54:29 -0700, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30464
Article PK: 72643

Greetings,

I was with a client a few days ago and the following
questions came up with regards to Sybase HA CE.

First, our asumptions:

1. Two nodes A and B and two ASE servers (both in up and
running)
2. Independent set of disks for each node (not necessary but
possible).
3. Shared disks for both nodes. Where the database(s)
reside.
4. One database residing on the shared disks.
5. In the case of a crash of node A, node B, running,
onlines
the shared disk, and the running ASE engine on node B,
onlines the shared database. All of this, automatically?

Second, my questions:

1. It sounds like the disk that is shared between nodes A
and B
is is a single point of failure. What can be done to
ensure
it´s availability and is it part of Sybase ASE HA CE?

The customer is considering Oracle RAC, as well as pure
hardware
mirroring at a distance of 10K using fiber optics.
Apparently, seconds to failover.

Thank you for your time and help.

Jean-Pierre

P.S. Sounds like the good old days. LOL


Jean-Pierre Dareys Posted on 2011-08-11 15:07:52.0Z
Sender: 68c6.4e43f038.1804289383@sybase.com
From: Jean-Pierre Dareys
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase ASE CE questions from a newbie
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e43f048.68ce.1681692777@sybase.com>
References: <4e432845.23c4.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Aug 2011 08:07:52 -0700
X-Trace: forums-1-dub 1313075272 10.22.241.41 (11 Aug 2011 08:07:52 -0700)
X-Original-Trace: 11 Aug 2011 08:07:52 -0700, 10.22.241.41
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30465
Article PK: 72644

The question remains the same. I am just writting to correct
the
product name. It is ASE 15.5 CE (cluster Edition)

> Greetings,
>
> I was with a client a few days ago and the following
> questions came up with regards to Sybase HA CE.
>
> First, our asumptions:
>
> 1. Two nodes A and B and two ASE servers (both in up and
> running)
> 2. Independent set of disks for each node (not necessary
> but
> possible).
> 3. Shared disks for both nodes. Where the database(s)
> reside.
> 4. One database residing on the shared disks.
> 5. In the case of a crash of node A, node B, running,
> onlines
> the shared disk, and the running ASE engine on node B,
> onlines the shared database. All of this,
> automatically?
>
> Second, my questions:
>
> 1. It sounds like the disk that is shared between nodes A
> and B
> is is a single point of failure. What can be done to
> ensure
> it´s availability and is it part of Sybase ASE HA CE?
>
> The customer is considering Oracle RAC, as well as pure
> hardware
> mirroring at a distance of 10K using fiber optics.
> Apparently, seconds to failover.
>
> Thank you for your time and help.
>
> Jean-Pierre
>
> P.S. Sounds like the good old days. LOL


Jean-Pierre Dareys Posted on 2011-08-12 15:26:24.0Z
Sender: 6567.4e454581.1804289383@sybase.com
From: Jean-Pierre Dareys
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase ASE CE questions from a newbie
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e454620.65a5.1681692777@sybase.com>
References: <4e43f048.68ce.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Aug 2011 08:26:24 -0700
X-Trace: forums-1-dub 1313162784 10.22.241.41 (12 Aug 2011 08:26:24 -0700)
X-Original-Trace: 12 Aug 2011 08:26:24 -0700, 10.22.241.41
Lines: 92
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30466
Article PK: 72645

I got the following answer from Dr. Mich Talebzadeh on the
ISUG Web site:

Dr. Mich Talebzadeh
Sybase ASE 15 Gold Medal Award 2008

Mich Talebzadeh, A Winning Strategy: Running the most
Critical Financial Data on ASE 15
http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf

http://www.google.co.uk/search?hl=en&q=mich+talebzadeh+business+intelligence+sybase&meta=
http://www.sybase.com/linux

A-> Well in CE situation both node A and node B can access
and use the shared database residing on shared disks. Oracle
RAC and Sybase CE areboth greared for scalability (although
these are more often used for high availability than
scalability these days). When one node goes offthe database
is still accecible by the other node and depending on theset
up the threads connected to node A fail over to node B.

A-> The shared disks can be mirrored at the hardware level
just the oldtraditional way so there should be no single
point of failure.

A-> I believe hardware mirroring is a vialble solution where
HA is concerned.Remember we are talking about HA as opposed
to SCALABILITY here. A goodexample of hardware mirroring is
using Sun Solaris with SRDF where all ASE disks bar tempdb
devices are mirrored. SRDF also introduces its
ownoverhead/latency however, that is is another discussion.
Harwaremirroring works quite well with more proven
technology and in my opinion
judging by the level of expertise that both Oracle RAC and
ASE CE
require, Harware Mirroring is a desirable option for HA.

Mi coment:

R--> Agreed, but more expensive. Hence the compromise.
Sybase ASE CE and hardware mirroring of the shared disk.

Any feedback from anyone else?

Thank you.

Jean-Pierre

> The question remains the same. I am just writting to
> correct the
> product name. It is ASE 15.5 CE (cluster Edition)
>
> > Greetings,
> >
> > I was with a client a few days ago and the following
> > questions came up with regards to Sybase HA CE.
> >
> > First, our asumptions:
> >
> > 1. Two nodes A and B and two ASE servers (both in up and
> > running)
> > 2. Independent set of disks for each node (not necessary
> > but
> > possible).
> > 3. Shared disks for both nodes. Where the database(s)
> > reside.
> > 4. One database residing on the shared disks.
> > 5. In the case of a crash of node A, node B, running,
> > onlines
> > the shared disk, and the running ASE engine on node B
> > , onlines the shared database. All of this,
> > automatically?
> >
> > Second, my questions:
> >
> > 1. It sounds like the disk that is shared between nodes
> > A and B
> > is is a single point of failure. What can be done to
> > ensure
> > it´s availability and is it part of Sybase ASE HA
CE?
> >
> > The customer is considering Oracle RAC, as well as pure
> > hardware
> > mirroring at a distance of 10K using fiber optics.
> > Apparently, seconds to failover.
> >
> > Thank you for your time and help.
> >
> > Jean-Pierre
> >
> > P.S. Sounds like the good old days. LOL