ORCL.mysql, mysql - resource type implementation for processing of Oracle Solaris Cluster HA for MySQL database server
The ORCL.mysql resource type represents the MySQL database server instance in an Oracle Solaris Cluster configuration.
The resource type logs the output of the MySQL start and stop functions in the /var/adm/messages file.
For more information about Oracle Solaris Cluster HA for MySQL, see Oracle Solaris Cluster Data Service for MySQL Guide.
Standard properties and extension properties that are defined for the ORCL.mysql resource type are described in the subsections that follow. To set these properties for an instance of the ORCL.mysql 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 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 resource type are as follows:
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 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 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 the MySQL base directory.
False
String
1
Not applicable
When disabled
This property specifies the MySQL check flag for intensive checks.
False
Boolean
False
Not applicable
When disabled
This property specifies the MySQL check flag for intensive ndb checks.
False
Boolean
False
Not applicable
When disabled
This property specifies the MySQL data directory.
False
String
1
Not applicable
When disabled
This property specifies the MySQL fault monitoring user.
False
String
1
Not applicable
When disabled
This property specifies the MySQL host.
False
String
1
Not applicable
When disabled
This property indicates the MySQL log directory.
False
String
1
Not applicable
When disabled
This property specifies the MySQL operating system user.
False
String
1
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 example shows the commands to create an ORCL.mysql resource. These commands perform the following operations:
Registering ORCL.mysql
Adding the RES-MYSQL resource to the RG-MYSQL resource group
This example makes the following assumptions:
The bash shell is used.
The failover resource group RG-MYSQL is already created.
The logical host resource is already created.
The storage resource mys-hsp-rs is already created.
Note that only the mandatory extension properties are used in the following example.
# clresourcetype register ORCL.mysql # clresource create -d -g RG-MYSQL -t ORCL.mysql \ -p Mysql_basedir=/usr/local/mysql \ -p Mysql_datadir=/global/mnt1/mysql-data \ -p Mysql_user=mysql \ -p Mysql_host=hahostix4 \ -p Mysql_fmuser=fmuser \ -p Mysql_logdir=/global/mnt1/mysql-data/logs \ -p Resource_dependencies=hahostix4 \ -p Resource_dependencies_offline_restart=mys-hsp-rs \ RES-MYSQL
See attributes(7) for descriptions of the following attributes:
|
attributes(7), ORCL.mysql_ndbd(7), ORCL.mysql_ndbd_shutdown(7), ORCL.mysql_ndbmgmd(7), r_properties(7), SUNW.gds(7)clresource(8CL), clresourcegroup(8CL),clresourcetype(8CL)