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.

few questions

14 posts in Cluster Last posting was on 2008-12-30 18:00:39.0Z
Newbie Posted on 2008-10-28 09:05:13.0Z
Sender: d57.4906bd13.1804289383@sybase.com
From: newbie
Newsgroups: sybase.public.ase.cluster
Subject: few questions
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4906d5c9.1083.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Oct 2008 01:05:13 -0800
X-Trace: forums-1-dub 1225184713 10.22.241.41 (28 Oct 2008 01:05:13 -0800)
X-Original-Trace: 28 Oct 2008 01:05:13 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:98
Article PK: 48380

hello,

cluster edition is free for download? at least for a trial
version? I am Sybase customer but licensed for Enterprise
edition

what are the pros/cons of using ASE CE vs ASE Enteprise +
veritas/Sun cluster/networker for HA??

thank you


Rob Verschoor [Sybase] Posted on 2008-10-28 10:04:29.0Z
Reply-To: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
From: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.cluster
References: <4906d5c9.1083.1681692777@sybase.com>
Subject: Re: few questions
Lines: 42
Organization: Sybase Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4906e3ad@forums-1-dub>
Date: 28 Oct 2008 02:04:29 -0800
X-Trace: forums-1-dub 1225188269 10.22.241.152 (28 Oct 2008 02:04:29 -0800)
X-Original-Trace: 28 Oct 2008 02:04:29 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:99
Article PK: 48382

There is no free download of ASE CE. You should speak to your Sybase sales
contact to obtain a trial license.
A major difference between CE and a Sun Cluster-based system is that ASE CE
handles all cluster membership issues etc. itself; no separate clusterware
(like Sun Cluster) is needed, making the overall system cheaper and simpler.
Also, ASE CE allows multiple ASE servers, each running on a different
cluster node (these ASE servers are called 'instances'), to access the same
data in the same databases concurrently.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<newbie> wrote in message news:4906d5c9.1083.1681692777@sybase.com...
> hello,
>
> cluster edition is free for download? at least for a trial
> version? I am Sybase customer but licensed for Enterprise
> edition
>
> what are the pros/cons of using ASE CE vs ASE Enteprise +
> veritas/Sun cluster/networker for HA??
>
> thank you


Chris N. Brown Posted on 2008-11-03 22:07:15.0Z
From: "Chris N. Brown" <chris.dot.brown@sybase.dot.com>
Subject: Re: few questions
Newsgroups: sybase.public.ase.cluster
References: <4906e3ad@forums-1-dub> <490ea53e.4882.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: <490f7613$1@forums-1-dub>
Date: 3 Nov 2008 14:07:15 -0800
X-Trace: forums-1-dub 1225750035 10.22.241.152 (3 Nov 2008 14:07:15 -0800)
X-Original-Trace: 3 Nov 2008 14:07:15 -0800, vip152.sybase.com
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:101
Article PK: 48383


On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:

> my objective is that when a ASE crashes, another stays online and
> service is not interrupted. The other server can be on a different
> physical site or since we should have a shared disk, the 2 servers must
> be in the same site?
>
> thank you.

Just a few thoughts come to mind, because you can achieve what you are
looking for in multiple ways -- it all depends on the service level
agreement (uptime) that you want.

Keep in mind, you can come back online in the same datacenter, or in a
different one. ASE CE isn't designed to be used cross-datacenter at this
time, so if you wanted to come up on a different ASE running in a
different data center then you'd want to investigate either replication
server, Mirror Activator, disk-based replication, dump-and-load, or
something along that line to bring a separate instance up and running
(and to keep the secondary copy in-sync).

If you wanted fast-failover within the same datacenter, then you'd likely
want to look at some sort of clustering solution, and ASE CE could be a
good fit ... but without knowing more about your installation or needs I
hate to make blind recommendations. Is this a mission-critical, 24x7
uptime type of system or can you take it down here and there? what is
the impact to the business if the app goes down in the middle of the day
(or at different times of the month)? All of these would likely help you
with your decision of what architecture to implement, and using what
products.


HTH,
Chris


Newbie Posted on 2008-11-07 11:31:35.0Z
Sender: 792f.49132305.1804289383@sybase.com
From: newbie
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49142717.1953.1681692777@sybase.com>
References: <490f7613$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Nov 2008 03:31:35 -0800
X-Trace: forums-1-dub 1226057495 10.22.241.41 (7 Nov 2008 03:31:35 -0800)
X-Original-Trace: 7 Nov 2008 03:31:35 -0800, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:102
Article PK: 48384

ASE CE also servers as a load balancer?


J Posted on 2008-11-07 18:37:05.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
Reply-To: J@bogusemailAddress.com
Message-ID: <49148a7f.8508063@forums.sybase.com>
References: <490f7613$1@forums-1-dub> <49142717.1953.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Nov 2008 10:37:05 -0800
X-Trace: forums-1-dub 1226083025 10.22.241.152 (7 Nov 2008 10:37:05 -0800)
X-Original-Trace: 7 Nov 2008 10:37:05 -0800, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:103
Article PK: 48385

On 7 Nov 2008 03:31:35 -0800, newbie wrote:

Yes. Here is a pointer to a presentation. I size to 125% to make more
readable. Look at the Workload manager, login distribution section.
You have a great deal of control over how the work is distributed in
the cluster.

Jay

>ASE CE also servers as a load balancer?


J Posted on 2008-11-07 18:37:44.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
Reply-To: J@bogusemailAddress.com
Message-ID: <49148ad6.8594638@forums.sybase.com>
References: <490f7613$1@forums-1-dub> <49142717.1953.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Nov 2008 10:37:44 -0800
X-Trace: forums-1-dub 1226083064 10.22.241.152 (7 Nov 2008 10:37:44 -0800)
X-Original-Trace: 7 Nov 2008 10:37:44 -0800, vip152.sybase.com
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:104
Article PK: 48386

On 7 Nov 2008 03:31:35 -0800, newbie wrote:

OOP forgot the pointer: http://www.sybase.com/detail?id=1058003


>ASE CE also servers as a load balancer?


IQRules Posted on 2008-12-19 01:15:25.0Z
From: IQRules <IQRules@nospam.com>
User-Agent: Thunderbird 2.0.0.18 (X11/20081125)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub>
In-Reply-To: <490f7613$1@forums-1-dub>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494af5ad@forums-1-dub>
Date: 18 Dec 2008 17:15:25 -0800
X-Trace: forums-1-dub 1229649325 10.22.241.152 (18 Dec 2008 17:15:25 -0800)
X-Original-Trace: 18 Dec 2008 17:15:25 -0800, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:107
Article PK: 48390


Chris N. Brown wrote:
> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>
>> my objective is that when a ASE crashes, another stays online and
>> service is not interrupted. The other server can be on a different
>> physical site or since we should have a shared disk, the 2 servers must
>> be in the same site?
>>
>> thank you.
>
>
> Just a few thoughts come to mind, because you can achieve what you are
> looking for in multiple ways -- it all depends on the service level
> agreement (uptime) that you want.
>
> Keep in mind, you can come back online in the same datacenter, or in a
> different one. ASE CE isn't designed to be used cross-datacenter at this
> time, so if you wanted to come up on a different ASE running in a
> different data center then you'd want to investigate either replication
> server, Mirror Activator, disk-based replication, dump-and-load, or
> something along that line to bring a separate instance up and running
> (and to keep the secondary copy in-sync).
>
> If you wanted fast-failover within the same datacenter, then you'd likely

Just went through some Docs here. I wonder is it needed to be in some
sort of private network interconnect or infiniband together?

So are nodes in same sub-net and need to be cluster hardware here?

It is puzzle me, there is no 'ifconfig' sample output in the Docs.

> want to look at some sort of clustering solution, and ASE CE could be a
> good fit ... but without knowing more about your installation or needs I
> hate to make blind recommendations. Is this a mission-critical, 24x7
> uptime type of system or can you take it down here and there? what is
> the impact to the business if the app goes down in the middle of the day
> (or at different times of the month)? All of these would likely help you
> with your decision of what architecture to implement, and using what
> products.
>
>
> HTH,
> Chris
>


J Posted on 2008-12-19 16:09:53.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
Reply-To: J@bogusemailAddress.com
Message-ID: <494bc43f.580024@forums.sybase.com>
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 19 Dec 2008 08:09:53 -0800
X-Trace: forums-1-dub 1229702993 10.22.241.152 (19 Dec 2008 08:09:53 -0800)
X-Original-Trace: 19 Dec 2008 08:09:53 -0800, vip152.sybase.com
Lines: 111
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:108
Article PK: 48389

On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:

The instances (ASEs) on the nodes (hardware boxes) communicate with
each other thru a private network and have to share disks accessable
from all instances. The here is the ifconfig of a hardware setup I
have, where there is a primary private network and a secondary private
network. The networks are just ethernet connected to a switch box.
GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
support Infiniband on some platforms (IPolB) Linux. Check Install
Guides and Release Bulletins, Sales for latest news.

ifconfig (just the private networks):

<instance1> ifconfig:

eth2 Link encap:Ethernet HWaddr 00:15:17:76:84:4A
inet addr:192.168.1.1 Bcast:192.168.1.255
Mask:255.255.255.0
inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:100
RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
Base address:0xdce0 Memory:fc5e0000-fc600000

eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
inet addr:192.168.2.1 Bcast:192.168.2.255
Mask:255.255.255.0
inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:100

