Using MySQL Database Software with N1 Grid Engine

The Accounting and Reporting Console uses views, As a result, the console supports MySQL database version 5.0.x and higher. For more information on the MySQL database software, see the MySQL documentation .

Case Sensitivity in MySQL Database

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory. Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. Therefore, database and table names are case sensitive in most varieties of UNIX, and not case sensitive in Windows.

How to Install MySQL Database on UNIX Systems

1. Download the appropriate MySQL software for your system from http://www.mysql.com.

   The standard installation directory for UNIX systems is /usr/local/mysql. If you install the software into a different directory, you have to change the settings for the scripts provided in the package.

   ---

   Note –

   ARCo is a Java web-based application and needs the Java^TM DataBase connectivity (JDBC^TM) driver for converting JDBC calls into the network protocol used by the MySQL database. You can download the JDBC driver from http://www.mysql.com/products/connector.

   ---

2. Create a symbolic link from the installation directory to mysql.

   # ln -s $installation_directory/mysql-standard-5.0.26-solaris10-i386 mysql

   The mysql directory contains several files and subdirectories:

   • The bin subdirectory contains client programs and the server.

     • The MySQL server and server startup scripts:

       • mysqld is the MySQL server.

       • mysqld_safe, mysql.server, and mysqld_multi are server startup scripts.

       • mysql_install_db initializes the data directory and the initial databases.

       • mysqlmanager is the MySQL instance manager.

     • Client programs that access the server:

       • mysql is a command-line client for executing SQL statements interactively or in batch mode.

       • mysqladmin is an administrative client.

       • mysqlcheck performs table maintenance operations.

       • mysqldump and mysqlhotcopy make database backups.

       • mysqlimport imports data files.

       • mysqlshow displays information about databases and tables.

     • Utility programs that operate independently of the server:

       • myisamchk performs table maintenance operations.

       • myisampack produces compressed, read-only tables.

       • mysqlbinlog is a tool for processing binary log files.

       • perror displays the meaning of error codes.

   • The scripts subdirectory contains the mysql_install_db script used to initialize the mysql database containing the grant tables that store the server access permissions.

3. Add a login user and group for mysqld.

   # groupadd mysql # useradd -g mysql mysql

4. Change the ownership of program binaries to root and ownership of the data directory to the user that you use to run mysqld.

   # chown -R root . # chown -R mysql data # chgrp -R mysql .

5. Create the MySQL grant tables.

   # scripts/mysql_install_db --user=mysql

6. Start the MySQL server.

   # bin/mysqld_safe --user=mysql &

7. Assign the root password.

   # ./bin/mysqladmin -u root password 'new-password' # ./bin/mysqladmin -u root -h ${hostname} password 'new-password'

MySQL Installation Tips

• To start the MySQL server at boot time, copy support-files/mysql.server to /etc/init.d and link it to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. If MySQL is not installed in /usr/local/mysql., edit the file to change the basedir and datadir variables.

• Add the full pathname of this directory to your PATH environment variable so that your shell finds the MySQL programs properly.

How to Set Up Accounting and Reporting Database in MySQL

1. Log in to the database as a superuser.

   # mysql -u root -p<password>

2. Create user and grant privileges for arco_read and arco_write.

   mysql> GRANT ALL on *.* to 'arco_write'@'<hostname>' identified by '<password>' with GRANT OPTION;
   mysql> GRANT ALL on *.* to 'arco_write'@'localhost' identified by '<password>' with GRANT OPTION;
   mysql> GRANT ALL on *.* to 'arco_write'@'%' identified by '<password>' with GRANT OPTION;
   
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'<hostname>' identified by '<password>';
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'localhost' identified by '<password>';
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'%' identified by '<password>';

3. Log in to the database as arco_write user.

   # mysql -u arco_write -p<password>

4. Create the accounting and reporting database.

   mysql> CREATE DATABASE ARCO;

5. Install the Accounting and Reporting Software.