DevOps Stack Exchange
DevOps Stack Exchange

Questions tagged [databases]

A database is an organised collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. Designers typically organise data to model aspects of reality in a way that supports processes requiring information. Use this tag on questions which ask about database aspects of Continuous Delivery, Continuous Deployment or general DevOps approaches to databases.

A database is an organised collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. Designers typically arrange data to model aspects of reality in a way that supports processes requiring information.

Types of Databases

Databases can be broken down into several different types of databases:

  • Relational Databases or RDBMSs - store data regarding its relation to other pieces of data, held in a strictly enforced schema.
  • Document Databases - store data regarding single, generally hierarchical, documents. Schemas are available but may not be enforced or may support versions.
  • Key-Value Stores - stores keys and their values in a highly efficient hash table like structure.

Further Reading

Related tags:

55 questions
53
votes
3 answers

What are the reasons Docker should not be used for databases?

I'm having a discussion with a friend about use cases for Docker. One guy in the team wants to use Docker for everything - like a kind of universal unix process wrapper. The other thinks that Docker should only be used for stateless applications…
hawkeye
  • 1,153
  • 1
  • 9
  • 14
21
votes
6 answers

What practices or tools enable Continuous Deployment of Databases?

Continuous Delivery or Continuous Deployment of infrastructure and code is comparatively simple compared to trying the same approaches for databases, specifically RDBMSs. Code and infrastructure will not change or evolve once deployment has…
Richard Slater
  • 11,747
  • 7
  • 43
  • 82
11
votes
2 answers

How should I store my environment variables?

This is a very broad question about methods and advice regarding environment variables / structure. But ultimately I'm looking for answers for the very specific question of 'How should I store my environment variables?' Firstly some…
Naphta
  • 627
  • 6
  • 9
9
votes
1 answer

Why is Prometheus not a good choice for data with high cardinality?

I have a background in relational databases and new to Prometheus. I wonder why Prometheus is not a good choice for high cardinality data? Why do I need to use low cardinality data? It's exact opposite from SQL DBs. What are the technical reason for…
Sybil
  • 472
  • 4
  • 11
8
votes
2 answers

How to synchronize deployments (especially of database object changes) on multiple environments

I am the DevOps engineer and a software engineer in a team where months back, the developers moved from having a central Oracle DB to having the DB on a CentOS VM on their individual laptops. The move from a central DB was to reduce dependency on…
user1063
  • 89
  • 2
7
votes
1 answer

What is the impact of using Helm Deployments instead of StatefulSets for Databases like MongoDB or MySQL?

The definition of a stateless app seems to apply to database servers like MongoDB or MySQL. I found Helm Charts as a kind of template-repository for Kubernetes. However, the stable builds all use deployments. Only in the incubator, which are not…
Daniel
  • 211
  • 1
  • 7
6
votes
3 answers

DynamoDB vs RDS for a counter store?

I have multiple lambda functions, which a file passes through for processing, and I want to store the status of each computation in a counter, for better logging and monitoring. Current plan is to log it like this: file-name Lambda1 Lambda2…
Dawny33
  • 2,816
  • 3
  • 24
  • 62
6
votes
3 answers

How to do blue-green deployment with PL/SQL code?

Is it possible to do blue-green deployment when your software is mostly a set of PL/SQL packages? I don't really want to duplicate the database, the financial risks in case of any desyncs are too big. I understand that step 1 is to decouple schema…
Alexey
  • 161
  • 3
5
votes
2 answers

Google Cloud Storage vs Redis / ElasticSearch

We're building an application that reads data from an API and displays it in a frontend. Due to API limits, we have to cache the API calls meaning that we save the result of the API calls (both user information (first name, country, email etc.) and…
mrksbnch
  • 161
  • 4
5
votes
1 answer

Creating ansible host_vars and group_vars files dynamically

Is it possible to populate host_vars and group_vars with results from a database like we do in dynamic inventories? Actually I'm doing it inside my playbook either with lookups, either by using shell module and registering queries result. If anyone…
storm
  • 1,759
  • 3
  • 16
  • 34
5
votes
2 answers

macOS testing on Desktop: Docker containers vs. Homebrew installation

Often I test some stuff on my MacBook. Mostly database and data store related stuff (MongoDB, MariaDB, Postgres). I install the software with Homebrew and test. I wonder if I should switch to docker? What are pros and cons Homebrew vs. Docker for…
Sybil
  • 472
  • 4
  • 11
5
votes
2 answers

Cloud DB operator responsibilities / common tasks

When I feed a search engine with "DBA tasks responsibilities" lots of hits like "What does a DBA do all day?" and even official Oracle manual entries. With modern automation a lot of those tasks don't exist anymore and as a DBaaS provider we…
Sybil
  • 472
  • 4
  • 11
5
votes
2 answers

How to version control shared database?

We have several C# applications using a shared monolithic database (on-premise SQL server) using Stored Procedures as an exclusive interface. The C# code repositories include only Stored Procedures that are relevant to them, which means a single…
Zikato
  • 153
  • 4
4
votes
1 answer

What strategies exist to transition DB Migrations with Stored Procedures to Continuous Delivery?

Our company has broken up most of our large Monolith application into smaller Microservices and we have a clear plan on how to get new services on Kubrenetes into a CI/CD pipeline. However, we still have some parts of our applications which have not…
avi
  • 1,279
  • 1
  • 13
  • 32
4
votes
1 answer

Trade offs of putting an international master database in us-west-2

I'm hoping this isn't so open ended that it veers towards a "discussion" more than an "answerable" question. I need to place an RDS Postgres instance in an AWS region that will act as the master DB for writes from all other regions. Those regions…
Chris
  • 151
  • 2
1
2 3 4