Enabling Grids for Escienc E GOCDB 3 Progress

Enabling Grids for E-scienc. E GOCDB 3 Progress Report Matt Thorpe, Andy Newton COD 11 - Athens www. eu-egee. org EGEE-II INFSO-RI-031688 EGEE and g. Lite are registered trademarks

Overview Enabling Grids for E-scienc. E • Overview – Database development § Improvements § New Schema § Migration from GOCDB 2 – hardware platform – Code development § Core classes § User Interface – Failover system – Summary EGEE-II INFSO-RI-031688 COD-11, Athens 2

Database Development (1) Enabling Grids for E-scienc. E • Improved back end database – Migrated schema from My. SQL 4. x to Oracle 9 i – Schema is now fully normalised with referential integrity – Supports storing information on VO related services on individual nodes – Expanded to include support for multiple grids, finer granularity for downtimes, more flexibility in user roles and more scope for storing historical data and metrics regarding sites, nodes and services – Includes a collection of PL/SQL functions to facilitate and simplify migration of third party applications to – Finalised schema available to view on GOC wiki at http: //goc. grid. sinica. edu. tw/gocwiki/GOCDB 3_development EGEE-II INFSO-RI-031688 COD-11, Athens 3

Database Development (2) Enabling Grids for E-scienc. E • schema finalised – May have minor changes during development but basic structure will not change – Library of PL/SQL functions is small at present but growing – All PL/SQL functions will be available to 3 rd party application developers • Metadata migration tools complete – We have developed a migration package to convert metadata from the current production GOCDB 2 system to the new framework. This will allow us to transition to the new framework smoothly and without loss of data – Migration between schemas takes less than 1 minute using this package EGEE-II INFSO-RI-031688 COD-11, Athens 4

GOCDB 3 – DB Schema Enabling Grids for E-scienc. E EGEE-II INFSO-RI-031688 COD-11, Athens 5

GOCDB 3 Platform Enabling Grids for E-scienc. E • Server status – The 2 new servers have been acquired and installed. However we are still developing the local failover system in collaboration with our sysadmins – Registered ‘gocdb. eu’ domain name – Development is currently underway on a third development platform – Software platform requirements have been finalised and will be deployed to the production machines shortly – Timescale for migration from development to production is anticipated to take approximately 1 week EGEE-II INFSO-RI-031688 COD-11, Athens 6

Code Development Enabling Grids for E-scienc. E • Streamlined codebase – Complete rewrite of GOCDB 2 code using PHP 5 – Utilising ADODB database API for rapid development § Allows us to reduce coding overhead for DB operations § Allows the use of alternate databases during development • Can support this in production but due to failover requirements we will only be supporting Oracle. This may change in the future! – – – Improved error checking and exception handling architecture Developed using Model – View – Controller architecture Fully OO code Shorter development lifecycle with modular code Multiple abstraction levels enable rapid integration of new solutions EGEE-II INFSO-RI-031688 COD-11, Athens 7

Code Development – Core classes Enabling Grids for E-scienc. E • Core classes – Structure of the core classes has been completed but full functionality has not yet been achieved (i. e. we haven’t finished yet) – Improved QA process on business logic components § Multi-level unit and group testing framework § Structured testing schedule § New development environment facilitates improved debugging – We anticipate completion of these classes in around 4 -6 weeks EGEE-II INFSO-RI-031688 COD-11, Athens 8

Code Development - User Interface Enabling Grids for E-scienc. E • Redesigned user interface – Professionally developed graphical look and feel – Navigation and layout is being completely redesigned for improved user experience and to make it more intuitive – Will include: § Breadcrumbs for faster navigation § Context sensitive help system § CSS style and layout (GOCDB 2 used basic HTML / tables) – Utilising the PHP Smarty template engine to speed up interface development – Can support AJAX via the SAJAX framework – Implementation of basic interface is anticipated to take approximately 2 -4 weeks, with more advanced features to follow EGEE-II INFSO-RI-031688 COD-11, Athens 9

Code Development - User Interface Enabling Grids for E-scienc. E Initial site design EGEE-II INFSO-RI-031688 COD-11, Athens 10

Code Development - User Interface Enabling Grids for E-scienc. E Test page with development banner, showing off the new rounded boxes EGEE-II INFSO-RI-031688 COD-11, Athens 11

Failover system Enabling Grids for E-scienc. E • Multiple DB, multiple UI architecture – Geographically distributed backend DBs § Oracle 9 i or better – Distributed UI installs, not necessarily at same sites as the DBs § Software requirements for UI installs are modest: • Apache 2. x • PHP 5. x • PHP APIs (Oracle oci 8, ADODB, smarty) o (These may come packaged with GOCDB 3 for ease of install) – Need to investigate methods of failover between DBs and UIs as well as replication modes between Oracle resources EGEE-II INFSO-RI-031688 COD-11, Athens 12

Summary Enabling Grids for E-scienc. E • – New features – – – Improved availability with failovers Support for multiple grids (not just EGEE) Allows services to be associated with VOs Allows resources (sites, nodes, services) to be logically grouped More flexible roles / permission system allowing fine grained access from a whole grid down to a service level – Major improvements to scheduled downtimes § Can now be scheduled or unscheduled, have varying degrees of severity and be extended / shortened in an intelligent manner – Improved storage of historical data for metrics purposes – Simplified integration with third party applications through PL/SQL function library – Improved globalisation support EGEE-II INFSO-RI-031688 COD-11, Athens 13

Enabling Grids for E-scienc. E Thank you for listening Any questions? EGEE-II INFSO-RI-031688 COD-11, Athens 14