Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

Difference between revisions of "GOCDB"

From EGIWiki
Jump to navigation Jump to search
Line 1: Line 1:
{{Template:Op menubar}}
{{Template:Op menubar}} {{Template:Tools menubar}} {{TOC_right}}  
{{Template:Tools menubar}}
 
{{TOC_right}}
<br> Grid Configuration Database (GOCDB) contains general information about the sites participating to the production Grid. Accessed by all the project actors (end-users, sitemanagers, NGI mangers, support teams, VO managers), by other tools and by third party middleware in order to get Grid topology. The portal has a single central installation but interested NGIs can download and install their own instance.
[[Category:Tools]]
 
<br>


GOC DB is one of [[Core EGI Activities|EGI&nbsp;core services and]] part of [http://www.egi.eu/services/catalogue/fed-ops.html EGI&nbsp;Federated Operations service].


Grid Configuration Database (GOCDB) contains general information about the sites participating to the production Grid. Accessed by all the project actors (end-users, sitemanagers, NGI mangers, support teams, VO managers), by other tools and by third party middleware in order to get Grid topology. The portal has a single central installation but interested NGIs can download and install their own instance.




Line 15: Line 16:
| '''Tool Category and description'''  
| '''Tool Category and description'''  
| ''EGI Core service''  
| ''EGI Core service''  
(GOCDB) is a central registry to record information about different entities such as the Operations Centres, the Resource Centres, service endpoints and the contact information and roles of people responsible for operations at different levels.
(GOCDB) is a central registry to record information about different entities such as the Operations Centres, the Resource Centres, service endpoints and the contact information and roles of people responsible for operations at different levels.  
 
|-
|-
| '''Tool url'''  
| '''Tool url'''  
| http://gocdb.egi.eu/ (primary instance) http://goc.dl.ac.uk (failover) <br>
| http://gocdb.egi.eu/ (primary instance) http://goc.dl.ac.uk (failover) <br>
|-
|-
| '''Email'''  
| '''Email'''  
| gocdb-admins@mailman.egi.eu  
| gocdb-admins@mailman.egi.eu
|-
|-
| '''GGUS Support unit'''  
| '''GGUS Support unit'''  
Line 27: Line 29:
|-
|-
| '''GOC&nbsp;DB&nbsp;entry'''  
| '''GOC&nbsp;DB&nbsp;entry'''  
| https://goc.egi.eu/portal/index.php?Page_Type=Site&id=335
| https://goc.egi.eu/portal/index.php?Page_Type=Site&amp;id=335
|-
|-
| '''Requirements tracking - EGI tracker'''  
| '''Requirements tracking - EGI tracker'''  
Line 36: Line 38:
|-
|-
| '''Release schedule'''  
| '''Release schedule'''  
| [[GOCDB/Release_Schedule]]
| [[GOCDB/Release Schedule]]
|-
|-
| '''Release notes'''  
| '''Release notes'''  
Line 51: Line 53:
|-
|-
| '''Documentation'''  
| '''Documentation'''  
| [[GOCDB/Documentation_Index]]
| [[GOCDB/Documentation Index]]
|-
|-
| '''License'''  
| '''License'''  
Line 67: Line 69:


= Change, Release and Deployment  =
= Change, Release and Deployment  =
This sections are providing detailed agreement in terms of requirements gathering, release and deployment of GOC DB which extend [[Instructions for Operations Tools teams|Instructions for Operations Tools teams]]


This sections are providing detailed agreement in terms of requirements gathering, release and deployment of GOC DB which extend [[Instructions for Operations Tools teams|Instructions for Operations Tools teams]]
<br>


#All requirements are gathered in EGI Request Tracker  
#All requirements are gathered in EGI Request Tracker  
#Prioritization and testing is done by development team, in case of need separated OTAG team will be introduced
#Prioritization and testing is done by development team, in case of need separated OTAG team will be introduced  
#EGI RT statuses of requests are as follow  
#EGI RT statuses of requests are as follow  
#*New - newly recorded in system  
#*New - newly recorded in system  
Line 78: Line 82:
#*Open - (In progress) development team is implementing change<br>  
#*Open - (In progress) development team is implementing change<br>  
#*Resolved - released  
#*Resolved - released  
#*Stalled - on hold
#*Stalled - on hold  
#Priority of requests are as follow  
#Priority of requests are as follow  
#*None - 0  
#*None - 0  
Line 93: Line 97:
#*Frequency: every 2-3 months
#*Frequency: every 2-3 months


= Documentation=
= Documentation =


[[GOCDB/Documentation_Index| Enter GOCDB Documentation Index Here]]
[[GOCDB/Documentation Index|Enter GOCDB Documentation Index Here]]  


== Extract information from GOCDB ==
== Extract information from GOCDB ==
Information is extracted by means of the [[GOCDB/PI/Technical_Documentation#Interface_description|GOCDB Programmatic Interface]]


===  Service end-points ===
Information is extracted by means of the [[GOCDB/PI/Technical Documentation#Interface_description|GOCDB Programmatic Interface]]  
* Find GOCDB service endpoints [[GOCDB/Input_System_User_Documentation#Service_types |by service type]]
* Find all service-end points that are [https://goc.egi.eu/gocdbpi/private/?method=get_service_endpoint&monitored=N NOT monitored]


=== Resource Centres ===
=== Service end-points  ===
Find sites in GOCDB by status:
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Certified Certified] Resource Centres
* Find all Certified sites in a given NGI/EIRO. Example: [https://goc.egi.eu/gocdbpi/public/?method=get_site_list&roc=NGI_DE&certification_status=Certified NGI_DE]
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Candidate Candidate] Resource Centres
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Suspended Suspended] Resource Centres
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Uncertified Uncertified] Resource Centres
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site&scope=Local Local] Resource Centres (i.e. outside of the EGI scope)
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&production_status=Test&certification_status=Certified Test/Certified] Resource Centres
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&production_status=Test&certification_status=Uncertified Test/Uncertified] Resource Centres


* Get status transition of a site: [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_changes&site=MK-03-FINKI example]
*Find GOCDB service endpoints [[GOCDB/Input System User Documentation#Service_types|by service type]]
*Find all service-end points that are [https://goc.egi.eu/gocdbpi/private/?method=get_service_endpoint&monitored=N NOT monitored]


* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&certification_status=Certified&scope=Local Certified/Local] Resource Centres
=== Resource Centres ===
* Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&certification_status=Uncertified&scope=Local Uncertified/Local] Resource Centres


*[[Grid_operations_oversight/CandidateSuspendedSitesList|List]] of CANDIDATE/SUSPENDED sites waiting to be certified
Find sites in GOCDB by status:


=== Status transitions ===
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Certified Certified] Resource Centres
Get status transition of a site: [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_changes&site=MK-03-FINKI example]
*Find all Certified sites in a given NGI/EIRO. Example: [https://goc.egi.eu/gocdbpi/public/?method=get_site_list&roc=NGI_DE&certification_status=Certified NGI_DE]
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Candidate Candidate] Resource Centres
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Suspended Suspended] Resource Centres
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_date&certification_status=Uncertified Uncertified] Resource Centres
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site&scope=Local Local] Resource Centres (i.e. outside of the EGI scope)
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&production_status=Test&certification_status=Certified Test/Certified] Resource Centres
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&production_status=Test&certification_status=Uncertified Test/Uncertified] Resource Centres


=== Service groupings ===
*Get status transition of a site: [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_changes&site=MK-03-FINKI example]
* [https://goc.egi.eu/gocdbpi/public/?method=get_service_group List]
 
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&certification_status=Certified&scope=Local Certified/Local] Resource Centres
*Find all [https://goc.egi.eu/gocdbpi/private/?method=get_site_list&certification_status=Uncertified&scope=Local Uncertified/Local] Resource Centres
 
*[[Grid operations oversight/CandidateSuspendedSitesList|List]] of CANDIDATE/SUSPENDED sites waiting to be certified
 
=== Status transitions  ===
 
Get status transition of a site: [https://goc.egi.eu/gocdbpi/private/?method=get_cert_status_changes&site=MK-03-FINKI example]
 
=== Service groupings ===
 
*[https://goc.egi.eu/gocdbpi/public/?method=get_service_group List]
 
[[Category:Tools]]

Revision as of 14:32, 20 March 2015

Main EGI.eu operations services Support Documentation Tools Activities Performance Technology Catch-all Services Resource Allocation Security


Tools menu: Main page Instructions for developers AAI Proxy Accounting Portal Accounting Repository AppDB ARGO GGUS GOCDB
Message brokers Licenses OTAGs Operations Portal Perun EGI Collaboration tools LToS EGI Workload Manager




Grid Configuration Database (GOCDB) contains general information about the sites participating to the production Grid. Accessed by all the project actors (end-users, sitemanagers, NGI mangers, support teams, VO managers), by other tools and by third party middleware in order to get Grid topology. The portal has a single central installation but interested NGIs can download and install their own instance.


GOC DB is one of EGI core services and part of EGI Federated Operations service.


Tool name Grid Configuration Database (GOCDB)
Tool Category and description EGI Core service

(GOCDB) is a central registry to record information about different entities such as the Operations Centres, the Resource Centres, service endpoints and the contact information and roles of people responsible for operations at different levels.

Tool url http://gocdb.egi.eu/ (primary instance) http://goc.dl.ac.uk (failover)
Email gocdb-admins@mailman.egi.eu
GGUS Support unit GOCDB
GOC DB entry https://goc.egi.eu/portal/index.php?Page_Type=Site&id=335
Requirements tracking - EGI tracker https://rt.egi.eu/rt/Dashboards/5541/GOCDB-Requirements
Issue tracking - Developers tracker https://github.com/GOCDB/gocdb/issues
Release schedule GOCDB/Release Schedule
Release notes Release notes
Roadmap https://wiki.egi.eu/wiki/GOCDB/Release4/Development
Related OLA https://documents.egi.eu/public/ShowDocument?docid=2170
Test instance url https://gocdb-test.esc.rl.ac.uk
Documentation GOCDB/Documentation Index
License gLite/Apache 2
Provider STFC
Notifications GOCDB/notifications
Source code https://github.com/GOCDB/gocdb

Change, Release and Deployment

This sections are providing detailed agreement in terms of requirements gathering, release and deployment of GOC DB which extend Instructions for Operations Tools teams


  1. All requirements are gathered in EGI Request Tracker
  2. Prioritization and testing is done by development team, in case of need separated OTAG team will be introduced
  3. EGI RT statuses of requests are as follow
    • New - newly recorded in system
    • Accepted - accepted by OTAG team
    • Rejected - rejected by OTAG team
    • Open - (In progress) development team is implementing change
    • Resolved - released
    • Stalled - on hold
  4. Priority of requests are as follow
    • None - 0
    • Low - 1
    • Normal - 2
    • High - 3
    • Immediate (i.e. emergency) - 4
  5. Standard changes (routine actions, no need for approval)
    • changes related to database information update
    • bug fixing - restoring service to expected functionality
  6. Emergency changes (implemented without approval but subject of post-review)
    • Security incidents
  7. Releases
    • Frequency: every 2-3 months

Documentation

Enter GOCDB Documentation Index Here

Extract information from GOCDB

Information is extracted by means of the GOCDB Programmatic Interface

Service end-points

Resource Centres

Find sites in GOCDB by status:

  • Get status transition of a site: example
  • List of CANDIDATE/SUSPENDED sites waiting to be certified

Status transitions

Get status transition of a site: example

Service groupings