ORCL.mysql_ndbd, mysql_ndbd - resource type implementation for managing the MySQL Cluster data node daemon (ndbd) with HA for MySQL Cluster
The ORCL.mysql_ndbd resource type represents the MySQL Cluster ndbd instance in an Oracle Solaris Cluster configuration. The resource type controls the ndbd daemon for MySQL Cluster.
The resource type logs the output of the MySQL Cluster data node daemon (ndbd) start and stop functions in the /var/adm/messages file.
For more information about Oracle Solaris Cluster HA for 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 resource type are described in the subsections that follow. To set these properties for an instance of the ORCL.mysql_ndbd resource type, use the clresourcetype(8CL) command.
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.
The MySQL Cluster ndbd 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 resource type are as follows:
This property specifies the MySQL Cluster base directory.
False
String
1
Not applicable
When disabled
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.
False
Integer
-1
Not applicable
When disabled
This property specifies the connect string for the MySQL Cluster ndb_mgm command.
False
String
None
Not applicable
When disabled
This property specifies the MySQL Cluster data directory.
True
String
1
Not applicable
When disabled
This property indicates the level of logging for the GDS-based scripts.
True
Integer
0
0-2
Any time
This property specifies the value for the MySQL Cluster ndb_mgm show-command-error command.
True
Integer
25
1
1 - 50
Anytime
This property determines whether to fail over when Retry_count is exceeded during Retry_interval. This property is optional.
False
Boolean
True
Not applicable
When disabled
This property specifies the MySQL Cluster NDB server ID number.
True
Integer
1
1
1 - 50
Anytime
This property specifies the level of logging for GDS events. This property is optional.
False
Integer
Info
Not applicable
Any time
This property indicates the number of PMF restarts of the fault monitor that are allowed.
False
Integer
4
Not applicable
Any time
This property indicates the time window (in minutes) for fault monitor restarts.
False
Integer
2
Not applicable
Any time
This property specifies whether MySQL Cluster runs single-threaded or multi-threaded.
False
String
Not applicable
When disabled
This property indicates whether the application uses the public network to communicate with its clients. This property is optional.
False
Boolean
False
Not applicable
At creation
This property indicates the timeout value (in seconds) for the probe.
False
Integer
2
30
Not applicable
Any time
This property indicates the signal that is sent to the application to be stopped. This property is optional.
False
Integer
9
1 - 37
When disabled
This property specifies the value of the try_reconnect parameter for the MySQL Cluster ndb_mgm command.
True
Integer
10
1
1 - 50
Anytime
This property specifies the MySQL Cluster user, if it is other than the root role.
False
String
None
When disabled
This example shows the commands to create an ORCL.mysql_ndbd resource. These commands perform the following operations:
Registering ORCL.mysql_ndbd
Adding the mysql_ndbd-rs resource to the ndb-rg resource group
This example makes the following assumptions:
The bash shell is used.
The multiple masters resource group ndb-rg is already created.
The management daemon resource mgm-rs is already created.
Note that only the mandatory extension properties are used in the following example.
# clresourcetype register ORCL.mysql_ndbd
# clresource create -t ORCL.mysql_ndbd \
-g ndb-rg -d \
-p Resource_dependencies=mgm-rs \
-p Basedir=/usr/local/mysql \
-p Try_reconnect=1 \
-p Connect_string{psoma1}=psoma1,psoma2 \
-p Connect_string{psoma2}=psoma2,psoma1 \
-p ID{psoma1}=3 \
-p ID{psoma2}=4 \
-p Data_dir=/ndbd-data \
-p Error_on_show=25 \
ndbd-rs
See attributes(7) for descriptions of the following attributes:
|
attributes(7), ORCL.mysql(7), ORCL.mysql_ndbd_shutdown(7), ORCL.mysql_ndbmgmd(7), r_properties(7), SUNW.gds(7), clresource(8CL), clresourcegroup(8CL),clresourcetype(8CL)