?
Solved

SYBASE ASE HA Configuration

Posted on 2014-10-15
8
Medium Priority
?
468 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
What we learned in Webroot's webinar on multi-vector protection.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

719 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