Solved

SYBASE ASE HA Configuration

Posted on 2014-10-15
8
430 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

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 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Suggested Solutions

Invest in your employees with these five simple steps to improve employee engagement and retention.
How many times a day do you open, acknowledge, or close an IT incident? What’s your process? Do you have a process depending on the incident, systems involved, and other factors? New Relic Alerts gives you options for how you interact with notifica…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

738 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