Chapter 6: Managing the Workload

This chapter describes how to manage the workload and provide failover for applications accessing the Cluster Edition.

Topic

Page

Logical cluster resources

§

The system logical cluster

§

Setting up a logical cluster

§

Assigning routing rules

§

Configuring logical cluster attributes

§

Configuring failover

§

Managing logical clusters

§

Administering failover, failback, and planned downtime

§

Distributing the workload

§

Using the sample load profiles

§

Creating and configuring your own load profile

§

Troubleshooting

§

The Cluster Edition workload manager can customize workload management and failover for each of your business applications so that each performs most efficiently. The logical cluster is the container that allows the workload manager to provide individualized working environments.

A logical cluster is an abstract representation of one or more instances in a physical shared-disk cluster. Each logical cluster has a set of instances it runs on and can have a set of instances to which it fails over. Routing rules direct incoming connections to specific logical clusters based on an application, user login, or server alias supplied by the client. Other rules can restrict a logical cluster to bound connections or allow any authenticated connection to access it.

By creating logical clusters on top of the physical cluster, you can partition applications with different workloads on the same system. The workload is managed at the application level, which means that you can manage incoming connections, failover policies, load distribution strategies, and planned downtime according to how each of your applications use the system.

The system administrator manages the workload using the Adaptive Server plug-in to Sybase Central or the command-line options described in this chapter. The system administrator: