Moteur Glial & Aspirateur

The Aspirateur

The Aspirateur (Aspirateur.php) is the core of data collection. It connects to each MariaDB / MySQL server to collect:

• Global variables (SHOW GLOBAL VARIABLES)
• Status (SHOW GLOBAL STATUS)
• Processlist (SHOW PROCESSLIST)
• Replication (SHOW SLAVE STATUS)
• Galera (wsrep_* variables)
• InnoDB (SHOW ENGINE INNODB STATUS)
• Schemas (INFORMATION_SCHEMA)
• Hardware via SSH (CPU, RAM, disk, load)
• ProxySQL (admin interface)
• VIP (DNS resolution)

Workers & Daemon

The worker system distributes the collection load:

• Worker.php — Parallel worker pool, dynamic add/remove
• Daemon.php — Start/stop all, statistics, refresh
• Integrate.php — Integration of pivot files into time-series tables

# Démarrer les daemons
php /srv/www/pmacontrol/glial daemon start

# Voir le statut
php /srv/www/pmacontrol/glial daemon status

# Arrêter
php /srv/www/pmacontrol/glial daemon stop

Time-series files (ts_file)

Collected data is stored in time-series files (ts_file) with timestamps. Key tables:

• ts_file — Collection file definitions
• ts_max_date — Last collection date per server and file
• ts_date_by_server — Collection date index