Currently Browsing: zabbix

Compiling Zabbix Agent on Windows

Tested with Zabbix 1.8.6 on Windows 2008 R2 Datacenter 64bits Requirements * Windows SDK for Windows 7 * Visual C++ 2010 Express * Zabbix Source * 7-Zip or similar Compiling for 32bits (x86) "C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin\vcvars32.bat" cd "C:\Users\Administrator\Downloads\zabbix-1.8.6\build\win32\project" copy ..\include\config.h ..\..\..\include\ nmake Makefile_agent 1234 "C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin\vcvars32.bat"cd...
read more

Backuping Full Database

Dump doesn’t work. If you have huge tables with billions of rows your backup process could become a nightmare, mainly if you need to restore it. This method aims to perform a full backup of a large MySQL database, as Zabbix (any version), focusing on a fast recovery from disaster. So I chose XtraBackup for this task, a backup tool from Percona, which works using the hotcopy mode. First, you need to download and install XtraBackup: http://www.percona.com/downloads/XtraBackup/LATEST/ XtraBackup offers a lot of parameters, so this script is intented to be the simplest possible. Make sure that...
read more

One day in Zabbix HQ

I had the opportunity to stay for one day inside Zabbix HQ (Riga, Latvia) before the Zabbix Conference 2012 and I would like to share some impressions. Zabbix Office is located in a large office building, only 15 minutes far from downtown Riga. http://goo.gl/maps/CoK4c According to Alexei, CEO of Zabbix SIA, the decision about the place is to improve the quality of life of employees reducing transportation time. The reception was very good, even though I am from a different culture (brazilian), they made ​​me feel me home, like I was part of that team. People work very focused on their work,...
read more

ZabbixZone Repository

I’d like to announce the ZabbixZone Repository, a Zabbix package repository, where the main goal is provide an easy way to install and keep Zabbix installations. Packages are available for CentOS 5, CentOS 6 and Debian 6 (Squeeze): http://repo.zabbixzone.com/ All packages were built by Kodai Terashima, an IT Engineer from Zabbix SIA, I take this opportunity to thank you for the excellent work. Feel free to ask any question. Installing ZabbixZone Repository on CentOS: # Importing GPG key rpm --import http://repo.zabbixzone.com/centos/RPM-GPG-KEY-zabbixzone # Install...
read more

Zabbix 2.0 – Reloaded

May 22nd 2012 will be forever in the Zabbix history like the moment when the project hit a higher point of maturity and stability. With this new version, came a new Release Policy making Zabbix more reliable for large environments. In Minor Versions, no new features, no changes in database structure, bug fixing only focus. Planning for release a Major Version every 9 months. A great improvement in Development is the Zero Bug Policy which all bugs (stable, trunk) are treated with the highest priority. The goal is keep no open bugs. In this new era, I wish Zabbix: “Live long and...
read more

MySQL database is the most used for Zabbix

In March 2011, I create a poll in Zabbix Forum with this question: It received 92 votes and MySQL was the most voted with 71.74% followed by PostgreSQL with 21.74% Personally I found many problems with Oracle 11g when reach more than 1000 nvps (new values per second). My results with MySQL was very good reaching more than 3500 nvps. Unfortunately I still could not test PostgreSQL, but there are many positive posts in Forum. And you, which database are you...
read more

Zabbix on Social Media

I always dreamed of seeing the Zabbix spreading in all social networks, because it’s fundamental for an Open Source project. Is very difficult bring some serious TI guys to this social world, but this tools can be very powerful when wisely used. Finally Zabbix annunciated in February’s Newsletter the Zabbix page on Facebook: https://www.facebook.com/zabbix Over 1100 people follow the Zabbix on Twitter: https://twitter.com/zabbix Linkedin also has an expressive Zabbix Group with 643 members:...
read more

MySQL performance tips for Zabbix

Most of these tips is useful for many application, but I’ll keep focus on Zabbix. Use a Dedicated Server Database is the main bottleneck from Zabbix. Try to use a Dedicated Server for MySQL and make sure that server has great resources (CPU, memory and fast disks). This is the specs for an environment with 3000 values per second: Dell PowerEdge R610 CPU: Intel Xeon L5520 2.27GHz (16 cores) Memory: 24GB RAM Disks: 6x SAS 10k with RAID10 by hardware Create one file per...
read more

Backuping only the Zabbix Configuration

This script is a simple way to backup all configuration tables (eg. templates, hostgroups, hosts, triggers…) without the history data. If you need do a full backup (history included) I recommend you this post: http://zabbixzone.com/zabbix/backuping-full-database/ As the result is very small (around 30 MB), is possible run this backup many times per day. https://github.com/xsbr/zabbixzone/blob/master/zabbix-mysql-backupconf.sh #!/bin/bash # # zabbix-mysql-backupconf.sh # v0.2 - 20111105 # # Configuration Backup for Zabbix 1.8 w/MySQL # # Author: Ricardo Santos...
read more

Partitioning Tables on Zabbix 1.8

Many performance problems on Zabbix are related to the database and it became visible only when we have thousands of items. On another side, we have to handle enormous tables and it makes impossible operational routines like housekeeping and backup. Use all information and scripts at your own risk. Make backups! My suggestion is disable housekeeping and to partition some tables based on clock, an unix timestamp field. If you wanna know more about partitioning access the MySQL Reference Manual – Partitioning Overview.   The Concept An easy way to handle partitioning is splitting the tables...
read more

« Previous Entries