Apache Web Server .htaccess File functional Rumi, February 8, 2013 .htaccess is Apache's directory-level configuration file. It allows end user to configure authentication and other options without editing main httpd.conf file. Make sure AccessFileName set to .htaccess Search httpd.conf for AccessFileName directive. It defines name of the distributed configuration file: # grep -i AccessFileName httpd.conf Make sure users are allowed… Continue Reading
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
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
Monitoring multiple server using Munin on Debian/Ubuntu Distribution Rumi, January 6, 2013 This tutorial was written for Debian Etch, but the configuration should apply to other distributions with little changes as well. I want to say first that this is not the only way of setting up such a system. There are many ways of achieving this goal but this is… Continue Reading