Example: Installing and bootstrapping the MySQL Software on Local Storage

These steps illustrate how to install the MySQL software in the default directory /usr/local/mysql. As long as only one node is mentioned it needs to be the node where your resource group is online.

1. Install the MySQL binaries on both nodes.

   phys-schost-1# cd /usr/local phys-schost-1# tar xvf mysql-max-5.0.22-solaris10-architcture_64.tar.gz phys-schost-1# ln -s mysql-max-5.0.22-solaris10-architcture_64 mysql

2. Change the ownership of the MySQL binaries on both nodes.

   phys-schost-1# chown -R mysql:mysql /usr/local/mysql

3. Create your data base directories.

   phys-schost-1# mkdir -p /global/mnt3/mysql-data/logs phys-schost-1# mkdir /global/mnt3/mysql-data/innodb phys-schost-1# mkdir /global/mnt3/mysql-data/BDB

4. Bootstrap MySQL.

   phys-schost-1# cd /usr/local/mysql phys-schost-1# ./scripts/* --datadir=/global/mnt3/mysql-data

5. Create your my.cnf config-file in /global/mnt3/mysql-data

   phys-schost-1# cat > /global/mnt3/mysql-data/my.cnf << EOF [mysqld] server-id=1 #port=3306 # 10.18.5.1 is the address of the logical host bind-address=10.18.5.1 # this is the address of the logical host socket=/tmp/hahostix1.sock log=/global/mnt3/mysql-data/logs/log1 log-bin=/global/mnt3/mysql-data/logs/bin-log binlog-ignore-db=sc3_test_database log-slow-queries=/global/mnt3/mysql-data/logs/log-slow-queries #log-update=/global/mnt3/mysql-data/logs/log-update # Innodb #skip-innodb innodb_data_home_dir = /global/mnt3/mysql-data/innodb innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /global/mnt3/mysql-data/innodb innodb_log_arch_dir = /global/mnt3/mysql-data/innodb # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high set-variable = innodb_buffer_pool_size=50M set-variable = innodb_additional_mem_pool_size=20M # Set .._log_file_size to 25 % of buffer pool size set-variable = innodb_log_file_size=12M set-variable = innodb_log_buffer_size=4M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 # BDB # uncomment the skip-bdb if you used a binary download. # binary downloads come very often without the bdb support. #skip-bdb bdb-home=/global/mnt3/mysql-data bdb-no-recover bdb-lock-detect=DEFAULT bdb-logdir=/global/mnt3/mysql-data/BDB bdb-tmpdir=/global/mnt3/mysql-data/BDB #bdb_max_lock=10000 # Replikering Slave #server-id=2 #master-host=administerix #master-user=repl #master-password=repl #master-info-file=/global/mnt3/mysql-data/logs/master.info # MySQL 4.x #relay-log=/global/mnt3/mysql-data/logs/slave-bin.log #relay-log-info-file=/global/mnt3/mysql-data/logs/slave-info

6. Change the ownership of the MySQL data directory.

   phys-schost-1# chown -R mysql:mysql /global/mnt3/mysql-data

7. Change the permission of the my.cnf file.

   phys-schost-1# chmod 644 /global/mnt3/mysql-data/my.cnf