<instance2> ifconfig:

eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
inet addr:192.168.1.2 Bcast:192.168.1.255
Mask:255.255.255.0
inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
Base address:0xdce0 Memory:fc5e0000-fc600000

eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
inet addr:192.168.2.2 Bcast:192.168.2.255
Mask:255.255.255.0
inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:100
RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
Base address:0xdcc0 Memory:fc5a0000-fc5c0000

Jay
RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
Base address:0xdcc0 Memory:fc5a0000-fc5c0000

>Chris N. Brown wrote:
>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>
>>> my objective is that when a ASE crashes, another stays online and
>>> service is not interrupted. The other server can be on a different
>>> physical site or since we should have a shared disk, the 2 servers must
>>> be in the same site?
>>>
>>> thank you.
>>
>>
>> Just a few thoughts come to mind, because you can achieve what you are
>> looking for in multiple ways -- it all depends on the service level
>> agreement (uptime) that you want.
>>
>> Keep in mind, you can come back online in the same datacenter, or in a
>> different one. ASE CE isn't designed to be used cross-datacenter at this
>> time, so if you wanted to come up on a different ASE running in a
>> different data center then you'd want to investigate either replication
>> server, Mirror Activator, disk-based replication, dump-and-load, or
>> something along that line to bring a separate instance up and running
>> (and to keep the secondary copy in-sync).
>>
>> If you wanted fast-failover within the same datacenter, then you'd likely
>
>Just went through some Docs here. I wonder is it needed to be in some
>sort of private network interconnect or infiniband together?
>
>So are nodes in same sub-net and need to be cluster hardware here?
>
>It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>
>> want to look at some sort of clustering solution, and ASE CE could be a
>> good fit ... but without knowing more about your installation or needs I
>> hate to make blind recommendations. Is this a mission-critical, 24x7
>> uptime type of system or can you take it down here and there? what is
>> the impact to the business if the app goes down in the middle of the day
>> (or at different times of the month)? All of these would likely help you
>> with your decision of what architecture to implement, and using what
>> products.
>>
>>
>> HTH,
>> Chris
>>


IQRules Posted on 2008-12-19 23:12:23.0Z
From: IQRules <IQRules@nospam.com>
User-Agent: Thunderbird 2.0.0.18 (X11/20081125)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub> <494bc43f.580024@forums.sybase.com>
In-Reply-To: <494bc43f.580024@forums.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494c2a57@forums-1-dub>
Date: 19 Dec 2008 15:12:23 -0800
X-Trace: forums-1-dub 1229728343 10.22.241.152 (19 Dec 2008 15:12:23 -0800)
X-Original-Trace: 19 Dec 2008 15:12:23 -0800, vip152.sybase.com
Lines: 117
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:109
Article PK: 48391

So technically, the hardware requirement is way lower than using Sun
Cluster 3.1/3.2 or Veritas VCS 4.X solutions?

And compare to Oracle RAC, can Sybase CE run on less expensive hardware?

Do you have any study on 100M NIC or GigaBit or Infiniband with Sybase CE?

J wrote:
> On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:
>
> The instances (ASEs) on the nodes (hardware boxes) communicate with
> each other thru a private network and have to share disks accessable
> from all instances. The here is the ifconfig of a hardware setup I
> have, where there is a primary private network and a secondary private
> network. The networks are just ethernet connected to a switch box.
> GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
> support Infiniband on some platforms (IPolB) Linux. Check Install
> Guides and Release Bulletins, Sales for latest news.
>
> ifconfig (just the private networks):
>
> <instance1> ifconfig:
>
> eth2 Link encap:Ethernet HWaddr 00:15:17:76:84:4A
> inet addr:192.168.1.1 Bcast:192.168.1.255
> Mask:255.255.255.0
> inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
> RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
> TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
> collisions:0 txqueuelen:100
> RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
> Base address:0xdce0 Memory:fc5e0000-fc600000
>
> eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
> inet addr:192.168.2.1 Bcast:192.168.2.255
> Mask:255.255.255.0
> inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
> RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
> TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
> collisions:0 txqueuelen:100
>
> <instance2> ifconfig:
>
> eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
> inet addr:192.168.1.2 Bcast:192.168.1.255
> Mask:255.255.255.0
> inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
> RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
> TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
> collisions:0 txqueuelen:1000
> RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
> Base address:0xdce0 Memory:fc5e0000-fc600000
>
> eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
> inet addr:192.168.2.2 Bcast:192.168.2.255
> Mask:255.255.255.0
> inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
> RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
> TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
> collisions:0 txqueuelen:100
> RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>
> Jay
> RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>
>
>
>> Chris N. Brown wrote:
>>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>>
>>>> my objective is that when a ASE crashes, another stays online and
>>>> service is not interrupted. The other server can be on a different
>>>> physical site or since we should have a shared disk, the 2 servers must
>>>> be in the same site?
>>>>
>>>> thank you.
>>>
>>> Just a few thoughts come to mind, because you can achieve what you are
>>> looking for in multiple ways -- it all depends on the service level
>>> agreement (uptime) that you want.
>>>
>>> Keep in mind, you can come back online in the same datacenter, or in a
>>> different one. ASE CE isn't designed to be used cross-datacenter at this
>>> time, so if you wanted to come up on a different ASE running in a
>>> different data center then you'd want to investigate either replication
>>> server, Mirror Activator, disk-based replication, dump-and-load, or
>>> something along that line to bring a separate instance up and running
>>> (and to keep the secondary copy in-sync).
>>>
>>> If you wanted fast-failover within the same datacenter, then you'd likely
>> Just went through some Docs here. I wonder is it needed to be in some
>> sort of private network interconnect or infiniband together?
>>
>> So are nodes in same sub-net and need to be cluster hardware here?
>>
>> It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>>
>>> want to look at some sort of clustering solution, and ASE CE could be a
>>> good fit ... but without knowing more about your installation or needs I
>>> hate to make blind recommendations. Is this a mission-critical, 24x7
>>> uptime type of system or can you take it down here and there? what is
>>> the impact to the business if the app goes down in the middle of the day
>>> (or at different times of the month)? All of these would likely help you
>>> with your decision of what architecture to implement, and using what
>>> products.
>>>
>>>
>>> HTH,
>>> Chris
>>>
>


J Posted on 2008-12-22 17:30:54.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
Reply-To: J@bogusemailAddress.com
Message-ID: <494fce9f.3171320@forums.sybase.com>
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub> <494bc43f.580024@forums.sybase.com> <494c2a57@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 22 Dec 2008 09:30:54 -0800
X-Trace: forums-1-dub 1229967054 10.22.241.152 (22 Dec 2008 09:30:54 -0800)
X-Original-Trace: 22 Dec 2008 09:30:54 -0800, vip152.sybase.com
Lines: 126
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:110
Article PK: 48392

On 19 Dec 2008 15:12:23 -0800, IQRules <IQRules@nospam.com> wrote:

I don't have any studies for this. The sales guys may have some
information and I think if you contact them perhaps they have what you
are looking for.

J

>So technically, the hardware requirement is way lower than using Sun
>Cluster 3.1/3.2 or Veritas VCS 4.X solutions?
>
>And compare to Oracle RAC, can Sybase CE run on less expensive hardware?
>
>Do you have any study on 100M NIC or GigaBit or Infiniband with Sybase CE?
>
>J wrote:
>> On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:
>>
>> The instances (ASEs) on the nodes (hardware boxes) communicate with
>> each other thru a private network and have to share disks accessable
>> from all instances. The here is the ifconfig of a hardware setup I
>> have, where there is a primary private network and a secondary private
>> network. The networks are just ethernet connected to a switch box.
>> GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
>> support Infiniband on some platforms (IPolB) Linux. Check Install
>> Guides and Release Bulletins, Sales for latest news.
>>
>> ifconfig (just the private networks):
>>
>> <instance1> ifconfig:
>>
>> eth2 Link encap:Ethernet HWaddr 00:15:17:76:84:4A
>> inet addr:192.168.1.1 Bcast:192.168.1.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>> RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>
>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
>> inet addr:192.168.2.1 Bcast:192.168.2.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>>
>> <instance2> ifconfig:
>>
>> eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
>> inet addr:192.168.1.2 Bcast:192.168.1.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:1000
>> RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>
>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
>> inet addr:192.168.2.2 Bcast:192.168.2.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>> RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>
>> Jay
>> RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>
>>
>>
>>> Chris N. Brown wrote:
>>>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>>>
>>>>> my objective is that when a ASE crashes, another stays online and
>>>>> service is not interrupted. The other server can be on a different
>>>>> physical site or since we should have a shared disk, the 2 servers must
>>>>> be in the same site?
>>>>>
>>>>> thank you.
>>>>
>>>> Just a few thoughts come to mind, because you can achieve what you are
>>>> looking for in multiple ways -- it all depends on the service level
>>>> agreement (uptime) that you want.
>>>>
>>>> Keep in mind, you can come back online in the same datacenter, or in a
>>>> different one. ASE CE isn't designed to be used cross-datacenter at this
>>>> time, so if you wanted to come up on a different ASE running in a
>>>> different data center then you'd want to investigate either replication
>>>> server, Mirror Activator, disk-based replication, dump-and-load, or
>>>> something along that line to bring a separate instance up and running
>>>> (and to keep the secondary copy in-sync).
>>>>
>>>> If you wanted fast-failover within the same datacenter, then you'd likely
>>> Just went through some Docs here. I wonder is it needed to be in some
>>> sort of private network interconnect or infiniband together?
>>>
>>> So are nodes in same sub-net and need to be cluster hardware here?
>>>
>>> It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>>>
>>>> want to look at some sort of clustering solution, and ASE CE could be a
>>>> good fit ... but without knowing more about your installation or needs I
>>>> hate to make blind recommendations. Is this a mission-critical, 24x7
>>>> uptime type of system or can you take it down here and there? what is
>>>> the impact to the business if the app goes down in the middle of the day
>>>> (or at different times of the month)? All of these would likely help you
>>>> with your decision of what architecture to implement, and using what
>>>> products.
>>>>
>>>>
>>>> HTH,
>>>> Chris
>>>>
>>


