Objectives:

Your LFC/DPM MySQL DB is growing fast and the performance of your DB is decreasing. One solution is to migrate to Oracle. An C-application has been written to permit the site admin to perform this operation. So the application creates the oracle schema using the LFC/DPM table schema script (which should map the LFC MySQL, i.e. same version).

Prerequisites:

  • Linux OS
  • mysqlclient
  • sqlplus
  • sqlloader
  • OCI (oracle instant client)
  • the sql script which creates and drops the Oracle schema (should match the MySQL schema)
  • The LFC service should be stopped

Installation

  • create a new directory
  • download the tar file (available at the bottom of the page)
  • unzip the tar. It is composed of 3 files (readme, config_file.data and MigrateLFC)
  • fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column)
  • Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so
  • chmod +x MigrateLFC
  • launch the application ./MigrateLFC

if one error occurs, the policy is to drop the Oracle schema and DB and goes to the initial state.

Files

The application generates log files which give information about loading data. There is also a log file for the application (MigrateLFC_logfile.log). If the migration has been successful, all the log files can be deleted. This operation has to be done manually.

Remark

The application does not drop the MySQL DB even if the application is successful.

-- LanaAbadie - 07 May 2007

Topic attachments
I Attachment History Action Size Date Who Comment
Compressed Zip archivetgz MigrationMySQLOracle.tgz r1 manage 113.9 K 2007-05-07 - 10:24 LanaAbadie Application to migrate a table schema from MySQL to Oracle
Edit | Attach | Watch | Print version | History: r7 | r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r2 - 2007-06-14 - SophieLemaitre
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback