Verifying the Installation and Configuration of MySQL

This section contains the procedure you need to verify the installation and configuration.

How to Verify the Installation and Configuration of MySQL

This procedure does not verify that your application is highly available because you have not yet installed your data service.

Before verifying the installation and configuration of MySQL, ensure that the Logical Hostname for the mysql is available. You will need to complete the steps 1 to 6 the task How to Register and Configure Sun Cluster HA for MySQL as a Failover Service in a Global Zone Configuration, the steps 1 to 7 in the task How to Register and Configure Sun Cluster HA for MySQL as a Failover Service in a Failover Zone Configurationor the step 1 to 7 in the task How to Register and Configure Sun Cluster HA for MySQL as a Failover Service in a Zone Configuration according to your zone type.

1. (Optional) Log in to your target zone.

   # zlogin mysql-zone

2. Start the MySQL Server for this instance.

   #cd <MySQL Base directory>

   # ./bin/mysqld --defaults-file=<MySQL Database directory>/my.cnf \ --basedir=<MySQL Base directory>\ --datadir=<MySQL Databasedirectory>\ --user=mysql --pid-file=<MySQL Database directory>/mysqld.pid &

3. Connect to the MySQL instance.

   # <MySQL Base directory>/bin/mysql -S /tmp/<Logical host>.sock -uroot

4. Stop the MySQL server instance.

   # kill -TERM `cat <MySQL Database directory>/mysqld.pid

5. (Optional) Leave the target zone.