Versions Compared

Old Version 4

changes.mady.by.user J. Hunter Heinlen

Saved on

compared with

New Version Current

changes.mady.by.user J. Hunter Heinlen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

  1. Setup

...

  1. ISDA

...

  1. user

...

  1. directories,

...

  1. either

...

  1. by

...

  1. requesting

...

  1. this

...

  1. from

...

  1. ASST-Help@mit.edu

...

  1. for

...

  1. hosted

...

  1. system,

...

  1. or

...

  1. by

...

  1. following

...

  1. the

...

  1. ISDA

...

  1. System

...

  1. User

...

  1. Setup

...

  1. .

...

  2. Download

...

  1. the

...

  1. following

...

  1. software

...

  1. packages

...

  1. from

...

  1. Trogdor,

...

  1. the

...

  1. ISDA

...

  1. software

...

  1. repository.

...

  1. Code Block

...

  1. 
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

...

  2. Remove previous MySQL installs, 
...
  1.  and 
...
  1.  install 
...
  1.  the 
...
  1.  new 
...
  1.  version. 
...
  1.  Code Block
...
  1. 
/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

...
  2. Move the MySQL directories into /home/db, 
...
  1.  and 
...
  1.  set 
...
  1.  their 
...
  1.  correct 
...
  1.  ownership. 
...
  1.  Code Block
...
  1. 
cd /var/lib/
mv mysql mysql-cluster /home/db
cd /home/db
chown -R db:db /home/db

...
  2. Put the config file in place, and edit it for local options. 
     Code Block
    
cp /home/db/tmp/my.cnf.cluster /etc/my.cnf
cp /home/db/tmp/my.config.ini /etc

...
  2. Repeat for other systems in the cluster.
  3. 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. 
...
    1.  If 
...
    1.  they 
...
    1.  are 
...
    1.  missing, 
...
    1.  re-run 
...
    1.  the 
...
    1.  database 
...
    1.  init 
...
    1.  script. 
...
    1.  Code Block
...
    1. 
cd /home/db/mysql
ls -l
rm -rf *
mysql_install_db
/etc/init.d/mysql start

...
    2. Look for the mysql.sock 
...
    1.  file 
...
    1.  in 
...
    1.  /home/db/mysql. 
...
    1.  Code Block
...
    1. 
cd /home/db/mysql
ls -l mysql.sock

...