MySQL DBA - Tips and Techniques Magazine

13 Nov 2014


  1. Download the correct version.  There are two versions – a tar file and a package.  The package version installs as part of the Solaris OS , but then means we can have no further mysql installs.  So we tend to download the tar version e.g. mysql-advanced-gpl-5.1.47-solaris10-x86_64.tar


  1. Put the download into the bin directory eg /ebilldb-master/mysql-bin


  1. untar the download file, this creates a directory called mysql-advanced-gpl-5.1.47-solaris10-x86_64


  1. change permissions i.e.


chown -R mysql:mysql mysql-advanced-gpl-5.1.47-solaris10-x86_64


  1. create a softlink to the untarred directory called mysql 


ln -s mysql-advanced-gpl-5.1.47-solaris10-x86_64 mysql



  1. copy a my.cnf and put into the  …/mysql-data dir
  2. edit the my.cnf

-change the bind address to the same as that in /etc/hosts

- change the path names

- if it's a slave then make sure the server-id is different from the master


  1. Populate the mysql Database Tables and check logs for any errors


cd …/mysql-bin/mysql


      ./scripts/mysql_install_db --user=mysql --basedir=/ebilldb-master /mysql-bin/mysql --datadir=/ ebilldb-master /mysql-data --defaults-file=/ ebilldb-master /mysql-data/my.cnf




No comments:

Post a Comment