1. Setup ISDA user directories, either by requesting this from ASST-Help@mit.edu for hosted system, or by following the ISDA System User Setup.
  2. Download the following software packages from Trogdor, the ISDA software repository. 
    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
  3. Remove previous MySQL installs, and install the new version. 
    /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
  4. Move the MySQL directories into /home/db, and set their correct ownership. 
    cd /var/lib/
mv mysql mysql-cluster /home/db
cd /home/db
chown -R db:db /home/db
  5. Put the config file in place, and edit it for local options. 
    cp /home/db/tmp/my.cnf.cluster /etc/my.cnf
cp /home/db/tmp/my.config.ini /etc
  6. Repeat for other systems in the cluster.
  7. If there are problems getting MySQL to startup, it could be either missing databases that are required, or a problem with the socket file.
    1. Look for the necessary databases (mysql, test) in /home/db/mysql. If they are missing, re-run the database init script. 
      cd /home/db/mysql
ls -l
rm -rf *
mysql_install_db
/etc/init.d/mysql start
    2. Look for the mysql.sock file in /home/db/mysql. 
      cd /home/db/mysql
ls -l mysql.sock
  • No labels