Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

influxdata

How Time Series Databases and Data Lakes Work Together

Feb 19, 2024 By Jason Myers / In InfluxData
In the fast-paced world of software engineering, efficient data management is a cornerstone of success. Imagine you’re working with streams of data that not only require rapid analysis but also need to store that data for long-term insights. This is where the powerful duo of time series databases (TSDBs) and data lakes can help.
Read Post

How to speed up MySQL and PostgreSQL queries for FREE

Feb 19, 2024 By Aiven In Aiven
How can I speed up a SQL query? This video showcases how to optimize a SQL query on MySQL or PostgreSQL for free using AI and a tool called EverSQL by Aiven. In the example shown, the query performance on a MySQL database went from 20 seconds to 0.5 seconds only by pasting the SQL and additional metadata in the EverSQL by Aiven UI and applying the indexes and SQL rewrite suggestions. Check out these resources to learn more:(links to any tools or resources you used in the video, our docs/trial if appropriate)
View Video
pandora fms

NOSQL vs SQL. Key differences and when to choose each

Feb 19, 2024 By Ahinóam Rodríguez In Pandora FMS
Until recently, the default model for application development was SQL. However, in recent years NoSQL has become a popular alternative. The wide variety of data that is stored today and the workload that servers must support force developers to consider other more flexible and scalable options. NoSQL databases provide agile development and ease of adapting to changes. Even so, they cannot be considered as a replacement for SQL nor are they the most successful choice for all types of projects.
Read Post
site24x7

Navigate memory management challenges in MongoDB with Site24x7

Feb 15, 2024 By Sinjan Ballav In Site24x7
Effective memory management is crucial for optimal MongoDB performance and helps ensure seamless database operations and user experience. Allocating enough memory lets the database store frequently used data and indexes in RAM and cut down on disk I/O operations. This boosts query response times and system responsiveness. Poor memory management can cause delays in retrieving data from disk, leading to performance degradation.
Read Post
lumigo

Debugging and Decoding MongoDB with OpenTelemetry

Feb 14, 2024 By DeveloperSteve In Lumigo
MongoDB’s flexibility and document-oriented nature have always stood out to me as its most compelling features, setting it apart from the strict schema constraints of traditional relational databases. This adaptability is a boon for application development, allowing for more dynamic data interactions that mirror real-world information complexities and freeing table schemas’ constraints.
Read Post

Cloud Migration Challenges: Overcoming Obstacles - TJay Belt | Redgate

Feb 14, 2024 By Redgate In Redgate
TJay Belt, Director of Data at Nerd United, shares his thoughts on the obstacles you face when migrating to the cloud. Cloud adoption has been steadily on the rise for a number of years, driven by benefits such as scalability, accessibility and flexibility, security and cost.
View Video
VictoriaMetrics

How to reduce expenses on monitoring: Swapping in VictoriaMetrics for Prometheus

Feb 13, 2024 By Roman Khavronenko In VictoriaMetrics
Monitoring can get expensive due to the huge quantities of data that need to be processed. In this blog post, you’ll learn the best ways to store and process monitoring metrics to reduce your costs, and how VictoriaMetrics can help. This blog post will only cover open-source solutions. VictoriaMetrics is proudly open source. You’ll get the most out of this blog post if you are familiar with Prometheus, Thanos, Mimir or VictoriaMetrics.
Read Post
canonical

Charmed MongoDB: use cases for financial services

Feb 12, 2024 By Michelle Anne Tabirao In Canonical
Financial institutions handle vast amounts of sensitive and confidential data, including customer information, transaction details, and regulatory compliance records. A trusted database ensures the security and privacy of this sensitive information, protecting it from unauthorised access, breaches, or cyber threats. MongoDB is the ideal fit, and it’s one of the most widely used databases in the financial services industry. It provides a sturdy, adaptable and trustworthy foundation.
Read Post
influxdata

Augmenting Your DBA Toolkit: Harnessing the Power of Time Series Databases

Feb 12, 2024 By Jason Myers / In InfluxData
Database Administrators (DBAs) rely on time series data every day, even if they don’t think of time series data as a unique data type. They rely on metrics such as CPU usage, memory utilization, and query response times to monitor and optimize databases. These metrics inherently have a time component, making them time series data. However, traditional databases aren’t specifically designed to handle the unique characteristics and workloads associated with time series data.
Read Post
Subscribe to Databases

Copyright © 2024 OpsMatters™. All rights reserved.