Databases

The latest News and Information on Databases and related technologies.

What is Database Administration?

Jul 19, 2023 By OpsMatters In OpsMatters

In today's digital age, data has become the lifeblood of businesses and organizations. With the exponential growth of data, the need for efficient and secure management has become paramount. This is where database administration comes into play. Database administration is a crucial role in ensuring the smooth operation and maintenance of databases. It involves a wide range of tasks, from designing and implementing databases to monitoring and optimizing their performance.

Read Post

OpsMatters

Read more about What is Database Administration?

MySQL high availability made charmingly easy

Jul 18, 2023 By Mohamed Wadie Nsiri In Canonical

In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our recipe for MySQL high availability. We will also explain how our solution interacts with K8s objects to provide some of its features.

Read Post

Canonical

Read more about MySQL high availability made charmingly easy

Improving query performance in Grafana Mimir: Why we dropped mmap from the store-gateway

Jul 17, 2023 By Charles Korn In Grafana

In recent months, we have been working on improving the performance of Grafana Mimir, the open source, horizontally scalable, highly available, multi-tenant TSDB for long-term storage of your metrics.

Read Post

Grafana

Read more about Improving query performance in Grafana Mimir: Why we dropped mmap from the store-gateway

How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone

Jul 17, 2023 By Ivo Miller In Redgate

Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction.

Read Post

Redgate

Read more about How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone

Creating Databases, Schemas, and Tables on pgAdmin

Jul 17, 2023 By Aiven In Aiven

In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.

View Video

Aiven

Read more about Creating Databases, Schemas, and Tables on pgAdmin

Installing FerretDB through Civo Marketplace - Civo.com

Jul 13, 2023 By Civo In Civo

In this video @KunalKushwaha introduces FerretDB, an open-source alternative to MongoDB built on PostgreSQL. It explains how to install FerretDB through the Civo Marketplace, highlighting the prerequisites and installation process. The video covers basic CRUD operations using FerretDB, including creating, reading, updating, and deleting documents. It also mentions the benefits of using FerretDB, such as its open-source nature, transparency, simplicity, and supportive community.

View Video

Civo

Read more about Installing FerretDB through Civo Marketplace - Civo.com

Q2 Round Up: Roadmap Review & Q3 2023 Look Ahead

Jul 12, 2023 By Jean-Jerome Schmidt-Soisson In VictoriaMetrics

Many thanks to everyone who joined us for our recent virtual meetup, during which we discussed some of our Q2 2023 highlights, including features highlights, the 2023 roadmap for VictoriaMetrics and of course: The launch of VictoriaLogs! In this blog post, we’d like to share a summary of these highlights.

Read Post

VictoriaMetrics

Read more about Q2 Round Up: Roadmap Review & Q3 2023 Look Ahead

Connecting PostgreSQL to pgAdmin

Jul 10, 2023 By Aiven In Aiven

In this tutorial, we'll guide you through the process of connecting PostgreSQL to pgAdmin, a popular GUI tool for managing PostgreSQL databases. Whether you're a beginner or an experienced user, this video will provide you with step-by-step instructions on establishing a seamless connection between PostgreSQL and pgAdmin. Additionally, we'll showcase how Aiven's PostgreSQL service seamlessly integrates with pgAdmin, enabling you to efficiently administer your database.

View Video

Aiven

Read more about Connecting PostgreSQL to pgAdmin

How to visualize time series from SQL databases with Grafana

Jul 7, 2023 By David Allen In Grafana

Relational databases like MySQL, PostgreSQL, Oracle, and others have a wealth of time series data locked inside of them. Often this data can be used to enhance observability dashboards, or keep track of important application factors, like how many users have signed up for a service. In this article, we’re going to show you how to visualize any time series from any SQL database in Grafana using the time series visualization.

Read Post

Grafana

Read more about How to visualize time series from SQL databases with Grafana

How to use Kubernetes to deploy Postgres

Jul 6, 2023 By Theo Despoudis In Sumo Logic

Kubernetes is an orchestration platform that allows containers to be deployed in an automated and resilient way, abstracting many of the manual steps of rolling upgrades and scaling. You will usually want to deploy database applications (like PostgreSQL) as well, so that your applications can leverage their features within the cluster. Deploying in a Kubernetes cluster lets you build out your cloud-native PostgreSQL instance.

Read Post