Visualizing data from ESP32 microcontrollers using MySQL and Grafana
Now, let’s finish off our implementation of a real-time temperature and humidity system. For this, we are going to use Grafana to create our reports and MySQL as our source of data to feed the reports. You can deploy this software in Kubernetes in the cloud or a private cloud using a network that can be accessed by your edge clusters. In this section, we are assuming that we are using Kubernetes in the cloud. To start creating our reports, follow these steps:
- Create the necessary namespace monitoring:
$ cat <<EOF | kubectl apply -f - apiVersion: v1 kind: Namespace metadata: creationTimestamp: null name: monitoring spec: {} status: {} EOF - Create a ConfigMap to create a default data source that contains our MySQL connection:
$ cat <<EOF | kubectl apply -f - apiVersion: v1 kind: ConfigMap metadata: name: grafana-datasources namespace: monitoring...