Konrad, M. ; Burandt, C. ; Enders, J. ; Pietralla, N. (2012)
Control System Studio archiver with PostgreSQL back-end: Optimizing performance and reliability for a production environment.
Proceedings of the International Workshop on Personal Computers and Particle Accelerator Controls, Kolkata, India (2012).
Konferenzveröffentlichung, Bibliographie
Kurzbeschreibung (Abstract)
Archiving systems based on relational databases provide a higher flexibility with regard to data retrieval and analysis than the traditional EPICS Channel Archiver. On the other hand they can suffer from poor performance compared to the Channel Archiver for simple linear data retrieval operations. However, careful tuning of the database management system’s configuration can lead to major performance improvements. Special care must be taken to ensure data integrity following power outages or hardware failures. This contribution describes the hardware and software configuration of an archiving system used in the production environment at the S-DALINAC. It covers performance and reliability aspects of the hardware as well as tuning of the Linux operating system and the PostgreSQL server.
| Typ des Eintrags: | Konferenzveröffentlichung |
|---|---|
| Erschienen: | 2012 |
| Autor(en): | Konrad, M. ; Burandt, C. ; Enders, J. ; Pietralla, N. |
| Art des Eintrags: | Bibliographie |
| Titel: | Control System Studio archiver with PostgreSQL back-end: Optimizing performance and reliability for a production environment |
| Sprache: | Englisch |
| Publikationsjahr: | 2012 |
| Veranstaltungstitel: | Proceedings of the International Workshop on Personal Computers and Particle Accelerator Controls, Kolkata, India (2012) |
| URL / URN: | http://accelconf.web.cern.ch/AccelConf/pcapac2012/papers/wep... |
| Kurzbeschreibung (Abstract): | Archiving systems based on relational databases provide a higher flexibility with regard to data retrieval and analysis than the traditional EPICS Channel Archiver. On the other hand they can suffer from poor performance compared to the Channel Archiver for simple linear data retrieval operations. However, careful tuning of the database management system’s configuration can lead to major performance improvements. Special care must be taken to ensure data integrity following power outages or hardware failures. This contribution describes the hardware and software configuration of an archiving system used in the production environment at the S-DALINAC. It covers performance and reliability aspects of the hardware as well as tuning of the Linux operating system and the PostgreSQL server. |
| Freie Schlagworte: | S-DALINAC, Controls, EPICS, Data Base, SFB634, E1 |
| Fachbereich(e)/-gebiet(e): | 05 Fachbereich Physik 05 Fachbereich Physik > Institut für Kernphysik |
| Hinterlegungsdatum: | 11 Feb 2014 10:18 |
| Letzte Änderung: | 03 Jun 2018 21:25 |
| PPN: | |
| Export: | |
| Suche nach Titel in: | TUfind oder in Google |
 |
Frage zum Eintrag |
Optionen (nur für Redakteure)
 |
Redaktionelle Details anzeigen |
Drucken
Impressum