WARNING: This web is not used anymore. Please use PDBService.DatabaseIntegrationService instead!

Using the Integration Service

Service Description

The Integration Service facilitates the second step in the development process of a database application. Its goal is to provide a testing ground for developed applications before they are deployed to the production services.

The Physics Databases Services team maintains a set of Oracle RAC systems reserved for the Integration Service. For the time being these RACs are:

  • intr (2 nodes - Integration RAC for ATLAS)
  • int2r (2 nodes - Integration RAC for CMS)
  • int3r (2 nodes - Integration RAC for LCG)
  • int4r (2 nodes - Integration RAC for LHCb)
  • int5r (5 nodes)

In order to use the service the responsible for the application under testing should contact us and request a time slot (usually week) for tests. It is absolutely necessary to provide the expected data volume (>50 GB) and the number of expected simultaneous connections (>50). Moreover, during the testing a workload should be generated that it should be simulating the production level.

Mandatory checks

  • Before using the service it should be made sure that the checklist for a well-written Oracle application has actually been followed. Note that for applications based on CORAL many of the best practices are internally implemented, or guided by the design of the API; however the user must still follow the proposed guidelines, especially when the schema is defined or updated.

  • During the running of the tests using the Integration Service it should be demonstrated that the application should be able to handle gracefully some cases where a database node, the listener or the instance is temporarily or permanently unavailable.

Edit | Attach | Watch | Print version | History: r6 | r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r2 - 2007-01-09 - IoannisPapadopoulos
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup 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.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback