linux

Template_app_nginx: nginx.ping param
Template_app_PostgreSQL: pgsql_autovac_freeze.py: listing databases with % how close they are to freeze (use /opt/ztc/bin/pgsql_autovac_freeze.py list)
new template: 3ware raid status monitoring
Template_Linux: ntp jitter monitoring

Download

mediawiki 1.16.0 rpm for RHEL5

Submitted by vladimir on Mon, 08/30/2010 - 10:32

SRC RPM: http://yum.voronezh.muranosoft.com/testing/srpm/mediawiki-1.16.0-1.src.rpm

x86_64 RPM:
http://yum.voronezh.muranosoft.com/testing/x86_64/mediawiki-1.16.0-1.x86...
http://yum.voronezh.muranosoft.com/testing/x86_64/mediawiki-math-1.16.0-...
http://yum.voronezh.muranosoft.com/testing/x86_64/mediawiki-nomath-1.16....

If you need i386 rpm - get src.rpm and run 'rpmbuild --rebuild mediawiki-1.16.0-1.src.rpm'

ZTC 9.9: zabbix templates for Linux, PostgreSQL, Slony, nginx and apache2

Submitted by vladimir on Thu, 09/10/2009 - 16:06

Hi!

This is next release of ZTC (Zabbix Templates Collection) - collection of templates and UserParameter scrips for zabbix for server aviability and performance monitoring.

This version introduces new template for apache2 monitoring and also includes lots of bugfixes and enchancements to existing templates.

Hopefully, this would be useful for anyone. I'm waiting for reviews, bugreports, featire requests and patches. Do it via trac, comments to this post or via any other method you'll find.

MySQL check & repair script

Submitted by vladimir on Sat, 08/01/2009 - 11:17

Recommended to run after every forced shutdown and periodically. Especially useful for large number of databases with MyISAM tables.

Requires: Python 2.x and MySQLdb (mysql python module)

#!/usr/bin/env python
 
#########################################
# Check all tables in all mysql databases
#
# Written by Vladimir Rusinov <vladimir@greenmice.info>, http://greenmice.info/
#
# Reqirements:
#   Python 2.x (tested with 2.4)
#   MySQLdb
 
#########################################
# Settings:
 
host="localhost"
username="root"
password=""

Linkdump #0005

Submitted by vladimir on Sat, 07/11/2009 - 18:10

Iptables: router performance

Submitted by vladimir on Sat, 07/11/2009 - 13:56

Original: Iptables – производительность роутера (Russian)
Translation by Vladimir Rusinov

Incorrect iptables settings may cause poor router performance. I'll show you how can you improve iptables performance

Disable connection tracking

The first thing you need to do (if you are not using NAT) is to disable connection tracking in nat table, PREROUTING chain:

ZTC 10.10: zabbix templates for Linux, PostgreSQL, MySQL, Apache and nginx monitoring

Submitted by vladimir on Fri, 06/26/2009 - 23:55

ZTC (Zabbix Templates Collection) is a collection of templates for monitoring servers availability and performance.

ZTC 10.10 includes following templates

Linux_Generic - Linux OS monitoring: CPU, memory, disks
Apache - monitoring of apache httpd 2.0+ web server
nginx - monitoring of nginx web server
MySQL - monitoring of MySQL 5.0+
PostgreSQL - monitoring of PostgreSQL 8.3+
and some others

RHEL/CentOS usability

Submitted by vladimir on Sun, 06/21/2009 - 21:33

RHEL/CentOS is good server OS, but sometimes it's too Enterprise and needs some usability tuning. I wrote instruction for myself and apply it to all stand-alone servers I manage.

Here it is:

Whoami && whereami

# cpu:
cat /proc/cpuinfo
# disks:
df -h
sudo /sbin/fdisk -l
/usr/sbin/vgdisplay
/usr/sbin/lvdisplay
sudo /sbin/hdparm -tT /dev/sda
# devices:
sudo /sbin/lsusb
sudo /sbin/lspci
# memory
vmstat

Creating user

Do not use root account for many reasons.

Login as root:

GreenMice

ZTC 11.02: zabbix templates for Linux servers monitoring

mediawiki 1.16.1 rpm for RHEL5

ZTC 10.11: zabbix templates for Linux, PostgreSQL, MySQL, Apache and nginx monitoring