Upgrade MySQL to MySQL 5.1 in a Cpanel server

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 »

MySQL master slave replication of multiple databases

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 »

Installing SVN on Cpanel with mod_dav_svn support

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 »

Change upload size in phpMyAdmin ( Cpanel )

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 »

Difference between AddType and AddHandler

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 »

How to choose a MPM module

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 »

CPUUNITS value in VPS

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 »

Quota problem on VPS

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 »

Add exim interface IP

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 »

Horde Session Handler error

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 »