MySQL Nodes
MaestroHub provides native MySQL integration for queries, inserts, updates, and deletes with full parameter binding and SSL/TLS support. Compatible with MySQL 5.7+, MariaDB 10.2+, and Aurora MySQL.
Configuration Quick Reference
| Field | What you choose | Details |
|---|---|---|
| Parameters | Connection, Function, Function Parameters, Timeout Override | Select the connection profile, function, configure function parameters with expression support, and optionally override timeout. |
| Settings | Description, Timeout (seconds), Retry on Timeout, Retry on Fail, On Error | Node description, maximum execution time, retry behavior on timeout or failure, and error handling strategy. All execution settings default to pipeline-level values. |
Node Types
MySQL connector provides three specialized node types for different operation patterns:
| Node | Purpose | Common Use Cases |
|---|---|---|
| Query | Execute SELECT queries and return structured rows | Reporting dashboards, data lookups, KPI calculations |
| Execute | Execute DML/DDL statements, return rows affected | INSERT/UPDATE/DELETE statements, schema changes, stored procedures |
| Write | Load pipeline data into a table with auto schema detection | Bulk sensor ingestion, auto-create tables, data loading from upstream nodes |
MySQL Query Node
MySQL Query Node
Execute SQL SELECT queries and return rows as structured data. Supports parameterized queries with ? style placeholders.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Query | Run parameterized SELECT queries against MySQL | Reporting dashboards, data lookups, aggregated KPI calculations |
MySQL Execute Node
MySQL Execute Node
Execute DML/DDL statements (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) and return rowsAffected. Use for data modifications and schema changes.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Execute | Run any DML/DDL statement or stored procedure call | Data modifications, schema migrations, maintenance tasks |
MySQL Write Node
MySQL Write Node
Load pipeline data into a MySQL table with automatic schema detection. Auto mode detects the table schema and maps incoming data fields to columns; Manual mode lets you specify exact columns. Supports batching, auto table creation, and schema evolution.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Write | Load structured data into a MySQL table | Bulk sensor ingestion, auto-create tables from pipeline data, data loading |