Rob Verschoor [Sybase] Posted on 2008-12-29 14:47:15.0Z
Reply-To: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
From: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.cluster
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub> <494bc43f.580024@forums.sybase.com> <494c2a57@forums-1-dub>
Subject: Re: few questions
Lines: 148
Organization: Sybase Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4958e2f3@forums-1-dub>
Date: 29 Dec 2008 06:47:15 -0800
X-Trace: forums-1-dub 1230562035 10.22.241.152 (29 Dec 2008 06:47:15 -0800)
X-Original-Trace: 29 Dec 2008 06:47:15 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:111
Article PK: 48393

I'd agree with that conclusion: ASE CE doesn't require vendor-specific
clusterware (like Sun Cluster).
Currently, ASE CE doesn't work together with volume mgrs yet (so you need to
use raw devices), but integration with Veritas VCS has been announced for 1H
2009.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"IQRules" <IQRules@nospam.com> wrote in message
news:494c2a57@forums-1-dub...
> So technically, the hardware requirement is way lower than using Sun
> Cluster 3.1/3.2 or Veritas VCS 4.X solutions?
>
> And compare to Oracle RAC, can Sybase CE run on less expensive hardware?
>
> Do you have any study on 100M NIC or GigaBit or Infiniband with Sybase CE?
>
> J wrote:
>> On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:
>>
>> The instances (ASEs) on the nodes (hardware boxes) communicate with
>> each other thru a private network and have to share disks accessable
>> from all instances. The here is the ifconfig of a hardware setup I
>> have, where there is a primary private network and a secondary private
>> network. The networks are just ethernet connected to a switch box.
>> GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
>> support Infiniband on some platforms (IPolB) Linux. Check Install
>> Guides and Release Bulletins, Sales for latest news. ifconfig (just the
>> private networks):
>>
>> <instance1> ifconfig: eth2 Link encap:Ethernet HWaddr
>> 00:15:17:76:84:4A
>> inet addr:192.168.1.1 Bcast:192.168.1.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>> RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>
>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
>> inet addr:192.168.2.1 Bcast:192.168.2.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>>
>> <instance2> ifconfig:
>>
>> eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
>> inet addr:192.168.1.2 Bcast:192.168.1.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:1000
>> RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>
>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
>> inet addr:192.168.2.2 Bcast:192.168.2.255
>> Mask:255.255.255.0
>> inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>> RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
>> TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
>> collisions:0 txqueuelen:100
>> RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>
>> Jay RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>
>>
>>
>>> Chris N. Brown wrote:
>>>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>>>
>>>>> my objective is that when a ASE crashes, another stays online and
>>>>> service is not interrupted. The other server can be on a different
>>>>> physical site or since we should have a shared disk, the 2 servers
>>>>> must
>>>>> be in the same site?
>>>>>
>>>>> thank you.
>>>>
>>>> Just a few thoughts come to mind, because you can achieve what you are
>>>> looking for in multiple ways -- it all depends on the service level
>>>> agreement (uptime) that you want.
>>>>
>>>> Keep in mind, you can come back online in the same datacenter, or in a
>>>> different one. ASE CE isn't designed to be used cross-datacenter at
>>>> this time, so if you wanted to come up on a different ASE running in a
>>>> different data center then you'd want to investigate either replication
>>>> server, Mirror Activator, disk-based replication, dump-and-load, or
>>>> something along that line to bring a separate instance up and running
>>>> (and to keep the secondary copy in-sync).
>>>>
>>>> If you wanted fast-failover within the same datacenter, then you'd
>>>> likely
>>> Just went through some Docs here. I wonder is it needed to be in some
>>> sort of private network interconnect or infiniband together?
>>>
>>> So are nodes in same sub-net and need to be cluster hardware here?
>>>
>>> It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>>>
>>>> want to look at some sort of clustering solution, and ASE CE could be a
>>>> good fit ... but without knowing more about your installation or needs
>>>> I hate to make blind recommendations. Is this a mission-critical, 24x7
>>>> uptime type of system or can you take it down here and there? what is
>>>> the impact to the business if the app goes down in the middle of the
>>>> day (or at different times of the month)? All of these would likely
>>>> help you with your decision of what architecture to implement, and
>>>> using what products.
>>>>
>>>>
>>>> HTH,
>>>> Chris
>>>>
>>


