ORCL.mysql_ndbmgmd, mysql_ndbmgmd - resource type implementation for managing the MySQL Cluster management server program (ndbd_mgmd) with HA for MySQL Cluster
The ORCL.mysql_ndbmgmd resource type represents the MySQL Cluster management server program (ndbd_mgmd) instance in an Oracle Solaris Cluster configuration with HA for MySQL Cluster. This daemon provides the interface to manage and monitor the MySQL Cluster installation and therefore must be highly available.
The resource type logs the output of the ndbd_mgmd program 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_ndbmgmd resource type are described in the subsections that follow. To set these properties for an instance of the ORCL.mysql_ndbmgmd 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 ORCL.mysql_ndbmgmd 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_ndbmgmd 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 MySQL Cluster configuration directory.
True
String
None
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 indicates the level of logging for the GDS-based scripts.
True
Integer
0
0-2
Any time
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 management 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 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_ndbmgmd resource. These commands perform the following operations:
Registering ORCL.mysql_ndbmgmd
Adding the mysql_ndbmgmd-rs resource to the mgm-rg resource group
This example makes the following assumptions:
The bash shell is used.
The multiple master resource group mgm-rg is already created.
Note that only the mandatory extension properties are used in the following example.
# clresourcetype register ORCL.mysql_ndbmgmd
# clresource create -t ORCL.mysql_ndbmgmd \
-g mgm-rg -d \
-p Basedir=/usr/local/mysql \
-p Try_reconnect=1 \
-p Connect_string{psoma1}=psoma1,psoma2 \
-p Connect_string{psoma2}=psoma2,psoma1 \
-p ID{psoma1}=1 \
-p ID{psoma2}=2 \
-p Config_dir=/mgm-data \
mgm-rs
See attributes(7) for descriptions of the following attributes:
|
attributes(7), ORCL.mysql(7), ORCL.mysql_ndbd(7), ORCL.mysql_ndbd_shutdown(7), r_properties(7), SUNW.gds(7), clresource(8CL), clresourcegroup(8CL),clresourcetype(8CL)