SQL and NoSQL Databases at the Edge
When you have to create an edge system, a critical task is storing your data. For this, you have to take into consideration the resources that you have, the processor that your devices are using, and the type of data that you want to store. CAP theorem states that distributed data stores only provide two of the following guarantees: consistency, availability, and partition tolerance. So, this theorem can help you to decide which type of database is best according to your system needs. In this chapter, we are going to learn how to deploy different database types to run on edge systems using K3s and ARM devices. These examples include different techniques such as using ConfigMaps and Secrets to deploy your databases.
In this chapter, we’re going to cover the following main topics:
- CAP theorem for SQL and NoSQL databases
- Creating a volume to persist your data
- Using MySQL and MariaDB SQL databases
- Using a Redis key-value...