IQRules Posted on 2008-12-30 15:23:18.0Z
From: IQRules <IQRules@nospam.com>
User-Agent: Thunderbird 2.0.0.18 (X11/20081125)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.cluster
Subject: Re: few questions
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub> <494bc43f.580024@forums.sybase.com> <494c2a57@forums-1-dub> <4958e2f3@forums-1-dub>
In-Reply-To: <4958e2f3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <495a3ce6@forums-1-dub>
Date: 30 Dec 2008 07:23:18 -0800
X-Trace: forums-1-dub 1230650598 10.22.241.152 (30 Dec 2008 07:23:18 -0800)
X-Original-Trace: 30 Dec 2008 07:23:18 -0800, vip152.sybase.com
Lines: 152
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:112
Article PK: 48394

Can Sybase clearly document what choices are out there such as Sun
Volume Manager /dev/md/rdsk/ , and how about on RedHat 5.1?

Thanks

Rob Verschoor [Sybase] wrote:
> I'd agree with that conclusion: ASE CE doesn't require vendor-specific
> clusterware (like Sun Cluster).
> Currently, ASE CE doesn't work together with volume mgrs yet (so you need to
> use raw devices), but integration with Veritas VCS has been announced for 1H
> 2009.
>
> HTH,
>
> Rob V.
> -----------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
> and Replication Server 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at www.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., Amersfoort, The Netherlands
> Chamber of Commerce 27138666
> -----------------------------------------------------------------
>
>
> "IQRules" <IQRules@nospam.com> wrote in message
> news:494c2a57@forums-1-dub...
>> So technically, the hardware requirement is way lower than using Sun
>> Cluster 3.1/3.2 or Veritas VCS 4.X solutions?
>>
>> And compare to Oracle RAC, can Sybase CE run on less expensive hardware?
>>
>> Do you have any study on 100M NIC or GigaBit or Infiniband with Sybase CE?
>>
>> J wrote:
>>> On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:
>>>
>>> The instances (ASEs) on the nodes (hardware boxes) communicate with
>>> each other thru a private network and have to share disks accessable
>>> from all instances. The here is the ifconfig of a hardware setup I
>>> have, where there is a primary private network and a secondary private
>>> network. The networks are just ethernet connected to a switch box.
>>> GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
>>> support Infiniband on some platforms (IPolB) Linux. Check Install
>>> Guides and Release Bulletins, Sales for latest news. ifconfig (just the
>>> private networks):
>>>
>>> <instance1> ifconfig: eth2 Link encap:Ethernet HWaddr
>>> 00:15:17:76:84:4A
>>> inet addr:192.168.1.1 Bcast:192.168.1.255
>>> Mask:255.255.255.0
>>> inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>> RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
>>> TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
>>> collisions:0 txqueuelen:100
>>> RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
>>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>>
>>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
>>> inet addr:192.168.2.1 Bcast:192.168.2.255
>>> Mask:255.255.255.0
>>> inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>> RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
>>> TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
>>> collisions:0 txqueuelen:100
>>>
>>> <instance2> ifconfig:
>>>
>>> eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
>>> inet addr:192.168.1.2 Bcast:192.168.1.255
>>> Mask:255.255.255.0
>>> inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>> RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
>>> TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
>>> collisions:0 txqueuelen:1000
>>> RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
>>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>>
>>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
>>> inet addr:192.168.2.2 Bcast:192.168.2.255
>>> Mask:255.255.255.0
>>> inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>> RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
>>> TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
>>> collisions:0 txqueuelen:100
>>> RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
>>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>>
>>> Jay RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
>>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>>
>>>
>>>
>>>> Chris N. Brown wrote:
>>>>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>>>>
>>>>>> my objective is that when a ASE crashes, another stays online and
>>>>>> service is not interrupted. The other server can be on a different
>>>>>> physical site or since we should have a shared disk, the 2 servers
>>>>>> must
>>>>>> be in the same site?
>>>>>>
>>>>>> thank you.
>>>>> Just a few thoughts come to mind, because you can achieve what you are
>>>>> looking for in multiple ways -- it all depends on the service level
>>>>> agreement (uptime) that you want.
>>>>>
>>>>> Keep in mind, you can come back online in the same datacenter, or in a
>>>>> different one. ASE CE isn't designed to be used cross-datacenter at
>>>>> this time, so if you wanted to come up on a different ASE running in a
>>>>> different data center then you'd want to investigate either replication
>>>>> server, Mirror Activator, disk-based replication, dump-and-load, or
>>>>> something along that line to bring a separate instance up and running
>>>>> (and to keep the secondary copy in-sync).
>>>>>
>>>>> If you wanted fast-failover within the same datacenter, then you'd
>>>>> likely
>>>> Just went through some Docs here. I wonder is it needed to be in some
>>>> sort of private network interconnect or infiniband together?
>>>>
>>>> So are nodes in same sub-net and need to be cluster hardware here?
>>>>
>>>> It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>>>>
>>>>> want to look at some sort of clustering solution, and ASE CE could be a
>>>>> good fit ... but without knowing more about your installation or needs
>>>>> I hate to make blind recommendations. Is this a mission-critical, 24x7
>>>>> uptime type of system or can you take it down here and there? what is
>>>>> the impact to the business if the app goes down in the middle of the
>>>>> day (or at different times of the month)? All of these would likely
>>>>> help you with your decision of what architecture to implement, and
>>>>> using what products.
>>>>>
>>>>>
>>>>> HTH,
>>>>> Chris
>>>>>
>
>
>


