June 17th, 2009 by admin
First ascertain the current version of mysql installed, the system architecture and OS release
rpm -qa|grep -i mysql
MySQL-devel-5.0.81-0.glibc23
MySQL-shared-5.0.81-0.glibc23
MySQL-client-5.0.81-0.glibc23
MySQL-server-5.0.81-0.glibc23
MySQL-bench-5.0.81-0.glibc23
arch
x86_64
cat /etc/redhat-release
CentOS release 5.3 (Final)
Next step is to download the latest MySQL 5.1 community release matching the OS and architecture from
http://dev.mysql.com/downloads/mysql/5.1.html#downloads
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-community-5.1.35-0.rhel5.x86_64.rpm/from/http://mirror.csclub.uwaterloo.ca/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-community-5.1.35-0.rhel5.x86_64.rpm/from/http://mirror.csclub.uwaterloo.ca/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-shared-community-5.1.35-0.rhel5.x86_64.rpm/from/http://mirror.csclub.uwaterloo.ca/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-devel-community-5.1.35-0.rhel5.x86_64.rpm/from/http://mirror.csclub.uwaterloo.ca/mysql/
The download folder should look something like
ls
./ MySQL-client-community-5.1.35-0.rhel5.x86_64.rpm MySQL-server-community-5.1.35-0.rhel5.x86_64.rpm
../ [...]
Continue reading »
June 14th, 2009 by admin
On the master server :
We have to enable networking ;if it is skipped. Enable binary logging and start a binary log of all databases
Add the following to the my.cnf file and restart MySQL
server-id = 1
log-bin=mysql-bin
binlog-do-db=gnusys_kb
binlog-do-db=gnusys_wiki
binlog-do-db=powerdns
create a user on the master with replication slave privileges on all databases from [...]
Continue reading »
April 22nd, 2009 by admin
This howto helps to install SVN (subversion ) on a cpanel server
Since Cpanel compiles httpd from source ; it is best we compile svn also from source and install the mod_dav_svn apache2 module along with it. Please note that you must have apache2.0 inoder for this to work
Step1 - mod_dav_svn requires mod_dav to be present.So [...]
Continue reading »
April 10th, 2009 by manu suresh
Change the post_max_size value to your choice in the file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini which is the php.ini for phpMyAdmin and restart Cpanel.
Continue reading »
April 6th, 2009 by manu suresh
AddType handler specifies how the client (eg:- browser) has to deal with a particular data stream . The AddHandler on the other hand maps a handler to the file extension telling the server what to do with it.
AddType application/x-httpd-php4 .php4
AddHandler application/x-httpd-php4 .php4
The above two lines looks similar except for the difference in AddType and AddHandler [...]
Continue reading »
April 6th, 2009 by manu suresh
This is not an indepth topic but i will explain the difference between a prefork MPM and worker MPM. ( reference:- apache.org )
Before you start reading anything about MPM, multi threading etc first thing you need to understand is the difference between a Process and a Thread and then everything would turn out to be [...]
Continue reading »
April 4th, 2009 by manu suresh
cpuunits is not dependent on RAM or vice versa . Normal allocation is 5000 pcs
CPUUNITS=”5000″
Analysis of a vps
———————–
vzcpucheck
Current CPU utilization: 227090
Power of the node: 781118
What this says is that node has 781000~ cpuunits available with the processors which it has there. What your host should do, is figure out how many VPSs your host is [...]
Continue reading »
April 4th, 2009 by manu suresh
Scenario:- edquota: Can’t write quota for 32063 on /dev/vzfs: No such process
Resetting quota for <user> to 0 Meg….Done
This is used for tracking quota for all your files in the system. The more files you have in your system, the more quotaugidlimit is required . quotaugidlimit is used to track the numer of group and users [...]
Continue reading »
April 4th, 2009 by manu suresh
Consider your mail server IP got blocked in many spam databases and instead of waiting for the spam database authorities to remove it ( while you have given the IP unblock request ) you can change the mail server IP which exim uses so that email traffic is open again. We can use the “interface” [...]
Continue reading »
April 4th, 2009 by manu suresh
Error:- Can’t find file: ‘horde_sessionhandler.MYI’
If you get this error, you’ve most likely done a file-based MySQL backup restore, and the InnoDB files are not present. The horde_sessionhandler table is an InnoDB table but not a MyISAM.
To fix this first you will need to stop mysql
# /etc/init.d/mysqld stop
Then remove the innoDB table
# rm /var/lib/mysql/horde/horde_sessionhandler.frm
Then start MySQL
# [...]
Continue reading »