monitoring restore

mysql my_database < database_backup.sql

# pv database_backup.sql | mysql my_database
96.8MB 0:00:17 [5.51MB/s] [==>                                ] 11% ETA 0:02:10

monitoring mysql

monitoring mysql database

mysql> SET GLOBAL general_log_file = '/mysql/log/all_queries.log';
mysql> SET GLOBAL general_log = 'ON';
mysql> SET GLOBAL general_log = 'OFF';

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address = 10.14.23.185
server-id       = 1
log_bin         = /var/log/mysql/mysql_bin.log
binlog_do_db    = zabbix

slow_query_log_file  = /var/lib/mysql/mysql-slow.log
long_query_time = 5
slow_query_log = 1

[client]
user=root
host=localhost
password=




install zabbix dari tar ball centos

http://bicofino.io/2015/10/09/install-zabbix-2-dot-4-6-from-source-on-centos/

Install Zabbix 2.4.6 from source on CentOS

09 OCTOBER 2015 on Linux, Zabbix, CentOS, Monitoring

I'm old fashion and in some cases I like to compile my stuff, Zabbix is one of these cases. You can add/remove features directly with ./configure, and mess around with some timeouts of zabbix_server and zabbix_agentd for example. In this tutorial, we will not change anything on the source code.

We are going install Zabbix version 2.4.6 with MySQL, Nginx and PHP-FPM. This is the stack of what I use in production environments.

Kurt Telep just created a Vagrantfile based on this tutorial, check it out here. Thanks Kurt for the contribution.

Configure the external repositories and install dependencies

[root@vagrant-centos67 ~]# mkdir -p /opt/sources/zabbix
[root@vagrant-centos67 ~]# cd /opt/sources
[root@vagrant-centos67 ~]# yum install -y wget
[root@vagrant-centos67 ~]# wget https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
[root@vagrant-centos67 ~]# rpm -ivh mysql-community-release-el6-5.noarch.rpm

# Create Nginx REPO
vi /etc/yum.repos.d/nginx.repo

# Add the following below:
[nginx]
name=nginx repo  
baseurl=http://nginx.org/packages/centos/6/$basearch/  
gpgcheck=0  
enabled=1

# Update and install required packages
yum update -y  
yum install -y mysql-server php-mysql php-bcmath php-gd php-fpm php-xml php-ldap php-mbstring wget libcurl-devel openldap-devel java-1.7.0-openjdk-devel net-snmp-devel iksemel-devel libxml2-devel mysql-devel nginx vim

Download and install Zabbix

We are compiling Zabbix with java, jabber, libcurl, snmp and ldap support, for more options(IPMI for example) please run ./configure --help

[root@vagrant-centos67 opt]# cd /opt/sources/zabbix
[root@vagrant-centos67 zabbix]# wget http://sourceforge.net/projects/zabbix/files/ZABBIX%20Latest%20Stable/2.4.6/zabbix-2.4.6.tar.gz
[root@vagrant-centos67 zabbix]# tar zxvf zabbix-2.4.6.tar.gz 
[root@vagrant-centos67 zabbix]# cd zabbix-2.4.6
[root@vagrant-centos67 zabbix-2.4.6]# ./configure --enable-server --enable-agent --prefix=/usr/local --sysconfdir=/etc --enable-java --with-mysql --with-jabber --with-libcurl --with-net-snmp --with-ldap --with-iconv --with-libxml2

Configuration:

  Detected OS:           linux-gnu
  Install path:          /usr/local
  Compilation arch:      linux

  Compiler:              gcc
  Compiler flags:        -g -O2  -I/usr/include/mysql -g  -fstack-protector  -m64 -fPIC  -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing     -I/usr/include/libxml2   -I/usr/include/rpm -I/usr/local/include -I/usr/lib64/perl5/CORE -I. -I/usr/include   -I/usr/include  -I/yes/include

  Enable server:         yes
  Server details:
    With database:         MySQL
    WEB Monitoring:        cURL
    Native Jabber:         yes
    SNMP:                  yes
    IPMI:                  no
    SSH:                   no
    ODBC:                  no
    Linker flags:          -rdynamic  -L/yes/lib    -L/usr/lib64/mysql        -L/usr/lib64   -L/usr/lib 
    Libraries:             -lm -ldl -lrt  -lresolv    -lmysqlclient     -liksemel -lxml2    -lnetsnmp   -lldap -llber   -lcurl

  Enable proxy:          no

  Enable agent:          yes
  Agent details:
    Linker flags:          -rdynamic  -L/yes/lib  -L/usr/lib 
    Libraries:             -lm -ldl -lrt  -lresolv   -lldap -llber   -lcurl

  Enable Java gateway:   yes
  Java gateway details:
    Java compiler:         javac
    Java archiver:         jar

  LDAP support:          yes
  IPv6 support:          no