Rob Verschoor [Sybase] Posted on 2008-12-30 18:00:39.0Z
Reply-To: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
From: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.cluster
References: <4906e3ad@forums-1-dub> <490ea53e.4882.1681692777@sybase.com> <490f7613$1@forums-1-dub> <494af5ad@forums-1-dub> <494bc43f.580024@forums.sybase.com> <494c2a57@forums-1-dub> <4958e2f3@forums-1-dub> <495a3ce6@forums-1-dub>
Subject: Re: few questions
Lines: 188
Organization: Sybase Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <495a61c7@forums-1-dub>
Date: 30 Dec 2008 10:00:39 -0800
X-Trace: forums-1-dub 1230660039 10.22.241.152 (30 Dec 2008 10:00:39 -0800)
X-Original-Trace: 30 Dec 2008 10:00:39 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:113
Article PK: 48395

I think that's documented in the installation guide for ASE Cluster Edition.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"IQRules" <IQRules@nospam.com> wrote in message
news:495a3ce6@forums-1-dub...
> Can Sybase clearly document what choices are out there such as Sun Volume
> Manager /dev/md/rdsk/ , and how about on RedHat 5.1?
>
> Thanks
>
> Rob Verschoor [Sybase] wrote:
>> I'd agree with that conclusion: ASE CE doesn't require vendor-specific
>> clusterware (like Sun Cluster).
>> Currently, ASE CE doesn't work together with volume mgrs yet (so you need
>> to
>> use raw devices), but integration with Veritas VCS has been announced for
>> 1H
>> 2009.
>>
>> HTH,
>>
>> Rob V.
>> -----------------------------------------------------------------
>> Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
>> and Replication Server 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at www.sypron.nl/shop):
>> "Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
>> "The Complete Sybase ASE Quick Reference Guide"
>> "The Complete Sybase Replication Server Quick Reference Guide"
>>
>> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
>> http://www.sypron.nl
>> Sypron B.V., Amersfoort, The Netherlands
>> Chamber of Commerce 27138666
>> -----------------------------------------------------------------
>>
>>
>> "IQRules" <IQRules@nospam.com> wrote in message
>> news:494c2a57@forums-1-dub...
>>> So technically, the hardware requirement is way lower than using Sun
>>> Cluster 3.1/3.2 or Veritas VCS 4.X solutions?
>>>
>>> And compare to Oracle RAC, can Sybase CE run on less expensive hardware?
>>>
>>> Do you have any study on 100M NIC or GigaBit or Infiniband with Sybase
>>> CE?
>>>
>>> J wrote:
>>>> On 18 Dec 2008 17:15:25 -0800, IQRules <IQRules@nospam.com> wrote:
>>>>
>>>> The instances (ASEs) on the nodes (hardware boxes) communicate with
>>>> each other thru a private network and have to share disks accessable
>>>> from all instances. The here is the ifconfig of a hardware setup I
>>>> have, where there is a primary private network and a secondary private
>>>> network. The networks are just ethernet connected to a switch box.
>>>> GigaBit Ethernet (GbE) is common, low cost. Cluster Edition does
>>>> support Infiniband on some platforms (IPolB) Linux. Check Install
>>>> Guides and Release Bulletins, Sales for latest news. ifconfig (just the
>>>> private networks):
>>>>
>>>> <instance1> ifconfig: eth2 Link encap:Ethernet HWaddr
>>>> 00:15:17:76:84:4A
>>>> inet addr:192.168.1.1 Bcast:192.168.1.255
>>>> Mask:255.255.255.0
>>>> inet6 addr: fe80::215:17ff:fe76:844a/64 Scope:Link
>>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>>> RX packets:7908455 errors:0 dropped:0 overruns:0 frame:0
>>>> TX packets:7641218 errors:0 dropped:0 overruns:0 carrier:0
>>>> collisions:0 txqueuelen:100
>>>> RX bytes:1242443597 (1.1 GiB) TX bytes:1188794096 (1.1 GiB)
>>>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>>>
>>>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:84:4B
>>>> inet addr:192.168.2.1 Bcast:192.168.2.255
>>>> Mask:255.255.255.0
>>>> inet6 addr: fe80::215:17ff:fe76:844b/64 Scope:Link
>>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>>> RX packets:1316891 errors:0 dropped:0 overruns:0 frame:0
>>>> TX packets:1113160 errors:0 dropped:0 overruns:0 carrier:0
>>>> collisions:0 txqueuelen:100
>>>>
>>>> <instance2> ifconfig:
>>>>
>>>> eth2 Link encap:Ethernet HWaddr 00:15:17:76:B3:02
>>>> inet addr:192.168.1.2 Bcast:192.168.1.255
>>>> Mask:255.255.255.0
>>>> inet6 addr: fe80::215:17ff:fe76:b302/64 Scope:Link
>>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>>> RX packets:7571952 errors:0 dropped:0 overruns:0 frame:0
>>>> TX packets:7440271 errors:0 dropped:0 overruns:0 carrier:0
>>>> collisions:0 txqueuelen:1000
>>>> RX bytes:1185645791 (1.1 GiB) TX bytes:1182320350 (1.1 GiB)
>>>> Base address:0xdce0 Memory:fc5e0000-fc600000
>>>>
>>>> eth3 Link encap:Ethernet HWaddr 00:15:17:76:B3:03
>>>> inet addr:192.168.2.2 Bcast:192.168.2.255
>>>> Mask:255.255.255.0
>>>> inet6 addr: fe80::215:17ff:fe76:b303/64 Scope:Link
>>>> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
>>>> RX packets:1316894 errors:0 dropped:0 overruns:0 frame:0
>>>> TX packets:1113105 errors:0 dropped:0 overruns:0 carrier:0
>>>> collisions:0 txqueuelen:100
>>>> RX bytes:119106108 (113.5 MiB) TX bytes:86902374 (82.8 MiB)
>>>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>>>
>>>> Jay RX bytes:119105010 (113.5 MiB) TX bytes:86904340 (82.8 MiB)
>>>> Base address:0xdcc0 Memory:fc5a0000-fc5c0000
>>>>
>>>>
>>>>
>>>>> Chris N. Brown wrote:
>>>>>> On Sun, 02 Nov 2008 23:16:14 -0800, newbie wrote:
>>>>>>
>>>>>>> my objective is that when a ASE crashes, another stays online and
>>>>>>> service is not interrupted. The other server can be on a different
>>>>>>> physical site or since we should have a shared disk, the 2 servers
>>>>>>> must
>>>>>>> be in the same site?
>>>>>>>
>>>>>>> thank you.
>>>>>> Just a few thoughts come to mind, because you can achieve what you
>>>>>> are
>>>>>> looking for in multiple ways -- it all depends on the service level
>>>>>> agreement (uptime) that you want.
>>>>>>
>>>>>> Keep in mind, you can come back online in the same datacenter, or in
>>>>>> a
>>>>>> different one. ASE CE isn't designed to be used cross-datacenter at
>>>>>> this time, so if you wanted to come up on a different ASE running in
>>>>>> a
>>>>>> different data center then you'd want to investigate either
>>>>>> replication
>>>>>> server, Mirror Activator, disk-based replication, dump-and-load, or
>>>>>> something along that line to bring a separate instance up and running
>>>>>> (and to keep the secondary copy in-sync).
>>>>>>
>>>>>> If you wanted fast-failover within the same datacenter, then you'd
>>>>>> likely
>>>>> Just went through some Docs here. I wonder is it needed to be in some
>>>>> sort of private network interconnect or infiniband together?
>>>>>
>>>>> So are nodes in same sub-net and need to be cluster hardware here?
>>>>>
>>>>> It is puzzle me, there is no 'ifconfig' sample output in the Docs.
>>>>>
>>>>>> want to look at some sort of clustering solution, and ASE CE could be
>>>>>> a
>>>>>> good fit ... but without knowing more about your installation or
>>>>>> needs
>>>>>> I hate to make blind recommendations. Is this a mission-critical,
>>>>>> 24x7
>>>>>> uptime type of system or can you take it down here and there? what
>>>>>> is
>>>>>> the impact to the business if the app goes down in the middle of the
>>>>>> day (or at different times of the month)? All of these would likely
>>>>>> help you with your decision of what architecture to implement, and
>>>>>> using what products.
>>>>>>
>>>>>>
>>>>>> HTH,
>>>>>> Chris
>>>>>>
>>
>>