Page History

# Download the following software packages from Trogdor, the ISDA software repository.

{code

}
mkdir /home/db/tmp
scp root@trogdor.mit.edu:/opt/software-repository-tmp/MySQL/5.0.45/rhel5/i386/MySQL-*-community-5.0.45-0.rhel5.i386.rpm \
   root@trogdor.mit.edu:/opt/software-repository-tmp/MySQL/my.cnf.cluster \
   root@trogdor.mit.edu:/opt/software-repository-tmp/MySQL/my.config.ini \
   root@trogdor.mit.edu:/opt/software-repository-tmp/MySQL/perl-DBI-1.40-8.i386.rpm \
   root@trogdor.mit.edu:/opt/software-repository-tmp/MySQL/perl-HTML-Template-2.9-1.el5.rf.noarch.rpm \
   /home/db/tmp

{code}
# Remove previous MySQL installs, and install the new version.

{code

}
/etc/init.d/mysql stop
rpm -e dovecot-0.99.11-2.EL4.1.i386
rpm -e cyrus-sasl-sql-2.1.19-5.EL4.i386
rpm -e mysqlclient10-3.23.58-4.RHEL4.1.i386
rpm -e mysql-4.1.20-1.RHEL4.1.i386
rpm -ivh /home/db/tmp/perl-DBI-1.40-8.i386.rpm
rpm -ivh /home/db/tmp/MySQL-server-community-5.0.45-0.rhel5.i386.rpm
/etc/init.d/mysql stop
rpm -ivh /home/db/tmp/MySQL-client-community-5.0.45-0.rhel5.i386.rpm
rpm -ivh /home/db/tmp/MySQL-shared-community-5.0.45-0.rhel5.i386.rpm
rpm -ivh /home/db/tmp/MySQL-clusterstorage-community-5.0.45-0.rhel5.i386.rpm
rpm -ivh /home/db/tmp/perl-HTML-Template-2.9-1.el4.rf.noarch.rpm
rpm -ivh /home/db/tmp/MySQL-clustertools-community-5.0.45-0.rhel5.i386.rpm
rpm -ivh /home/db/tmp/MySQL-clusterextra-community-5.0.45-0.rhel5.i386.rpm
rpm -ivh /home/db/tmp/MySQL-clustermanagement-community-5.0.45-0.rhel5.i386.rpm

{code}
# Move the MySQL directories into /home/db, and set their correct ownership.

{code

}
cd /var/lib/
mv mysql mysql-cluster /home/db
cd /home/db
chown -R db:db /home/db

{code}
# Put the config file in place, and edit it for local options.
{code}
cp /home/db/tmp/my.cnf.cluster /etc/my.cnf
cp /home/db/tmp/my.config.ini /etc

{code}
# Repeat for other systems in the cluster.
# If there are problems getting MySQL to startup, it could be either missing databases that are required, or a problem with the socket file.
## Look for the necessary databases (mysql, test) in /home/db/mysql.  If they are missing, re-run the database init script.

{code

}
cd /home/db/mysql
ls -l
rm -rf *
mysql_install_db
/etc/init.d/mysql start

{code}
## Look for the mysql.sock file in /home/db/mysql.

{code

}
cd /home/db/mysql
ls -l mysql.sock
{code}