Author: Hamano, T.
Paper Title Page
TUPPC013 Scaling Out of the MADOCA Database System for SACLA 574
 
  • T. Hirono, T. Hamano, A. Yamashita
    JASRI/SPring-8, Hyogo-ken, Japan
  • T. Fukui, K. Hagihara, T. Maruyama, K. Nemoto, M. Yamaga
    RIKEN/SPring-8, Hyogo, Japan
 
  MADOCA was adopted for the control system of SACLA, and the MADOCA database system was designed as a copy of the database system in SPring-8. The system realized a high redundancy because the system had already tested in SPring-8. However the signals which the MADOCA system handles in SACLA are increasing drastically. And GUIs that require frequent database accesses were developed. The load of the database system increased, and the response of the systems delayed in some occasions. We investigated the bottle neck of the system. From the results of the investigation, we decided to distribute the access to two servers. The primary server handles present data and signal properties. The other handles archived data, and the data was mounted to the primary server as a proxy table. In this way, we could divide the load into two servers and clients such as GUI do not need any changes. We have tested the load and response of the system by adding 40000 signals to present 45000 signals, of which data acquisition intervals are typically 2 sec. The system was installed successfully and operating without any interruption which is caused by the high load of the database.