Article Figure 1 Figure 2 Figure 3 Figure 4
Listing 1 Listing 2 Listing 3 Listing 4 Listing 5
Listing 6 jul2006.tar

Listing 6 The /etc/init.d/mysqld_multi init script

#! /bin/sh

# file: /etc/init.d/mysqld_multi

ECHO=/bin/echo
TEST=/usr/bin/test
HOSTNAME=`/bin/hostname`
MYAPP=/usr/bin/mysqld_multi
MYAPPNAME=mysqld_multi

$TEST -x $MYAPP || exit 0

case "$1" in
  start)
        $ECHO -n "Starting $MYAPPNAME: $MYAPP Instance 1 and 2"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my1.cnf \
      --user=root start 1
    $ECHO "."
        /usr/bin/mysqld_multi  --config-file=/etc/mysql/my2.cnf \
          --user=root start 2
        $ECHO "."
        ;;
  stop)
        $ECHO -n "Stopping $MYAPPNAME: $MYAPP Instance 1 and 2"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my1.cnf \
      --user=root stop 1
    $ECHO "."
        /usr/bin/mysqld_multi  --config-file=/etc/mysql/my2.cnf \
          --user=root stop 2
        $ECHO "."
        ;;
  start1)
        $ECHO -n "Starting $MYAPPNAME: $MYAPP Instance 1"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my1.cnf \
      --user=root start 1
    $ECHO "."
        ;;
  stop1)
        $ECHO -n "Stopping $MYAPPNAME: $MYAPP Instance 1"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my1.cnf \
      --user=root stop 1
    $ECHO "."
        ;;
  start2)
        $ECHO -n "Starting $MYAPPNAME: $MYAPP Instance 2"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my2.cnf \
      --user=root start 2
    $ECHO "."
        ;;
  stop2)
        $ECHO -n "Stopping $MYAPPNAME: $MYAPP Instance 2"
    /usr/bin/mysqld_multi  --config-file=/etc/mysql/my2.cnf \
      --user=root stop 2
    $ECHO "."
        ;;

  *)
        $ECHO "Usage: /etc/init.d/$MYAPPNAME \
          {start|stop|start1|stop1|start2|stop2)"
        exit 1
esac

exit 0