This page last changed on Feb 02, 2011 by sruiz.

To switch to a MySQL Enterprise Server, install MySQL Enterprise Server and follow the steps below. Please note that during the migration of database servers, the FishEye instance will not be available to users or to external API clients.

 

Install and Create a MySQL Database

  1. The JDBC drivers for MySQL Enterprise Server are bundled with FishEye. Skip to step 2 if this meets your needs. If you want to install a specific, different version of the bundled JDBC driver, download the MySQL Enterprise Server JDBC driver (a .jar file) from the download website and copy the .jar file to your FISHEYE_INST/lib directory (create the lib/ directory if it doesn't already exist). Move the existing JDBC .jar file to another location (and back it up). Restart FishEye or Crucible to have it pick up the new driver.

  2. Create a UTF-8 Database:
    CREATE DATABASE fisheye CHARACTER SET utf8 COLLATE utf8_bin;


  3. You will also need to set the Server Characterset to utf8. This can be done by adding the following in my.ini for Windows or my.cnf for other operating systems. It has to be declared in the Server section, which is the section after [mysqld]:
    [mysqld]
    character-set-server=utf8
    


  4. Use the status command to verify database character encoding information:
    Screenshot: Using the MySQL Enterprise Server Status Command


  5. Create a user that can log in from the host that Crucible or FishEye is running on and make sure that the user has full access to the newly created database. In particular, the user should be allowed to create and drop tables, indexes and other constraints.

    For instance, when FishEye and MySQL Enterprise Server run on the same machine (accessible through localhost), issue the following commands (replacing username and password with the appropriate values):
    mysql> grant all on fisheye.* to 'username'@'localhost' identified by 'password';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)
    

 

Configure FishEye to use MySQL, and Migrate Data

In order to migrate to a different database backend, you must create a backup of sql data, configure the database and finally import the data via a backup restoration process. This can be done from either the FishEye administration console, which streamlines the process, or via the command line tool which FishEye provides.

From FishEye's Administration

  1. Navigate to the Database page in FishEye's Administration console

  2. Then click 'Test Connection' to verify that Crucible or FishEye can log in to the database:

  3. Select MySQL from the database type

  4. Fill in the appropriate fields, replacing the host, port, database name, username and password as required

  5. Click on Test Connection to validate the values

    Screenshot: Testing the Connection


    If this fails, verify that you have the MySQL Enterprise Server JDBC driver .jar file in the classpath (by placing the .jar file in FISHEYE_INST/lib). Also, ensure that the database user can log in to the database from the machine that Crucible or FishEye is running on and that all the required privileges are present.

  6. Click 'Save & Migrate Data' to start the migration process.

    During the migration process (which will take several minutes, depending on the size of your database and network throughput), the product will be inaccessible to users and external API clients. Users will see a maintenance screen that informs them of the process. Should the migration fail for any reason, FishEye will not switch to the new database and report on the encountered problems. Because the destination database may now contain some, but not yet all data, drop all tables, indexes and constraints before attempting a new migration.

    Screenshot: Migrating the Database

From the command line

  1. Create a backup of the sql data from the FishEye instance. Information on how to create a backup can be found at Backing Up and Restoring FishEye Data

  2. Run the following command from the bin directory in FISHEYE_INST
    $ ./fisheyectl.sh restore --sql \
            --file /path/to/backup.zip \
            --dbtype mysql \
            --jdbcurl jdbc:mysql://hostname/dbname \
            --username crucible \
            --password password
    



  3. When the import is complete, FishEye can be started and will use MySQL

 

Further Resources

Troubleshooting Databases


Document generated by Confluence on Apr 03, 2011 23:09