***********************************************************
*            Now run 'make install'                       *
*                                                         *
*            Thank you for using Zabbix!                  *
*              <http://www.zabbix.com>                    *
***********************************************************

make  
make install


# Create group/user for Zabbix
groupadd zabbix  
useradd -g zabbix zabbix  

Configure MySQL

We will not make any configuration on MySQL, but keep in mind that in production environment you want to configure InnoDB, replication and other goodies.

[root@vagrant-centos67 zabbix]# /etc/init.d/mysqld start


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !  
To do so, start the server, then issue the following commands:

  /usr/bin/mysqladmin -u root password 'new-password'
  /usr/bin/mysqladmin -u root -h vagrant-centos67.vagrantup.com password 'new-password'
...

                                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

# Add a password for root user
[root@vagrant-centos67 zabbix-2.4.6]# mysqladmin -uroot password 'topsecret'
Warning: Using a password on the command line interface can be insecure.

# Create database for Zabbix and populate it with the .sql files
[root@vagrant-centos67 zabbix-2.4.6]# cd /opt/sources/zabbix/zabbix-2.4.6/database/mysql/
[root@vagrant-centos67 zabbix-2.4.6]# mysql -uroot -ptopsecret

create database zabbix;  
use zabbix;  
source schema.sql;  
source data.sql;  
source images.sql;  

Configure Zabbix Server and copy start scripts

cp /opt/sources/zabbix/zabbix-2.4.6/misc/init.d/fedora/core5/zabbix_server /etc/init.d/  
cp /opt/sources/zabbix/zabbix-2.4.6/misc/init.d/fedora/core5/zabbix_agentd /etc/init.d/

# Configure /etc/zabbix_server.conf
For this tutorial we will only change the line 102 to DBPassword=topsecret

/etc/init.d/zabbix_server start
/etc/init.d/zabbix_agentd start

# Check is Zabbix server is ok and running
[root@vagrant-centos67 zabbix-2.4.6]# cat /tmp/zabbix_server.log 
  6880:20151007:134754.283 Starting Zabbix Server. Zabbix 2.4.6 (revision 54796).
  6880:20151007:134754.283 ****** Enabled features ******
  6880:20151007:134754.283 SNMP monitoring:           YES
  6880:20151007:134754.283 IPMI monitoring:            NO
  6880:20151007:134754.283 WEB monitoring:            YES
  6880:20151007:134754.283 VMware monitoring:         YES
  6880:20151007:134754.283 Jabber notifications:      YES
  6880:20151007:134754.283 Ez Texting notifications:  YES
  6880:20151007:134754.283 ODBC:                       NO
  6880:20151007:134754.283 SSH2 support:               NO
  6880:20151007:134754.283 IPv6 support:               NO
  6880:20151007:134754.283 ******************************
  6880:20151007:134754.283 using configuration file: /etc/zabbix_server.conf
  6880:20151007:134754.593 current database version (mandatory/optional): 02040000/02040000
  6880:20151007:134754.594 required mandatory version: 02040000
  6880:20151007:134754.657 server #0 started [main process]
  6882:20151007:134754.664 server #1 started [configuration syncer #1]
  6885:20151007:134754.673 server #4 started [poller #2]
  6886:20151007:134754.674 server #5 started [poller #3]
  6888:20151007:134754.675 server #7 started [poller #5]
  6889:20151007:134754.675 server #8 started [unreachable poller #1]
  6890:20151007:134754.675 server #9 started [trapper #1]
  6892:20151007:134754.677 server #11 started [trapper #3]
  6893:20151007:134754.677 server #12 started [trapper #4]
  6894:20151007:134754.689 server #13 started [trapper #5]
  6895:20151007:134754.689 server #14 started [icmp pinger #1]
  6896:20151007:134754.690 server #15 started [alerter #1]
  6897:20151007:134754.690 server #16 started [housekeeper #1]
  6898:20151007:134754.690 server #17 started [timer #1]
  6899:20151007:134754.690 server #18 started [http poller #1]
  6901:20151007:134754.691 server #20 started [history syncer #1]
  6903:20151007:134754.691 server #22 started [history syncer #3]
  6906:20151007:134754.691 server #25 started [proxy poller #1]
  6904:20151007:134754.691 server #23 started [history syncer #4]
  6905:20151007:134754.691 server #24 started [escalator #1]
  6907:20151007:134754.692 server #26 started [self-monitoring #1]
  6884:20151007:134754.692 server #3 started [poller #1]
  6883:20151007:134754.692 server #2 started [db watchdog #1]
  6891:20151007:134754.692 server #10 started [trapper #2]
  6887:20151007:134754.693 server #6 started [poller #4]
  6902:20151007:134754.693 server #21 started [history syncer #2]
  6900:20151007:134755.315 server #19 started [discoverer #1]
