 | ||
|
| ||
 |
||
| |
| |||||||||
The SMA-mysql software package included with a modular MySQL client which communicates with the ShaoLin HA Cluster Manager and monitors the status of a running MySQL server. The SMA-mysql will report errors if failure to communicate with the MySQL server, or even failure on execute a custom SQL command . Detected errors will be reported to ShaoLin HA Cluster Manager and failover policy will be executed accordingly.
To configure the SMA-mysql, first you need to create an AAC rule for the MySQL server. Goto ShaoLin HA Cluster Configurator, select the Application Availability Control . At the section Create new AAC rule, select Services From System V Init and at the selection box at the right, choose mysqld and click Create New. If you can't see mysqld listed in the box, make sure mysql server is installed accordingly and is setup to start in the desired running level in the system V init services startup settings.
Entper a description for the AAC rule (e.g. Onlinestore DB), and at the Use selected SMA selection box, choose sma-mysql. Then client Save Changes to continue. If no error occured, the AAC rule for MySQL has successfully created.
After setting up AAC, the SMA-mysql package has not configured properly. Click on the newly created AAC rule (e.g. In this case, MySQL for onlinestop). At the AAC configuration page, click to Configure SMA (sma-mysql). You will be directed to page with the detail configurations for the SMA-mysql.
You have to enter the connection information to the MySQL database . This include hostname, username, password and the database name of the MySQL database server. By default, the SMA-mysql will connect to the MySQL database server and monitors the MySQL database connection in every AAC cycle. You can tell SMA-mysql to do a custom SQL command to verify the database healthiness instead (but will use more CPU time).
After finish configuration, remember to reinitialize the clusters to take effect. You may do this in Cluster Control or AAC settings main page under ShaoLin HA Cluster Configurator.
