Most of time as an MySQL admin we need to keep track of the DML statements per table , If we are not using any specific tool for doing this We can use the shell script for doing this which I came across the idea is to use the binlog to get all of the [...]
MySQL Replication is widely and we need to have strong replication monitoring for these things 1) To monitor if the replication is working. 2) To check the latency between the master and slave . 3) TO check the consistency between the master and slave , as sometime due to manual or master server crash , [...]
For those who are still using RHEL 4.x and in need of deploying PHP 5.3 & MySQL 5.1 , you can get the required rpm packages from http://rpms.famillecollet.com/enterprise/4/ You can add the repo and update php and MySQL packages via yum, or download and install manually. I think the bare minimum will require these packages [...]
Space problem with /var and /usr , The server is running mysql . My Plan is to move my /usr and /var to “root” (/). To do that I have to make sure that all security settings and symlink are preserved. Prepare the new partitions In my case, this is simply my “/” partitions, so [...]
MySql replication scenario Solves a.)One of the biggest advantages to have master-slave set up in MySQL is to be able to use master for all of the inserts and send some, if not all, select queries to slave. This will most probably speed up your application without having to diving into optimizing all the queries [...]
Summary If you are reaching the limits of your server running Apache serving a lot of dynamic content, you can either spend thousands on new equipment or reduce bloat to increase your server capacity by anywhere from 2 to 10 times. This article concentrates on important and poorly-documented ways of increasing capacity without additional hardware. [...]
Yum prerequistes are: python-elementtree is needed by yum-2.4.2-0.4.el4.rf.noarch python-sqlite is needed by yum-2.4.2-0.4.el4.rf.noarch urlgrabber is needed by yum-2.4.2-0.4.el4.rf.noarch and the prereques for Uvh python-sqlite is: libsqlite-2.8.15-1.i386.rpm These rpm are to be installed in the following order # rpm -Uvh libsqlite-2.8.15-1.i386.rpm # rpm -Uvh python-elementtree-1.2.6-7.el4.rf.i386.rpm #rpm -Uvh python-sqlite-0.5.0-1.2.el4.rf.i386.rpm # rpm -Uvh python-urlgrabber-2.9.7-1.2.el4.rf.noarch.rpm # rpm -Uvh yum-2.4.2-0.4.el4.rf.noarch.rpm [...]
One of the tools most Linux/Unix admins are used to is called “top”. “top” by itself is a very powerful tool. Installation Perl modules in cpan install Term::ReadKey install File::Tail install Time::HiRes Create a executable script #touch /usr/bin/httptop #chmod a+x /usr/bin/httptop Copy & paste the following contents in the script #!/usr/bin/perl -w use Time::HiRes qw( [...]
The primero recommendation for speeding up a website is almost always to add cache and more cache. And after that add a little more cache just in case. Memcached is almost always given as the recommended cache to use. What is Memcached? Memcached is a general-purpose distributed memory caching system that was originally developed by [...]
WHAT IT IS It’s a tool for automatically creating the basic framework for a PHP module and writing C code handling arguments passed to your functions from a simple configuration file. See an example at the end of this file. HOW TO USE IT Very simple. First, change to the ext/ directory of the PHP [...]
To Create a Partition of more than 2 TB, Gparted is used. You must include GPT support in kernel in order to use GPT. If you don’t include GPT support in Linux kernelt, after rebooting the server, the file system will no longer be mountable or the GPT table will get corrupted. By default Redhat [...]
Introduction:- All you know about the haproxy, that its the one of the good opensource load balancing software and to check the fun stats of haproxy here we using ‘socat’ – Multipurpose relay (SOcket CAT) about —– socat is a relay for bidirectional data transfer between two independent data channels. Each of these data channels [...]
Introduction:- Munin is a highly flexible and powerfull solution used to create graphs of virtually everything imaginable throughout your network, while still maintining a rattling easy of installation and configuration. Munin is a networked resource monitoring tool that can help analyze resource trends and “what just happened to kill our performance?” problems. It is designed [...]
yum install mysql-server sendmail-cf MySQL-python libxml2 Download Jdk latest version from: wget http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jdk-6u20-linux- i586.bin?BundledLineItemUUID=Er9IBe.oOf0AAAEoay9bNk7a&OrderID=gddIBe.oe.0AAAEoXi9bNk7a&ProductID=guBIBe.oc_wAAAEnaDJHqPYe&FileName=/jdk-6u20-linux-i586.bin mv jdk-6u20-linux-i586.bin?AuthParam=1272633583_0b435f520fad540d314411f50a185d7a&TicketId=B%2Fw4khmGSVNITB1FPFVTkwPl&GroupName=CDS&FilePath=%2FESD6%2FJSCDL%2Fjdk%2F6u20-b02%2Fjdk-6u20-linux-i586.bin&File=jdk-6u20-linux-i586.bin jdk-6u18-linux-i586.bin Download openemm source file from : http://sourceforge.net/projects/openemm/files/OpenEMM%20software/OpenEMM%206.0.1/OpenEMM-6.0.1-bin.tar.gz/download Create the ‘openemm’ User Create a special group and user for OpenEMM: groupadd openemm useradd -m -g openemm -d /home/openemm -c “OpenEMM 6.x.y” openemm Installation: Sun Java JDK Copy the file [...]
I am getting this error “configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.” while i tried to install json support with PHP 5.1.6 What is re2c? re2c is a tool for writing very fast and very flexible scanners. Unlike any other such tool, re2c focuses on generating [...]
