DZone

SEPTEMBER 6, 2023

MQTT is a lightweight messaging protocol commonly used in IoT (Internet of Things) applications to enable communication between devices. As a popular open-source MQTT broker, EMQX provides high scalability, reliability, and security for MQTT messaging. By using Terraform, a widespread Infrastructure as Code (IaC) tool, you can automate the deployment of EMQX MQTT Broker on AWS, making it easy to set up and manage your MQTT infrastructure.

AWS 294

AWS IoT Open Source Internet 294

Percona

SEPTEMBER 6, 2023

A join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. In this blog, we will look into an easy way to visualize the data captured by various joins using Venn diagrams and their SQL equivalent. Some of these joins are only available natively in some relational databases; for the sake of simplicity, we will only consider the most widely used open-source databases in this blog- MySQL and PostgreS

Open Source 98

Open Source Database Monitoring Testing 98

DZone

SEPTEMBER 6, 2023

Recently, I had to use Ansible to implement infrastructure as code. Initially, I used Windows Subsystem for Linux (WSL) to run the Ansible playbooks. The advantage of WSL is that it gives one a Linux shell on a Windows machine without any further ado. However, I found that WSL has this tendency to go haywire and use system resources such as CPU and RAM to the max.

Virtualization 152

Virtualization Infrastructure Servers Processing 152

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. You may also hear this type of index being called Index on expression. So, what is a functional index? Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 87

Speed Virtualization Storage Open Source 87