Show Children Hide Children

Data Management
Last Page Update


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).


  • 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


  • 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 ( 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 and to
  • 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.


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.


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 archivetar MySQLOracleMigration.tar r1 manage 130.0 K 2008-01-24 - 15:13 LanaAbadie source code to migrate a MySQL DB to an Oracle DB
Edit | Attach | Watch | Print version | History: r7 < r6 < r5 < r4 < r3 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r5 - 2008-01-24 - 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-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback