Solved

SYBASE ASE HA Configuration

Posted on 2014-10-15
8
380 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
We need a new way to communicate time sensitive or critical info.   The best part of my role at xMatters is visiting our clients all over the world to learn about how they operate their businesses, share insights that xMatters has gleaned across…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now