Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [docker]

The container software docker. https://www.docker.com

Docker is an open-source project that provides an additional layer of abstraction and automation of operating-system-level virtualization. While docker was born in the Linux world later versions are able to control Windows containers and Hyper-V virtual machines.

164 questions
19
votes
2 answers

MongoDB terminates when it runs out of memory

I have the following configuration: a host machine that runs three docker containers: MongoDB Redis A program using the previous two containers to store data Both Redis and MongoDB are used to store huge amounts of data. I know Redis needs to…
Simone Bronzini
  • 293
  • 1
  • 2
  • 6
13
votes
3 answers

How to limit memory consumption of mysql server to prevent OOM kills?

My MySQL instance is getting killed by the Linux oom_killer due to huge consumption of memory by mysql when inserting into longblob columns. This occurs when restoring a mysqldump which contains a very large longblob column. I've run through things…
cjheppell
  • 231
  • 5
12
votes
2 answers

MongoDB: co-locate the mongos process on application servers

I would like to ask a question about a best practice described in this document: http://info.mongodb.com/rs/mongodb/images/MongoDB-Performance-Best-Practices.pdf Use multiple query routers. Use multiple mongos processes spread across multiple…
tenshi
  • 173
  • 1
  • 9
9
votes
2 answers

SMO, SSMS are slow for management of SQL Server in Docker when connecting to localhost

TL;DR: When connecting to my SQL Server Docker container via a name that resolves to the IPv6 loopback (::1), SMO calls are really slow. When using 127.0.0.1, they're fast. I am trying to learn how to use the Docker image…
NReilingh
  • 725
  • 2
  • 6
  • 26
7
votes
1 answer

Excessive Postgres Docker CPU Consumption

I'm using a Postgres container to run some small non-critical apps and sites. It's been stable for a while, but now the container has started to consume some serious CPU after it's been running for a short period of time. I have removed all other…
vipes
  • 173
  • 1
  • 5
7
votes
1 answer

mongoDB in micro-services structure

I'm building a game that have micro-services structure using docker. The way i started to build my services is having a mongoDB instance to each service, so having OneToOne service to mongoDB instance, Resources ---> resourcesDB (mongoDB instance…
Yan Mayatskiy
  • 173
  • 6
6
votes
1 answer

Setting up replication with MariaDB 10.3.4 docker images

I'm attempting to set up replication between two docker containers, both running the stock MariaDB 10.3.4 images (which are the latest versions as of right now). When I start up the containers, I get error code 1062 (Duplicate key) on table…
Kryten
  • 275
  • 1
  • 4
  • 9
5
votes
1 answer

Permissions issue in Docker SQL Server 2017 while restoring certificate

Docker SQL Server 2017 container @latest. Using master database. The error I am facing is the following: [S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it. The…
Chaim Eliyah
  • 113
  • 8
4
votes
2 answers

Is there a way to use standard CLR functions on Azure SQL Edge for Ubuntu Docker on an M1 Mac?

I have a MacBook with an M1 chip, so (about) the only option for me to run SQL Server is to run it as a Docker container. This works fine for standard SQL, but our application uses some CLR features like COMPRESS; when I try to use that, it tells…
Glorfindel
  • 2,107
  • 4
  • 14
  • 25
4
votes
3 answers

Unable to use cyrillic characters in mysql docker console

I'm running a MySQL docker container (latest - 8.0) with the custom configuration file containing: ====================================== [client] default-character-set=utf8mb4 [mysqld] collation_server = utf8mb4_unicode_ci init-connect='SET…
ruslaniv
  • 201
  • 2
  • 7
3
votes
2 answers

On docker volume restore: could not access file "$libdir/timescaledb-1.6.0": No such file or directory

I am trying to restore TimescaleDB data from one ubuntu machine to another ubuntu machine. On the both machines we have deployed TimescaleDB through docker and using the same tag. Docker image used: timescale/timescaledb:latest-pg11 I am creating a…
Onkar Janwa
  • 153
  • 5
3
votes
1 answer

How do I create a new Oracle schema?

I’m pretty familiar with Relational DBMS in general, but not with Oracle. I have Oracle 18c XE running inside Docker (on MacOS). I connect to it using a third party client (SQLPro Studio on MacOS). Now I want to get started. If this were MySQL I…
Manngo
  • 2,183
  • 6
  • 23
  • 44
3
votes
1 answer

/dev/shm size recommendation for postgres database in docker

We have postgresql 11.7 database in docker container. We had an issue "pq: could not resize shared memory segment "/PostgreSQL.XXX" to XXX bytes: No space left on device", described here. Solution helped, we do not have an issue anymore. But which…
Vsevolod Gromov
  • 153
  • 1
  • 5
3
votes
1 answer

sql server in docker using 15gb of disk space

I'm following the instructions here to create my own docker container containing a sql server instance with databases and data configured. I've added two databases, a few tables containing at most hundreds of items each, and a few stored…
Yair Halberstadt
  • 145
  • 6
3
votes
2 answers

How to disable mongodb connection logs?

Our mongodb relication has many logs like this: > 2017-11-24T02:15:50.679+0000 I ACCESS [conn6537] Successfully authenticated as principal stats on stats > 2017-11-24T02:15:50.679+0000 I ACCESS [conn6535] Successfully authenticated as…
Kiên Nguyễn Trung
  • 31
  • 1
  • 3
1
2 3
…
10 11