- CentOS. Tested with CentOS 6.5 Final.
- python and all required libarary is installed: paramiko, pyzabbix, cloudmonkey.
- Zabbix server and zabbix agent is ready. See Zabbix Manual for more information.
- MySQL Cluster installed.
-
Configure API and secret key of CloudStack, zabbix server address, zabbix port, password used for ssh for every scripts in folder Sources
-
Copy every file and folders in Sources to corresponding node.
Zabbix Server folder --> Zabbix Server
HAProxy --> HAProxy server
mysql_management_node --> MySQL Cluster management node
mysql_data_node --> MySQL Cluster data node
mysql_sql_node --> MySQL Cluster SQL node
-
Import MySQL template to Zabbix Server. File: zbx_export_templates
-
Create action in Zabbix Server.
Action 1: Do when MySQL SQL Overload
Condition:
Maintenance status not in maintenance
Trigger value = PROBLEM
Trigger name like SQL Overload
Operations:
Run remote commands on current host, start immediately
Execute on Zabbix Server
Commands: sudo python /script/create_host.py sql
Action 2: Do when MySQL SQL too low
Condition:
Maintenance status not in maintenance
Trigger value = PROBLEM
Trigger name like SQL too low
Operations:
Run remote commands on current host, start immediately
Execute on Zabbix Server
Commands: sudo python /script/delete_host.py sql {ITEM.LASTVALUE4} {ITEM.LASTVALUE2}
- folder zombile: scripts to flood mysql server for testing.
- zabbix scripts: scripts for monitoring controller, but not yet implemented.