How to split a database backend.

Purpose

This procedure describes how to take a backend database with multiple VOs in it, and remove a single VO from it. putting the VO into its own database account.

Roles

This procedure is for LFC Administrators.

Required Information and Materials

Field Purpose
Account name of current DB backend To be communicated to DB Team
Proposed account name and password of new DB backend To be communicated to DB Team
Alias name of the VO that is to be moved To know which daemons to shut down
passwordfile for SINDES To update with the new NSCONFIG details

Referred Documents

Keyword Description

Preparations

  • Before starting the procedure, you need to get a new database account created. To do this, contact physics-database.support@cernNOSPAMPLEASE.ch and ask for a new account to be created on the LCG RAC. Also request that they will need to make a backup of the current DB backend, and apply it to the new database account during the intervention.

  • Once you have the new database account, you need to do the following:
    • setup the password on the new account using sqlplus
    • update the SINDES config file with the new account details, and upload into SINDES.

  • You should announce the intervention via the EGEE Broadcast system.

Activities

For the intervention:
  • Identify the nodes for the VO to be moved, and use sms to put them into maintenance.

  • Stop the lfcdaemons for the VO to be moved.
  • Ask the DB team to take the hot backup, and apply it to the new account.
  • Run the SINDES NCM component to get the new NSCONFIG (check it in /opt/lcg/etc)

After the intervention, you need to clean up the entries from the two catalogs.

Checking Completion

Use the LFC CLI tools to check the right entries are in the right databases.

After Completion

Error Action
any CAll LFC Expert
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2006-08-29 - JamesCasey
 
    • 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