MySQL
MySQL is the world's most widely used open-source relational database management system, supported in Pirivision's Port module.
Ideal for environments where web-based MES platforms, ERP applications, and industrial software use MySQL as their backend — accessing data directly via SQL queries from Pirivision.
Strengths
| Feature | Description |
|---|---|
| Widespread Use | The world's most-used relational database; broad ecosystem and support |
| Low Cost | Community Edition is free; MySQL Enterprise available for corporate installs |
| Speed | High performance on read-heavy workloads |
| Web App Compatibility | LAMP stack (Linux, Apache, MySQL, PHP) — broad industrial software support |
| MariaDB Compatible | The same connection settings work with the MariaDB fork |
| Replication | High availability via master-slave replication |
| Wide Driver Support | Access via JDBC, ODBC, Python, Node.js, and more |
What You Can Do in Pirivision
| Action | Description |
|---|---|
| SQL Query | Retrieve data with SELECT, JOIN, WHERE, GROUP BY in Compass |
| Time Series | Trend queries via DATETIME / TIMESTAMP columns |
| Cross-Table | Combine multiple tables with JOIN |
| Filtered KPI | Filter by plant, product, or category with WHERE |
| Aggregation | Summary metrics with AVG, SUM, COUNT, MIN, MAX |
| Multi-Database | Access multiple DBs from one connection via database_name.table_name notation |
When Is It Used?
- Web-Based MES: MySQL backends of PHP- or Node.js-based MES applications
- ERP Systems: Open-source ERPs like Odoo, Dolibarr running on MySQL
- CMMS: Maintenance management systems' fault and maintenance records
- Energy Management: Meter data energy monitoring systems on MySQL
- Production Reporting: Daily / monthly production summary table queries
- MariaDB: MySQL-compatible MariaDB installations use the same connection structure
Connection Requirements
| Information | Required | Default |
|---|---|---|
| Host | Yes | — |
| Port | Yes | 3306 |
| Database Name | Yes | — |
| Username | Yes | — |
| Password | Yes | — |
No Schema Field
In MySQL, tables live directly under the database; there is no separate schema field. Use database_name.table_name notation in queries.
Guides
| Guide | Description |
|---|---|
| Add MySQL Data Source | Create a new MySQL connection in the Port module |
| Edit MySQL Data Source | Update an existing connection |
| Move Data Source | Move to a different folder |
| Duplicate Data Source | Copy with the same settings |
| Delete Data Source | Remove the data source |
Next Step
After adding a MySQL data source, create a SQL query in the Compass module.