Force HTTPS / SSL using .htaccess and mod_rewrite Rumi, February 7, 2013 Sometimes you may need to make sure that the user is browsing your site over securte connection. An easy to way to always redirect the user to secure connection (https://) can be accomplished with a .htaccess file containing the following lines: RewriteEngine On RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]… Continue Reading
Install Munin on SL 6 Rumi, January 31, 2013 [root@master ~]# yum –enablerepo=epel -y install munin munin-node # install from EPEL [root@master ~]# vi /etc/munin/munin.conf # line 60: change to your hostname Continue Reading
MySQL Master-Master or Master-Slave Replication Error Fix Rumi, January 18, 2013 Scenario Master – Master replication MasterA is a client facing server MasterB is a warm standby server (read only) MasterB restarted abruptly and when instances were braught back up MasterA (it’s slave) was showing the following error: MasterA has the following error in show slave status: Last_IO_Errno: 1236 Last_IO_Error: Got… Continue Reading
Enabling munin node plug-ins on Debian Rumi, January 18, 2013January 18, 2013 Munin uses plug-ins to determine what data is gathered and reported. It includes several plug-ins for the types of data most people would be interested in, but not all of those plug-ins are enabled on a fresh installation. What are plug-ins? When a munin node gathers data about a slice… Continue Reading
PHP-RRDTool installation on CentOS 5 Rumi, January 13, 2013January 13, 2013 Step-1 Adding Yum Repository Add the Reporforge repository. Then- Yum install php-rrdtool Alternatively, you can download the rpm from http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/php-rrdtool-1.4.4-1.el5.rf.i386.rpm Continue Reading
Monitor MySQL database restore progress with pv Rumi, January 12, 2013 The pv command is one that I really enjoy using but it's also one that I often forget about. You can't get a much more concise definition of what pv does than this one: pv allows a user to see the progress of data through a pipeline, by giving information… Continue Reading
Installing XHProf on Debian Rumi, January 12, 2013January 12, 2013 xhprof provides profiling information, down to the function call. This includes execution time, CPU and memory usage for each operation. The module allows you to find and optimise bottlenecks in your application. The library includes a GUI output, you just use the classes provided to create the reports. I installed… Continue Reading
Nagios- Memory Check Plugin Rumi, January 6, 2013January 6, 2013 Dave the below code as check_mem.sh using nano and chmod it to +x. (file to be saved inside nagios libexec- such as /usr/local/nagios/libexec/check_mem.sh Continue Reading
MySQLTuner adjust your MySQL database Rumi, January 6, 2013 MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It's key to remember that MySQLTuner is a script… Continue Reading
Adjust Apache ServerLimit and MaxClient Rumi, January 6, 2013 MaxClients actually tells the apache to allow this many concurrent clients. Normally this limit is at 150. You can change this limit by editing your httpd.conf file. httpd.conf is normally located at /etc/httpd/conf/httpd.conf nano /etc/httpd/conf/httpd.conf ServerLimit directive to let the value of MaxClients above 256 work. By deafult ServerLimit is… Continue Reading