Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Why organisations across Australia should embrace Test Data Management

In an era marked by the convergence of Big Data, hybrid cloud use, and the rise of machine learning and artificial intelligence, organisations across the Asia-Pacific (APAC) region find themselves at a critical juncture. The ability to collect, manage, and leverage data effectively is now a determining factor for competitive advantage – and will become more competitive.

From Chaos to Clarity Troubleshooting Postgres

I have always had a special fondness for Postgres, particularly captivated by its JSONB capabilities, which is at the core of what I love as it stands as a testament to its adaptability. This functionality exemplifies Postgres’s ability to adapt to modern apps’ rapidly changing needs to support structured and unstructured data to coexist seamlessly within the same database environment. The capabilities of PostgreSQL are not limited to its ability to manage relational and non-relational data.

How Time Series Databases and Data Lakes Work Together

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.

How to speed up MySQL and PostgreSQL queries for FREE

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)

NOSQL vs SQL. Key differences and when to choose each

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.

Navigate memory management challenges in MongoDB with 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.

Debugging and Decoding MongoDB with OpenTelemetry

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.

Cloud Migration Challenges: Overcoming Obstacles - TJay Belt | 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.

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

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.