Store telemetry data in MySQL, a popular open-source relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
dev.mysql.com
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | MySQL server hostname or IP. |
| User | Yes | string | Database username. |
| Password | Yes | string | Database password. |
| Database | Yes | string | Database name. |
| Port | No | int | MySQL port (default 3306). |
Example Configuration
Server=192.168.1.100
Port=3306
Database=proxus
User=proxus
Password=*****Data Schema
CREATE TABLE ProxusDeviceData (
Oid INT AUTO_INCREMENT PRIMARY KEY,
DeviceId INT NOT NULL,
DeviceName VARCHAR(255),
`Key` VARCHAR(255) NOT NULL,
`Value` TEXT NOT NULL,
DataType VARCHAR(64) NOT NULL,
Time DATETIME(6) NOT NULL,
INDEX idx_device_time (DeviceId, Time)
);Performance Tips
- Use InnoDB storage engine for transactional support
- Enable
AllowBulkLoad=truefor faster batch inserts - Consider table partitioning by date