CCNA Security Certification

CCNA Security Certification CCNA Security Certification meets the needs of IT professionals who are responsible for network security. It confirms an individual’s skills for job roles such as Network Security Specialists, Security Administrators, and Network Security Support Engineers. This certification validates skills including installation, troubleshooting and monitoring of network...

Continue reading CCNA Security Certification

Getting MySQL Status Values With mysqlreport

mysqlreport is a Perl script that displays a well-formatted report of important MySQL status variables (taken from MySQL's SHOW STATUS; output) that can help you gain an understanding of what is happening under MySQL's hood. It can help diagnose problems. I do not issue any guarantee that this will work for you! 1 Preliminary Note mysqlreport works on any distribution. Of course, Perl and MySQL...

Continue reading Getting MySQL Status Values With mysqlreport

Running MySQL 4 And MySQL 5 Concurrently

This tutorial shows how to install MySQL 5 on a system where MySQL 4 is already running. It also shows how to configure phpMyAdmin to use both databases. 1 Download and install MySQL 5.x Download the source code from http://dev.mysql.com/downloads/mysql/5.0.html#source tar -zxvf mysql.version.tgzcd mysql.version./configure --prefix=/var/lib/mysql5 \ --with-unix-socket-path=/var/lib/mysql5/mysql5.sock...

Continue reading Running MySQL 4 And MySQL 5 Concurrently

How To Repair MySQL Replication

If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. In this short guide I explain how you can repair the replication on the MySQL slave without the need to set it up from scratch again. I do not issue any guarantee that this will work for you! 1 Identifying The Problem To find out whether...

Continue reading How To Repair MySQL Replication

Tuning MySQL Performance with MySQLTuner

MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently. This document comes without warranty of any kind! I do not issue...

Continue reading Tuning MySQL Performance with MySQLTuner

Deny or allow countries with apache .htaccess

Introduction The following script is using blogama.org IP geolocation API to automatically generate Apache .htaccess file to deny or allow specific countries. You can put this script under crontab and the .htaccess rules will be automatically updated. Also, it can update multiple .htaccess files.Deny or allow? First you need to understand the meaning of these two rules in the .htaccess file. If you...

Continue reading Deny or allow countries with apache .htaccess

Set Date Time in Cisco Router

This intruction of set date time on Cisco Router, use it for NTP server and other router use it as NTP peer.Set date timeR#clock ? set Set the time and dateR#clock set ? hh:mm:ss Current TimeR#clock set 11:20:00 ? <1-31> Day of the month MONTH Month of the yearR#clock set 11:20:00 26?<1-31> R#clock set 11:20:00 26 ? MONTH Month of the yearR#clock set 11:20:00 26 SEPT ? <1993-2035>...

Continue reading Set Date Time in Cisco Router