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.
  • When running the test applications the DBAs should be informed so that they monitor the activities on the database side. In the case of well tuned applications the DBAs should be able to notice:
    • No queries without bind variables.
    • No connections that last for too short.
    • A single physical connection to the database server per application. Oracle allows an application to start several user sessions sharing the same physical connection.
    • Not frequent CPU-intensive operations. If this is the case, the schema and the logic of the application should be reviewed.
  • 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. Note that this requires running the tests in coordination with the DBAs of our team.

Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2007-01-10 - 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