GeoIP log analysis with bash

Published on

GeoIP log analysis with bash. Running websites or other online services usually we want to get as much statistics about visitors as possible. There are plenty of system that can provide us web-based statistics. But there is another way. True admin/devops way is to analyse logs. Any service can provide access logs: nginx, apache, haproxy, … Continue reading GeoIP log analysis with bash

MySQL Master-Slave replication with SSL

Published on

To protect data while it is transferred throughout the Internet can be done using SSL. For example if you need to replicate mysql data from one datacenter to another. This is the instruction how to setup MySQL master-slave replication with ssl.

Check MySQL table size without shell

Published on

The simplest way to check the size of table is to check it via *nix ‘df’ command. Enter the location of your db, in my case it is ‘/var/db/mysql/admins247’ (‘/var/db/mysql/’ is default for FreeBSD) and perform:

This will show you the ammount of space the table is occupy on your disk. Usually you do … Continue reading Check MySQL table size without shell

VPN over SSH

Published on

VPN over SSH SSH Tunnel SSH based tunneling VPN-SSH   Since OpenSSH 4.3 tun/tap device can be used to encrypt a tunnel and create VPN over SSH. This is much like other TLS based VPN solutions e.g. OpenVPN. The main advantage to use SSH based tunneling is no need to install and configure additional software. … Continue reading VPN over SSH

Installing Log.io on CentOS

Published on

Installing Log.io on CentOS log.io:   Real-time log monitoring in your browser Powered by node.js + socket.io Log.io uses nodeJS, so first of all we need to install Node JS on a CentOS machine with the dependencies. You should have root or sudo access for it.