TU Darmstadt / ULB / TUbiblio

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

Konrad, M. and Burandt, C. and Enders, J. and Pietralla, N. (2012):
Control System Studio archiver with PostgreSQL back-end: Optimizing performance and reliability for a production environment.
In: Proceedings of the International Workshop on Personal Computers and Particle Accelerator Controls, Kolkata, India (2012), [Online-Edition: http://accelconf.web.cern.ch/AccelConf/pcapac2012/papers/wep...],
[Conference or Workshop Item]

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.

Item Type: Conference or Workshop Item
Erschienen: 2012
Creators: Konrad, M. and Burandt, C. and Enders, J. and Pietralla, N.
Title: Control System Studio archiver with PostgreSQL back-end: Optimizing performance and reliability for a production environment
Language: English
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.

Uncontrolled Keywords: S-DALINAC, Controls, EPICS, Data Base, SFB634, E1
Divisions: 05 Department of Physics
05 Department of Physics > Institute of Nuclear Physics
Event Title: Proceedings of the International Workshop on Personal Computers and Particle Accelerator Controls, Kolkata, India (2012)
Date Deposited: 11 Feb 2014 10:18
Official URL: http://accelconf.web.cern.ch/AccelConf/pcapac2012/papers/wep...
Export:
Suche nach Titel in: TUfind oder in Google

Optionen (nur für Redakteure)

View Item View Item