SYBASE ASE HA Configuration

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
chandra sekaranconsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe WoodhousePrincipal ConsultantCommented:
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
chandra sekaranconsultantAuthor Commented:
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
Joe WoodhousePrincipal ConsultantCommented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

chandra sekaranconsultantAuthor Commented:
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
Joe WoodhousePrincipal ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chandra sekaranconsultantAuthor Commented:
Thanks Joe.

Regards
CS
0
chandra sekaranconsultantAuthor Commented:
Thanks.
0
Joe WoodhousePrincipal ConsultantCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.