MySQL integration enables an Edge System to connect with a MySQL database. 

MySQL (4.1+), MariaDB, Percona Server, Google CloudSQL or Sphinx (2.2.3+)

This information is just for reference. More products and versions may be supported.

Review parameters for the DB - MySQL connector. 

DB - Mongo v4+

DB - MySQL

DB - MySQL SSL

MySQL | Litmus Automation Documentation

Litmus Technical Documentation

Litmus Edge 3.16.x

System Architecture

User Journey

Flows and Analytics Explained

Overview

Establishing a Litmus Edge-Litmus Edge Manager Connection From the Litmus Edge Side

System Requirements

ISO Installation on Hypervisors

ISO Installation on an Industrial PC (IPC)

OVA Installation on Virtual Machine

Docker Installation

Zerotouch Installation

Kubernetes Installation

Raspberry Pi Installation

License Server Installation

Software Updates

Installation and Deployments

Access the Terminal User Interface

Access the Litmus Edge Web UI

Allen-Bradley

Atlas Copco

BACnet

Beckhoff

Brother Industries Ltd

CAN Bus

CodeSys Devices

Cutler-Hammer

Danfoss

Delta PLC

DNP3

Emerson

Euromap63

Excel

Fanuc Corporation

Fuji Devices

GE Fanuc

Generic

GPIO

Heidenhain

HID Devices

Hitachi Devices

JTEKT Toyopuc

Keyence

Koyo

LS Industrial System

Lumberg Automation

Mitsubishi

Modbus

MQTT

MTConnect

Network Utility

ODVA

Omron

OPC UA

Opto Devices

Panasonic

Parker

Profinet

RS Automation

SAIA

Sick Flexi

Siemens

Simulator

Toshiba

VIPA

Yaskawa

Yokogawa

Industrial Systems Connection Guide

Quickstart Guide

Dashboard

Devices

Asset Discovery

Utilities

DeviceHub

Create and Import Models

Manage Models

Add an Instance

Manage Instances

Digital Twins

Configure the Timeseries DB

DB Management

DB Users

DataHub

Create a Flow

Manage a Flows Manager

Manage the Flow Canvas

Flow Canvas Dashboard

Function Nodes

Configuration Nodes

Flows Manager

Analytics Flows and Processors

Analytics Flow Groups

Instances Table

Machine Learning Models

Input Processors

Output Processors

Statistical Functions

Key Performance Indicators

Analytics

Applications Dashboard

Catalog Apps

Configure

Marketplace

Containers

Networks

Images

Registry

Volumes

System Info

Disk Usage

Applications

Add a Connector

Add Topics to Connectors

Manage Connectors

Integration Connectors

Cloud Storage

Integration

Hierarchy

Management

Statistics

OPC UA Server

Info

Activation

Device Management

Network

External Storage

Access Control

Events

Support

System

Product Features

Organize Device and Tag Data by Using Metadata

Use the Write Topic to Send Data to a PLC

Use the Batch-Write Topic to Send Multiple Write Requests

Use the Manage Topic to Stop a Device

Use the PLC-Status Topic to Verify Connection Status

Use the Poll-Once Topic to Manually Retrieve Register Values

Use the Status Register to Connect a PLC

Use the Siemens S7 Browse Agent

Use the Mazak MTConnect Demo Agent to Connect a Device

DeviceHub Guides

Use Digital Twins to Contextualize Data

Add a Device Certificate in Litmus Edge

Configure an External DataHub Source

Subscribe to Topics with Flows

Use Access to Write to a Topic

Use Access to Read from a Topic

Create, Write to, and Read from a Log File

Save Multiple Register Values to a CSV File

Work with SQL Databases

Work with MongoDB Databases

Write to Databases with Integration Topics

Create a Chart

Ping a Host

Send Alerts to a Mobile Phone

Create Audio Notifications for Sensor Readings

Flows Guides

Use the Anomaly Detection Function

Use the Base Conversion Function

Use the Combination Processor Function

Use the Change Processor Function

Use the Conversion Function

Use the Expression Processor Function

Use the Feature Extractor Function

Use the Gaussian Filter Function

Use the Inputs Processor Function

Use the Join Processor Function

Use the Linear Prediction Function

Use the Moving Window Processor Function

Use the Normalization Processor Function

Use the Rise and Fall Function

Use the Rounding Function

Use the Signal Decomposition Function

Use the Simple Window Function

Use the Statistical Prediction Function

Use the Statistical Tests Function

Use the Switch Processor Function

Use the Tengo Script Function

Use the XMR Chart Function

Use the Asset Online Percentage KPI

Use the Change of Value KPI

Use the Compliance and Loss KPI

Use the Maintenance and Failure KPI

Use the Manufacture Counter KPI

Use the Online and Offline Percentage KPI

Use the Production Time and Cycle Time Ratio KPI

Use the Uptime and Downtime by Value KPI

Analytics Guides

Set Up LDAP Using an OpenLDAP Container

Visualize Data Using Grafana

Use Marketplace SDK with Python

Applications Guides

Untitled