Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Zabbix Network Monitoring Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
Zabbix Network Monitoring Essentials

Zabbix Network Monitoring Essentials

By : Andrea Dalle Vacche, Stefano Kewan Lee
4 (6)
Buy this Book
close
close
Zabbix Network Monitoring Essentials

Zabbix Network Monitoring Essentials

4 (6)
By: Andrea Dalle Vacche, Stefano Kewan Lee
Buy this Book

Overview of this book

If you are an experienced network administrator looking for a comprehensive monitoring solution that will keep a watchful eye on networks, then this book is for you.
Table of Contents (9 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Free Chapter
1
1. Installing a Distributed Zabbix Setup
Icon
1. Installing a Distributed Zabbix Setup
Icon
Zabbix architectures
Icon
Understanding Zabbix data flow
Icon
Understanding the Zabbix proxies' data flow
Icon
Installing Zabbix
Icon
Installing a database
Icon
Installing a Zabbix proxy
Icon
Installing the WebGUI interface
Icon
Summary
2
2. Active Monitoring of Your Devices
Icon
2. Active Monitoring of Your Devices
Icon
Understanding Zabbix hosts
Icon
Going beyond Zabbix agents
Icon
Summary
3
3. Monitoring Your Network Services
Icon
3. Monitoring Your Network Services
Icon
Monitoring the DNS
Icon
Apache monitoring
Icon
NTP monitoring
Icon
Squid monitoring
Icon
Summary
4
4. Discovering Your Network
Icon
4. Discovering Your Network
Icon
Finding hosts the Zabbix way
Icon
Low-level discovery
Icon
Summary
5
5. Visualizing Your Topology with Maps and Graphs
Icon
5. Visualizing Your Topology with Maps and Graphs
Icon
Creating custom graphs
Icon
Maps – a quick setup for a large topology
Icon
Putting everything together with screens
Icon
Summary
6
A. Partitioning the Zabbix Database
chevron up
Icon
MySQL partitioning
Icon
Housekeeping configuration
7
B. Collecting Squid Metrics
Icon
Squid metric script
8
Index
Icon
Index

MySQL partitioning

Here are all the stored procedures you need to create to properly handle database partitioning with MySQL.

You need to create all of them in your Zabbix database.

Note that all the procedures described here are also available at https://github.com/smartmarmot/zabbix_network_monitoring/tree/master/Chapter1.

The partition_maintenance procedure

This is the most important procedure, which will manage all the other stored procedures involved in the creation/drop and verification of partitions, as follows:

DELIMITER $$
CREATE PROCEDURE `partition_maintenance`(SCHEMA_NAME VARCHAR(32), TABLE_NAME VARCHAR(32), KEEP_DATA_DAYS INT, HOURLY_INTERVAL INT, CREATE_NEXT_INTERVALS INT)
BEGIN
        DECLARE OLDER_THAN_PARTITION_DATE VARCHAR(16);
        DECLARE PARTITION_NAME VARCHAR(16);
        DECLARE LESS_THAN_TIMESTAMP INT;
        DECLARE CUR_TIME INT;
 
        CALL partition_verify(SCHEMA_NAME, TABLE_NAME, HOURLY_INTERVAL);
        SET CUR_TIME = UNIX_TIMESTAMP(DATE_FORMAT(NOW(), ...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 1
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY