Deploying MySQL to store sensor data
Before you can store data from your devices using LoRa, you must deploy your database. For this, we are going to use MySQL. MySQL is a pretty popular database that you can use to store data from your sensor. The main advantage of using MySQL is that it is well documented, and you can find a lot of examples on the internet. For our deployment, we are going to use a PersistentVolumeClaim and the mysql:8.0.28-oracle image. Even if you decide to deploy your MySQL over the cloud or locally at the edge, you must use a LoadBalancer service so that you have an endpoint for the service that is going to store all sensor data. Our MySQL database will be deployed in the default namespace to simplify the implementation. To deploy our MySQL database, follow these steps:
- Create a
PersistentVolumeClaimwith 5 GB of storage:$ cat <<EOF | kubectl apply -f - apiVersion: v1 kind: PersistentVolumeClaim metadata: name: db-pv-claim spec: ...