[ENG-FR] Zabbix deployment in SGS

[G3r0m3G]

Hello all,

I need your help and your experience about a deployment of Zabbix plateforme in my company. In SGS, we have a Centreon/Nagios which monitor 755 host and 2000 services and we need to migrate on Zabbix. Actually, I have deployed Zabbix (test environnement) in this configuration :

Zabbix Server
Type : Virtual machine
vCPU : 4
vRAM : 4go
OS : CentOS 6.3 minimal x64
Zabbix version : 2.0.3 from EPEL repository

Database Server
Type : Virtual machine
vCPU : 4
vRAM : 4go
OS : CentOS 6.3 minimal x64
DBMS : MySQL (Percona server 5.5) [InnoDB, utf8_general_ci]

**************************************************

Configuration of MySQL (my.cnf)

# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
# Configuration generated for SGS at 2012-12-18 13:01:47

[mysql]

# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
user = mysql
default_storage_engine = InnoDB
socket = /var/lib/mysql/mysql.sock
pid_file = /var/lib/mysql/mysql.pid

# MyISAM #
key_buffer_size = 32M
myisam_recover = FORCE,BACKUP

# SAFETY #
max_allowed_packet = 16M
max_connect_errors = 1000000

# DATA STORAGE #
datadir = /var/lib/mysql/

# BINARY LOGGING #
log_bin = /var/lib/mysql/mysql-bin
expire_logs_days = 3
sync_binlog = 1

# CACHES AND LIMITS #
tmp_table_size = 32M
max_heap_table_size = 32M
query_cache_type = 0
query_cache_size = 0
max_connections = 500
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 1024
table_open_cache = 2048
join_buffer_size = 1M

# INNODB #
innodb_thread_concurrency = 0
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 256M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 100M
innodb_data_file_path = ibdata1:100M:autoextend

# LOGGING #
log_error = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes = 1
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/mysql-slow.log

Result of MySQL Tuner

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28-29.2-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in InnoDB tables: 1G (Tables: 103)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 8

-------- Security Recommendations -------------------------------------------
[!!] User '@frdb998' has no password set.
[!!] User '@localhost' has no password set.
[!!] User '[email protected]' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User 'root@frdb998' has no password set.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1h 11m 12s (227K q [53.279 qps], 858 conn, TX: 75M, RX: 34M)
[--] Reads / Writes: 21% / 79%
[--] Total buffers: 2.2G global + 3.6M per thread (500 max threads)
[OK] Maximum possible memory usage: 3.9G (68% of installed RAM)
[OK] Slow queries: 0% (1K/227K)
[OK] Highest usage of available connections: 4% (22/500)
[OK] Key buffer size / total MyISAM indexes: 32.0M/43.0K
[OK] Key buffer hit rate: 100.0% (12 cached / 0 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts)
[!!] Joins performed without indexes: 71
[OK] Temporary tables created on disk: 5% (311 on disk / 5K total)
[OK] Thread cache hit rate: 97% (22 created / 858 connections)
[!!] Table cache hit rate: 15% (162 open / 1K opened)
[OK] Open file limit used: 0% (59/65K)
[OK] Table locks acquired immediately: 100% (227K immediate / 227K locks)
[OK] InnoDB data size / buffer pool: 1.7G/2.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Adjust your join queries to always utilize indexes
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 1.0M, or always use indexes with joins)
table_cache (> 2048)

QUESTIONS

About MYSQL :

• What do you think about "variable to adjust" of mysqltuner result ?

About my environnement : [LIST]What do you think of my environnement ? it's good sized or not ?

• How much hosts can support with this configuration ?

• What optimizations can applied on Zabbix ?

• The EPEL repository is updated regularly or not ?

Thank you in advance , regards,

G3r0m3G

[G3r0m3G]

Anyone can help me ?

UP !

[eskytthe]

Sorry for late and not full responds, but you can get some information here:
http://www.zabbix.com/img/zabconf201...nce_Tuning.pdf
Also how to monitor your zabbix system.
Look around in this forum will also help you - special in the " Zabbix for Large Environments".

A lot will depend one how many checks your will do, how often, how you implement these and eg.g how long you keep data.
Also make sure you have good i/o on the virtual system you run the DB on. I have the DB on hardware for this reason.

BR
Erik

[G3r0m3G]

hello eskytthe,

yes, I have read this presentation. And in addition this blog : http://zabbixzone.com/zabbix/mysql-p...ps-for-zabbix/

I think I will check 3000+ items and I will use Active check. I will use a partitionning table to keep data history table for 3 months and 12 months for events, alerts etc...

Also make sure you have good i/o on the virtual system you run the DB on. I have the DB on hardware for this reason.

Yes, I have , we have a Netapp 3210 SAN connected by iSCSI on the lastest Vmware ESX 5. We have a lot of BDD servers on our infrastructure with no overload. In addition, we customize the virtual hardware to do a CPU and RAM reservation.

Thank you for your support.