[root@vagrant-centos67 zabbix-2.4.6]# 

Configure Nginx

mkdir -p /var/www/zabbix

[root@vagrant-centos65 mysql]# cp -r -p /opt/sources/zabbix/zabbix-2.4.6/frontends/php/* /var/www/zabbix/
[root@vagrant-centos65 mysql]# chown nginx. /var/www/zabbix/*

# Edit the file /etc/nginx/nginx.conf and paste the content below

{gfm-js-extract-pre-3}

# Edit the file /etc/nginx/conf.d/default.conf with the content

{gfm-js-extract-pre-4}  

Configure PHP and PHP-FPM

# Edit the file /etc/php.ini and correct the values as following

post_max_size 16M  
max_execution_time 300  
max_input_time 300  
date.timezone = America/Sao_Paulo (In my case)


# Configure PHP-FPM edit the file /etc/php-fpm.d/www.conf

[www]
listen = /var/run/php-fpm/php-fpm.socket  
listen.backlog = -1  
listen.owner = nginx  
listen.group = nginx  
listen.mode=0660

user = nginx  
group = nginx  
#request_slowlog_timeout = 10s
#slowlog = /var/log/php-fpm/slowlog-site.log
listen.allowed_clients = 127.0.0.1  
pm = dynamic  
pm.max_children = 20  
pm.start_servers = 6  
pm.min_spare_servers = 4  
pm.max_spare_servers = 7  
pm.max_requests = 150  
pm.status_path = /status  
request_terminate_timeout = 600s  
rlimit_files = 131072  
rlimit_core = unlimited  
catch_workers_output = yes  
env[HOSTNAME] = $HOSTNAME  
env[TMP] = /tmp  
env[TMPDIR] = /tmp  
env[TEMP] = /tmp  

There is a bug in Zabbix when you install from source.
Just run this code to fix it:

mkdir -p /var/lib/php/session  
chown nginx. /var/lib/php/session  

Start nginx/php-fpm and proceed to install

/etc/init.d/nginx start
/etc/init.d/php-fpm start

Try access http://localhost on your browser  

Finish the installation

We are almost done, now we just need to configure zabbix(generate the config file), just follow the screenshots. The process is NNF, if you have any questions ask on the comments.

If you get the error below it's probably because you forgot to configure php.ini file or to reload nginx/php-fpm

And we are done! We have Zabbix installed using a MySQL database and Nginx/PHP-FPM serving the frontend app.

sumber : http://bicofino.io/2015/10/09/install-zabbix-2-dot-4-6-from-source-on-centos/

device eth0 does not seem to be present,delaying intialization

device eth0 does not seem to be present,delaying intialization
kosongkan 


echo > /etc/udev/rules.d/70-persistent-net.rules

install template apache

langkah pertama copykan script




1. userparameter_zapache.conf
2. 2.sh

lalu rubah status di 2.sh ke alamat apachenya /STATUS_URL="http://10.14.22.36/server-status?auto"/

lalu restart zabbix_Agent nya

https://drive.google.com/open?id=0B8GDi0lY8FDgbUl1ZFFNOGhlN1U

https://drive.google.com/open?id=0B8GDi0lY8FDgLWFpR2NRWWVDMmM

sumber : http://www.zabbix.org/wiki/Docs/howto/apache_monitoring_script

sumber : https://github.com/lorf/zapache

