- Login to zabbix
- Here you can see the dashboard showing host status and triggers.
- Now the user should add host in the zabbix.
- Click on configuration and select Hosts.
- Here you can see the list of added hosts.
- To add a new host click on add host button.
- Fill the following details with hostname, groups and IP address.
- Select Templates and add mysql templates.
- To select templates click on select button.
- It will prompt a window select Template App MySQL and other required templates from there.
- Now add the selected templates.
- Now the MySQL server is hosted with selected templates.
- Now the user need to install zabbix-agent in MySQL server. (Click here for how to)
- In that template there will be various MySQL monitoring Items.
- If user need to add more item then select Item.
- Here user can check the available items.
- To add new item click on add item button.
- Here give the item name, key, type and application .
- Then select add.
- Now the item is created.
- Then add trigger to the item.
- Select the item and click on create trigger.
- It will prompt a window.
- Give name, expression and severity and click on add button.
- Now the trigger monitoring MySQL error log is added successfully.
Advertisements