In this tutorial, we will address the common monitoring use case of filtering metrics within observIQ’s distribution of the OpenTelemetry (OTEL) collector. Whether the metrics are deemed unnecessary, or they are filtered for security concerns, the process is fairly...
MySQL
Common Mistakes to Avoid When Writing SQL Code
SQL (Structured Query Language) is a powerful and widely-used language for managing and manipulating data stored in relational databases. However, it’s important to be aware of common mistakes that can lead to bugs, security vulnerabilities, and poor performance in...
Apache Ranger and AWS EMR Automated Installation 4
In the previous two articles, we introduced the EMR-native Ranger integration solution with OpenLDAP and Windows AD. In this article, we will introduce open-source Ranger integration. This article will discuss “OpenLDAP + Open-Source Ranger.” 1. OpenLDAP + Open-Source...
How We Reduced Online Serving Latency From 1.11s to 123.6ms With a Distributed SQL Database
This post tells how a website with a distributed database reduced online serving latency from 1.11 s to 417.7 ms, and then to 123.6 ms. We found that some lessons learned on MySQL could be applied throughout the optimization process. But when we optimize a distributed...
Non-blocking Database Migrations – DZone Database
Database migrations are a common part of any web application. They are used to update the database schema to match the application's code. In a traditional web application, the database migrations are run synchronously, which means that the application is blocked...
Setup Jira With MySQL Docker.
Hello Everyone, I am here again after a long gap. I have something new and interesting. In this article, we are going to set up a Jira DataCenter/Server-based instance on our host machine. Prerequisite Install the latest version of Jira. Download Jira Software Server....
Migrating from Sakila-MySQL to Couchbase, Part 5
With the release of 7.1, Couchbase N1QL adds support for JavaScript user-defined functions. Originally as seen in Part2: Views and UDFs and Part3: Stored Procedures, we used N1QL UDFs to map the MySQL UDFs and stored procedures. With N1QL UDFs, we can do only a single...
Complete Guide to Generated Columns in MySQL
MySQL generated columns pose as a powerful, easy-to-use, and advanced tool for anyone who wants to add automatically generated data to their tables - in this blog, we will learn everything you need to know to master them. Generated columns allow you to store...