Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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 ...

1
vote
1answer
8 views

Strategies to work around 30 sec timeout

I received a timeout when trying to perform 7000 * 3 inserts into MariaDB in 30 seconds with AWS Python Lambda. I have three ideas how to get around the 30 second API Gateway timeout: Convert the ...
1
vote
1answer
17 views

phpMyAdmin using dockerised database

I have installed mariadb inside docker container, and mariadb is running properly inside that container. I want to get access of mariadb through phpMyAdmin from outside docker container. What will I ...
1
vote
0answers
21 views

How to manage Pull request or branch environment databases?

As an organisation we are (finally) moving to a good CI/CD setup. We use Github for development and now have a nice CI setup where we auto deploy specific tags to different environments. Now I want ...
1
vote
1answer
26 views

Zero Downtime Deployment with Database Backward Compatibility

Question Does anyone have experience with Database Backward Compatibility to achieve Zero Downtime Deployment? Are there good links or references that I can read? Reason I am working with a ...
1
vote
1answer
35 views

Does anyone have resources, tools, ideas, for automating database create, update, modify, delete

I've been tasked to find a way to automate promotion of database creation, changes and other modification related to application changes in a devops world. My databases include MS SQL, Oracle, MySQL ...
1
vote
1answer
22 views

In a Database Per Service model - should i include the database in the service container?

I am implementing a simple setup with two micro services and would like each of them to have their own DB - each service is running in it's own container. Should i include the DB's in each service ...
2
votes
2answers
73 views

Merging Git Database Commits from One Branch to Another without Cherrypicking

We have main two Git branches at our company: During our Sprint, Everyone has (local branches) Release branch: Contains prepared/developed code, ready for testing, and Master branch: Production- ...
2
votes
1answer
58 views

What is a good storage for storing performance results and visualizing in grafana

Intro I am a tester and need to analyze the results of automated tests (response times and etc.) Current situation 1) I run performance tests using locust.io 2) During test execution, response ...
0
votes
0answers
35 views

Database choice suggestion

I would like to create a database to store how often access tokens in my system are being used. I was thinking of a data model like so - Access Token from (basically I will store this hourly, so ...
0
votes
0answers
54 views

Service for cluster leader with leader election tolerance configuration in kubernetes?

I've deployed a mongodb cluster using stable/mongodb-replicaset There is a service defined as [releaseName]-mongodb-replicaset but it does not appear to point to the primary node. Some applications ...
2
votes
0answers
18 views

Is this a robust implementation of database encryption at rest?

I am looking forward to implement encryption at rest for two+ SQL database servers (Linux). My goal is (obviously) to avoid storing the clear encryption key on the server or store it in a well-known ...
1
vote
0answers
32 views

Which volume solutions are the most convenient when building Docker & microservices based application?

My application consists of few microservices and web (React) frontend. Basically I have auth microservice, application backend service, various data processing services and frontend rendering server. ...
4
votes
2answers
1k views

Docker MongoDB image - How to specify credentials other than in the compose file?

I'm using this docker image https://hub.docker.com/_/mongo/. That image provides a way of initializing a mongodb root database user with env variables which I can specify in the compose file as ...
4
votes
1answer
470 views

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 uses ...
1
vote
1answer
17 views

simulate SQL DB usage pattern of a typical cloud native web app with sysbench?

As far as I understand sysbench is for bencharking / test max. performance of a database server. I wish to simulate DB usage pattern of a typical cloud native web app (Twelve-Factor App). Is this ...
6
votes
1answer
936 views

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 ...
2
votes
2answers
940 views

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....
3
votes
2answers
618 views

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? ...
5
votes
2answers
66 views

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'...
16
votes
3answers
2k views

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 ...
5
votes
2answers
476 views

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 ...
7
votes
2answers
576 views

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 ...
17
votes
6answers
1k views

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 ...
11
votes
2answers
854 views

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 ...
6
votes
3answers
506 views

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 ...