Show Children Hide Children

Data Management
Main
Talks
Components
FTS
LFC
DPM
lcg_util/GFAL
Medical
Last Page Update
LanaAbadie
2008-05-14

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 (mysql-devel needed)
  • sqlplus
  • sqlloader
  • OCI (oracle instant client devel version, basic not enough)
  • 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 (tar xzvf).Omit the complaints. It is composed of :
    • src directory with all the sources
    • incl directory with the header
    • readme file (similar to the wiki page)
    • output directory (config_file.data to be filled in and the application MigrateLFC will be here)
    • Makefile (must be edited to put the correct location of the oracle and mysql lib)
  • 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. The pwd of DBs are removed from the config_file.data

FAQ

1. How do i fill these two variables create_ora_schema_path and drop_ora_schema_path? create_ora_schema_path=/home/oracle/Migration-LFC-MySQL-Oracle-v2/Cns_oracle_tbl.sql; drop_ora_schema_path=/home/oracle/Migration-LFC-MySQL-Oracle-v2/Cns_oracle_drop.sql; 2. Is there any log file? Yes, have look at output/MigrateLFC_logfile.log 3. I can't find the include files for oracle be sure you have installed oracle-instantclient-devel (the basic one is not sufficient if you need to compile the application). 4. make doesn't work Be sure you have done make clean and edited properly the makefile (ORA_INSTANTINCL, ORA_LIBS, MYSQL_LIBS and MYSQL_HOME). If still doesn't work, send me an email. -- LanaAbadie - 07 May 2007
Topic attachments
I Attachment History Action Size Date Who CommentSorted ascending
Compressed Zip archivetar MySQLOracleMigration.tar r1 manage 480.0 K 2008-04-01 - 10:15 LanaAbadie source files
Edit | Attach | Watch | Print version | History: r7 < r6 < r5 < r4 < r3 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r7 - 2008-05-14 - LanaAbadie
 
    • 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