MySQL
Agent Function
The
operations or functions that the Symantec High Availability agent for MySQL
can
perform are as follows:
online
|
$
BaseDir/bin/mysqld_safe --defaults-file=MyCnf --datadir=DataDir --user=MySQLUser
|
monitor
|
$
BaseDir/bin/mysqladmin --user=MySQLAdmin
--password=MySQLAdminPasswd status
|
offline
|
$
BaseDir/bin/mysqladmin --user=MySQLAdmin
--password=MySQLAdminPasswd shutdown
|
clean
|
$
BaseDir/bin/mysqladmin --user=MySQLAdmin
--password=MySQLAdminPasswd shutdown
|
Create
a MySQLAdmin user with shutdown privileages only:
# mysql -uroot -p{PASSWORD}
mysql>
use mysql;
mysql>
select user,host,password from user;
mysql>
create user 'MySQLAdmin'@'localhost' identified by 'passw0rd' ;
mysql>
create user 'MySQLAdmin'@'127.0.0.1' identified by 'passw0rd' ;
mysql>
grant shutdown on *.* to 'MySQLAdmin'@'localhost' ;
mysql>
grant shutdown on *.* to 'MySQLAdmin'@'l27.0.0.1' ;
mysql>
select user,host,password from user;
mysql>
flush privileges;
|
Test
the user can shutdown the MySQL database
# $BaseDir/bin/mysqladmin --user=MySQLAdmin
--password=passw0rd status
# $BaseDir/bin/mysqladmin --user=MySQLAdmin
--password=passw0rd shutdown
|
Installation
# rpm -Uvh VRTSacclib-6.2.0.0-GENERIC.noarch.rpm
# rpm -Uvh VRTSmysql-6.2.0.0-GENERIC.noarch.rpm
|
Import MySQL resource
type:
/etc/VRTSagents/ha/conf/MySQL/MySQLTypes.cmd
|
Encrypt MySQLadmin
password
# vcsencrypt -agent
Enter Password:
Enter Again:
GUGsHUjUJuNSvUIsK
|
VCS MySQL Resource
Attribute
group MySQL (
SystemList = { node1 = 0, node2 = 1 }
)
MySQL MySQLdb (
Critical = 1
MySQLAdmin = MySQLAdmin
MySQLAdminPasswd = GUGsHUjUJuNSvUIsK <=== encrypt password
BaseDir = "/usr"
DataDir = "/var/lib/mysql"
MyCnf = "/etc/my.cnf"
)
|
Running multiple instances of MySQL on a single node
VCS
ENV file
#!/bin/ksh
MYSQL_UNIX_PORT=/tmp/mysql.sock; export
MYSQL_UNIX_PORT
MYSQL_TCP_PORT=3307; export MYSQL_TCP_PORT
|
