Stages of database applications development

Development

• 8/5 monitoring and availability
• DBA consultancy by e-mail
• limited database space (maximum 500MB)

To have an account on development level service:

• have a CERN NICE account
• fill the form provided by IT/DES on the web

Integration

• 8/5 monitoring and availability
• DBA consultancy by e-mail, phone for optimize application
• Dedicated node for testing application performance with expected data volume and concurrency

The integration level goal:

• test application's behavior under the workload similar to the expected production one

The application development team's role is:

• to provide workload simulating tools, generating the traffic as similar to the production conditions as possible
• to ask for a slot time (usually week) for tests
• to run tests

Production

• 24/7 monitoring and availability
• Backups every 10 minutes
• Limited number and scheduled planned interventions

To move to production level service is necessary to provide:

• database schema
• security plans (use of reader/writer or roles)
• data volume expected for next 2 years
• expected simultaneous connections
• reference workload (script) and reference running time of it
• if (volume expected > 50 GB) or (simultaneous connections > 50) then should pass also a test on integration phase

-- MiguelAnjo - 08 Apr 2005