TU Darmstadt / ULB / TUbiblio

Control System Studio archiver with PostgreSQL back-end: Optimizing performance and reliability for a production environment

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 Frage zum Eintrag

Optionen (nur für Redakteure)
Redaktionelle Details anzeigen Redaktionelle Details anzeigen