Speakers
Description
The SOLEIL synchrotron has been operating a TANGO-based archiving system continuously since 2006. This system is a critical component of the control infrastructure and is composed of two complementary services:
- A historical archiving service (HDB/TDB) designed for the long-term storage of continuous time-series data from TANGO attributes
- A snapshot archiving service dedicated to the on-demand storage of selected attributes
These services are intensively used by the accelerators, the 29 beamlines, and five laboratories control systems.
Historically, the archiving framework supported backend storage using either MySQL or Oracle relational databases, with Oracle being the primary solution deployed at SOLEIL. Due to increasing licensing costs and long-term sustainability concerns, a decision was made to migrate away from Oracle toward an open-source alternative.
The target solution was selected based on several key constraints and requirements: strong in-house expertise in relational databases and Java, the need for a transparent migration without service interruption, compatibility with existing TANGO archiving tools, and forward compatibility with the planned SOLEIL II upgrade. In this context, PostgreSQL coupled with TimescaleDB was selected as the new backend technology. The migration strategy is based on adopting the HDB++ database schema, while preserving the existing software stack and operational workflows.
This contribution presents:
- An overview of the current usage and operational scale of the SOLEIL TANGO archiving system
- The ongoing migration of the HDB/TDB historical archiving services to TimescaleDB
- The initial phase of the migration of the snapshot archiving service to PostgreSQL
| Tags | archiving |
|---|