Zabbix unreachable hosts The solution

The problem

Every now and then, a host in your Zabbix system will turn unavailable. It results in notifications like this:

Trigger: Zabbix agent on myhost is unreachable for 5 minutes
Trigger status: PROBLEM

And logs like this:

1461:20140808:074300.517 Zabbix agent item "vfs.fs.size[/home/deploy/sites/mc/shared/voip,free]" on host "myhost" failed: first network error, wait for 15 seconds
1466:20140808:074345.134 temporarily disabling Zabbix agent checks on host "myhost": host unavailable
What could be a cause? No, it’s not because a host could not be reached. That would be too easy.

A quote from Zabbix documentation:

A host is treated as unreachable after a failed agent check (network error, timeout).

…

After the UnreachablePeriod ends and the host has not reappeared, the host is treated as unavailable.

Let me decipher this for you: when a single check fails, the whole host will be considered “unavailable”, and will not be monitored anymore.

An example of such check could be vfs.fs.size of a network share that has gone stale. You lose all data and all monitoring of the host until you fix that single check.

Bad design. Bad. Really bad. (I hope some Zabbix developer will read this)

The solution

There’s none, actually. A workaround is to track down such checks and replace them with more reliable UserParameters. In the example with network share something like this could be used instead of vfs.fs.size:

set +m -o pipefail; timeout -s 9 3 df -h | grep /my/mount/point | awk '{print $5}' | grep '%' | tr -d '%' || echo 100

It shall output a “Used” value in %’s within 3 seconds (or report full partition, so you’ll get an alert anyway). Not a real solution, but at least something to do

sumber : http://huyabbix.com/zabbix-unreachable-hosts/

Backuping Full Database

Posted by Ricardo Santos in backup, database, mysql, scripts, zabbixon Sep 21st, 2012 | 3 comments

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 you’re using InnoDB for history tables at least. In my case, I have a Zabbix Database with 300GB data that takes about 3 hours to do all backup.

Create script /var/lib/xtrabackup/mysql-fullbackup.sh:

https://github.com/xsbr/zabbixzone/blob/master/mysql-fullbackup.sh

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

#!/bin/bash # # mysql-fullbackup.sh # v0.1 - 20120921 # # Full Backup for Zabbix w/MySQL # # Author: Ricardo Santos (rsantos at gmail.com) # http://zabbixzone.com # MYSQLUSER="YOURUSER" MYSQLPASS="YOURPASSWORD"   MYSQLCNF="/etc/my.cnf" MYSQLDIR="/var/lib/mysql"   BASEDIR="/var/lib/xtrabackup" BKPDIR="${BASEDIR}/lastbackup" BKPTEMPDIR="${BASEDIR}/tempbackup"   # Memory used in stage 2 USEMEMORY="1GB"   # create basedir mkdir -p ${BASEDIR}   # remove temporary dir if [ -d "${BKPTEMPDIR}" ]; then         rm -rf ${BKPTEMPDIR} fi   # do backup - stage 1 innobackupex --defaults-file=${MYSQLCNF} --user=${MYSQLUSER} --no-timestamp --password=${MYSQLPASS} ${BKPTEMPDIR}   # do backup - stage 2 (prepare backup for restore) innobackupex --apply-log --use-memory=${USEMEMORY} ${BKPTEMPDIR}   # backup my.cnf cp -pf ${MYSQLCNF} ${BKPTEMPDIR}/my.cnf   # keep only the lastbackup if [ -d "${BKPDIR}" ]; then       if [ -d "${BKPDIR}.old" ]; then               rm -rf ${BKPDIR}.old       fi       rm -rf ${BKPDIR} fi chown -R mysql: ${BKPTEMPDIR} mv ${BKPTEMPDIR} ${BKPDIR}

Adjust the permissions:

1	chmod +x /var/lib/xtrabackup/mysql-fullbackup.sh

Configure your crontab to backup every day at 04:15am:

1	15 04 * * * root /var/lib/xtrabackup/mysql-fullbackup.sh >/var/lib/xtrabackup/lastrun.log 2>&1

So if you need a restore, it’s very simple:

1 2 3 4 5 6 7 8 9 10

# stop MySQL service mysql stop   # move backuped files cd /var/lib mv mysql mysqlcrashed mv xtrabackup/lastbackup mysql   # start MySQL service mysql start