Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SYBASE ASE HA Configuration

Posted on 2014-10-15
8
Medium Priority
?
492 Views
Last Modified: 2014-10-26
Hi
 
I have few questions on Sybase ASE HA configuration on Solaris OS cluster environment. Has anyone there worked with ASE HA and could help me on this please?
 
thanks
CS
0
Comment
Question by:chandra sekaran
  • 4
  • 4
8 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 40386044
I've worked with ASE HA under both Solaris Cluster and HP ServiceGuard, although not in the last few versions of ASE.

I remember my main frustrations being having to take manual steps any time we wanted to bring ASE down in a controlled way without causing a failover. Frustrating because those require SysAdmin privileges that DBAs don't have, meaning any DBA task now becomes a DBA + SA task.

The manuals do in fact have everything you need to make this work, as I recall, but I haven't had occasion to look at them since ASE 12.5 for HA so a lot might have changed.

What are your questions?
0
 

Author Comment

by:chandra sekaran
ID: 40386519
Thanks Joe. Actually my question are about latest version of ASE HA. I hope you can help me on this.

1. Recommended latest ASE HA version & Solaris Cluster version  for ASE HA environment?
2. Recommended Device type for ASE database on a cluster environment - File System or Raw device?
3. Can we use ASE HA monitoring  script on a Active-Passive (single node failure) cluster environment (no companion server)?
4. Do we require LVM to manage database devices?
5. which is the best setup option for the client to move between primary and secondary node - logical hostname or floating ip?

Thanks in advance.

Regards
CS
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 40386575
1. Any supported version should be fine. I haven't heard anything bad about ASE 16 but it's not nearly as well tested or patched as ASE 15.7. I'd go with the most recent SP for ASE 15.7.

2. I think the OS clustering dictates this. Can Sun Cluster failover raw partitions from one node of the cluster to the other? As I said it's been a while since I touched it but I thought it could only do that for global file systems.

These days there isn't a lot of reason to pick raw over file. Yes it's still the fastest but compared to ufs with directio the difference is now small. The convenience of files is maybe worth it.

3. I'm not sure I understand your question; in Active-Passive the Passive is the companion server.

4. LVM never necessary but it makes dealing with raw partitions tremendously easier. I'm not sure it's required for file system devices.

5. No real reason to pick one or the other, both rely on DNS to propagate the changes. I know some sites do fancy things with F5 load balancers to redirect client connections.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:chandra sekaran
ID: 40391942
Thanks for your tips Joe.

In our configuration, Sybase ASE would be running on only one node (primary) . It will failover to secondary node in case of  primary node failure. So, I am not sure whether we need to still configure these nodes as companion server,
Whether we can still use ASE HA scripts to monitor this environment.

Regards
CS
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 1500 total points
ID: 40404470
Ah I see what you mean. No, in your scenario there is only ever one ASE, it just moves between hosts as part of failover and failback. No companion server needed.

In active-passive mode most of the work is done by SunCluster. You still need some of the ASE HA scripts to properly define and monitor your ASE so SunCluster can do the work of failover. Same deal if you're using Veritas. There's very little you need to do at the ASE level.
0
 

Author Comment

by:chandra sekaran
ID: 40404518
Thanks Joe.

Regards
CS
0
 

Author Closing Comment

by:chandra sekaran
ID: 40404519
Thanks.
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 40404522
Happy to help! The ASE HA manuals are a little light on details but that's because most of the work is done by the O/S clustering. If you define an ASE as a combination of cluster resources - a hostname/IP, a disk group, a few other bits and pieces - it's fairly straightforward with SunCluster. Veritas is much the same.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question