Example: How to Install and Bootstrap the MySQL Software on Local Storage

These steps illustrate how to install the MySQL software in the default directory /usr/local/mysql.

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-architecture_64.tar.gz 
   phys-schost-1# ln -s mysql-max-5.0.22-solaris10-architecture_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 database directories.

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

4. Bootstrap MySQL on both nodes.

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

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

   phys-schost-1# cat > /local/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 # 
   socket=/tmp/phys-schost-1 .sock 
   log=/local/mysql-data/logs/log1 
   log-bin=/local/mysql-data/logs/bin-log 
   binlog-ignore-db=sc3_test_database 
   log-slow-queries=/local/mysql-data/logs/log-slow-queries 
   #log-update=/local/mysql-data/logs/log-update 
   # Innodb 
   #skip-innodb 
   innodb_data_home_dir = /local/mysql-data/innodb 
   innodb_data_file_path = ibdata1:10M:autoextend 
   innodb_log_group_home_dir = /local/mysql-data/innodb 
   innodb_log_arch_dir = /local/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=/local/mysql-data 
   bdb-no-recover 
   bdb-lock-detect=DEFAULT 
   bdb-logdir=/local/mysql-data/BDB 
   bdb-tmpdir=/local/mysql-data/BDB 
   #bdb_max_lock=10000 
   # Replication of Slave 
   #server-id=2 
   #master-host=administerix 
   #master-user=repl 
   #master-password=repl 
   #master-info-file=/local/mysql-data/logs/master.info 
   # MySQL 4.x 
   #relay-log=/local/mysql-data/logs/slave-bin.log 
   #relay-log-info-file=/local/mysql-data/logs/slave-info 

   ---

   Note - If you are running multiple slaves, please ensure that the parameters server-id and socket differ for all the MySQL resources.

   ---

6. Change the ownership of the MySQL data directory.

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

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

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