PCaPAC2012 - List of Authors (Sarkar, D.)

Paper

Title

Page

EPICS MySQLArchiver - Integration Between EPICS and MySQL

109

A. Roy, R.B. Bhole, S. Pal, D. Sarkar
VECC, Kolkata, India

The performance evaluation and analysis of inter-system dependency of the various subsystems of the Superconducting Cyclotron demand a well configured data logging, archiving and historic analysis facility for massive number of control parameters along with on-line failure analysis facility of every system. EPICS is used as development architecture of the control system of these systems with MySQL used as database for large amount of relational data management. This combination requires integration between EPICS and MySQL server. For this purpose, MySQLArchiver as an EPICS Extension is developed for data logging and archiving of control parameters into MySQL database. This extension also provides a web based tool for online monitoring of control parameters and historic analysis of archived data. This paper describes the software architecture, implementations, as well as method of configuration for any other EPICS based control system as a utility. This facility is also elaborated with examples, web page views and experiences of deploying it in SCC.

Slides THCB02 [0.781 MB]

THPD11

Facility Monitoring System using Storage Area Network for VEC and SCC

157

T. Bhattacharjee, R.B. Bhole, K. Datta, S. Pal, A. Roy, T. Samanta, D. Sarkar, Mr. Saxena
VECC, Kolkata, India

The facility monitoring system of cyclotron operational parameters at VECC is developed and commissioned recently. Storage Area Network(SAN) is used to isolate the control LAN and office LAN which ensures secured access of the control systems from outside world. EPICS gateway service and modified channel access save/restore tool have been used to integrate EPICS based control system of VEC and SCC with office network. This paper describes the implementation details and operational experiences of the overall facility monitoring system.

Paper	Title	Page
THCB02	EPICS MySQLArchiver - Integration Between EPICS and MySQL	109
	A. Roy, R.B. Bhole, S. Pal, D. Sarkar VECC, Kolkata, India
	The performance evaluation and analysis of inter-system dependency of the various subsystems of the Superconducting Cyclotron demand a well configured data logging, archiving and historic analysis facility for massive number of control parameters along with on-line failure analysis facility of every system. EPICS is used as development architecture of the control system of these systems with MySQL used as database for large amount of relational data management. This combination requires integration between EPICS and MySQL server. For this purpose, MySQLArchiver as an EPICS Extension is developed for data logging and archiving of control parameters into MySQL database. This extension also provides a web based tool for online monitoring of control parameters and historic analysis of archived data. This paper describes the software architecture, implementations, as well as method of configuration for any other EPICS based control system as a utility. This facility is also elaborated with examples, web page views and experiences of deploying it in SCC.
	Slides THCB02 [0.781 MB]

THPD11	Facility Monitoring System using Storage Area Network for VEC and SCC	157
	T. Bhattacharjee, R.B. Bhole, K. Datta, S. Pal, A. Roy, T. Samanta, D. Sarkar, Mr. Saxena VECC, Kolkata, India
	The facility monitoring system of cyclotron operational parameters at VECC is developed and commissioned recently. Storage Area Network(SAN) is used to isolate the control LAN and office LAN which ensures secured access of the control systems from outside world. EPICS gateway service and modified channel access save/restore tool have been used to integrate EPICS based control system of VEC and SCC with office network. This paper describes the implementation details and operational experiences of the overall facility monitoring system.