Go to main content

Data Services Reference for Oracle® Solaris Cluster 4.4

Exit Print View

Updated: November 2019
 
 

ORCL.mysql_ndbd_shutdown (7)

Name

ORCL.mysql_ndbd_shutdown, mysql_ndbd_shutdown - resource type implementation for managing MySQL Cluster data node daemon (ndbd) shutdown with HA for MySQL Cluster

Description

The ORCL.mysql_ndbd_shutdown resource type represents the MySQL Cluster ndbd shutdown instance in an Oracle Solaris Cluster HA for MySQL Cluster configuration. The resource type enables a safe shutdown of all ndbd daemons by a single clresourcegroup command.

The resource type logs the output of the Oracle MySQL Cluster start and stop functions in the /var/adm/messages file.

For more information about Oracle Solaris Cluster HA for Oracle MySQL Cluster, see Oracle Solaris Cluster Data Service for MySQL Cluster Guide.

Standard properties and extension properties that are defined for the ORCL.mysql_ndbd_shutdown resource type are described in the subsections that follow. To set these properties for an instance of the ORCL.mysql_ndbd_shutdown resource type, use the clresourcetype(8CL) command.

Standard Properties

None of the standard resources properties have been overridden for this resource type.

For a description of all standard resource properties, see the r_properties(7) man page.

Extension Properties

The Oracle MySQL Cluster resource type inherits the extension properties from SUNW.gds. For a list of the SUNW.gds standard and extension properties, see the SUNW.gds(7) man page.

The additional extension properties of the ORCL.mysql_ndbd_shutdown resource type are as follows:

Child_mon_level

This property indicates the child process monitoring level for PMF. A value of -1 specifies that the –C option to the pmfadm command is not used. A value of 0 or greater specifies using the –C option to the pmfadm command.

Per node

False

Data type

Integer

Default

-1

Range

Not applicable

Tunable

When disabled

Debug_level

This property indicates the level of logging for the GDS-based scripts.

Per node

True

Data type

Integer

Default

0

Range

0-2

Tunable

Any time

Failover_enabled

This property determines whether to fail over when Retry_count is exceeded during Retry_interval. This property is optional.

Per node

False

Data type

Boolean

Default

True

Range

Not applicable

Tunable

When disabled

Log_level

This property specifies the level of logging for GDS events. This property is optional.

Per node

False

Data type

Integer

Default

Info

Range

Not applicable

Tunable

Any time

Monitor_retry_count

This property indicates the number of PMF restarts of the fault monitor that are allowed.

Per node

False

Data type

Integer

Default

4

Range

Not applicable

Tunable

Any time

Monitor_retry_interval

This property indicates the time window (in minutes) for fault monitor restarts.

Per node

False

Data type

Integer

Default

2

Range

Not applicable

Tunable

Any time

Ndbd_resource

This property specifies the resource of the ndbd daemon.

Per node

False

Data type

String

Default

None

Minimum length

1

Tunable

When disabled

Network_aware

This property indicates whether the application uses the public network to communicate with its clients. This property is optional.

Per node

False

Data type

Boolean

Default

False

Range

Not applicable

Tunable

At creation

Probe_timeout

This property indicates the timeout value (in seconds) for the probe.

Per node

False

Data type

Integer

Minimum

2

Default

30

Range

Not applicable

Tunable

Any time

Stop_signal

This property indicates the signal that is sent to the application to be stopped. This property is optional.

Per node

False

Data type

Integer

Default

9

Range

1 - 37

Tunable

When disabled

Examples

Example 1 Creating an ORCL.mysql_ndbd_shutdown Resource

This example shows the commands to create an ORCL.mysql_ndbd_shutdown resource. These commands perform the following operations:

  • Registering ORCL.mysql_ndbd_shutdown

  • Adding the mysql_ndbd_shutdown-rs resource to the ndb-rg resource group

This example makes the following assumptions:

  • The bash shell is used.

  • The multiple master resource group ndb-rg is already created.

  • The ndbd daemon resource ndbd-rs is already created.

Note that only the mandatory extension properties are used in the following example.

# clresourcetype register ORCL.mysql_ndbd_shutdown
# clresource create -t ORCL.mysql_ndbd_shutdown \
-g ndb-rg -d \
-p Resource_dependencies=ndbd-rs \
-p Ndbd_resource=ndbd-rs \
ndbd-shut-rs

Attributes

See attributes(7) for descriptions of the following attributes:

ATTRIBUTE TYPE
ATTRIBUTE VALUE
Availability
ha-cluster/data-service/mysql

See Also

attributes(7), ORCL.mysql(7), ORCL.mysql_ndbd(7), ORCL.mysql_ndbmgmd(7), r_properties(7), SUNW.gds(7), clresource(8CL), clresourcegroup(8CL),clresourcetype(8CL)