Skip to main content

Questions tagged [mysql]

For questions about MySQL, which is an open source Relational Database Management System (RDBMS).

Filter by
Sorted by
Tagged with
0 votes
0 answers
4 views

MySQL Operator on Kubernetes Pods Stuck in Initializing State with "FailedBinding" Error

I'm trying to deploy MySQL InnoDB Cluster on Kubernetes using the Oracle MySQL Operator with the help of manifest files and kubectl. However, when executing the mycluster.yaml file, the pods are stuck ...
Tharsha Sivapalarajah's user avatar
0 votes
1 answer
364 views

How to configure MySQL exporter Helm chart for multiple targets (remote & local)?

I have been trying for a few days to set up a multi-target MySQL exporter (MSE) deployed with Helm inside a k8s cluster. The chart that I am using is the https://artifacthub.io/packages/helm/...
aboitier's user avatar
  • 199
0 votes
0 answers
121 views

Can't get connected to mysql db using sequelize and docker

I am Trying to connect to Mysql database using docker-compose in node.js ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 192.168.32.2:3306 here is how my docker-...
Luka Akhalbedashvili's user avatar
1 vote
1 answer
2k views

Setup keycloak with mysql via docker compose

I've been trying to get keycloak running for a bit now. I had it going using the legacy tag but it seems like bad practice to get started with a legacy version. So I wanted to get the most recent ...
Bas Visscher's user avatar
0 votes
2 answers
54 views

How to implement simple distributed configuration system

I have multiple servers running in data centers around the world. Each server has its own configuraiton database, and cli command needs to be executed to update in-memory cache. I want to automate ...
Shadow's user avatar
  • 111
0 votes
1 answer
667 views

K8S + HELM. Create a persistence volume for mysql database

I am using K8S with Helm 3. I am also using MYSQL 5.7 database. How can I create MYSQL pod, that the database will persist (created on first time) after first time the pod is created, and even the pod ...
Eitan's user avatar
  • 103
1 vote
1 answer
2k views

ansible mysql query not showing results

I have used community.mysql collection and was able to run a query against the database. --- - name: Get stats of a file hosts: localhost become: true tasks: - name: run mysql query ...
Ravi Kumar CH's user avatar
0 votes
1 answer
592 views

Where is located mysqldump log file on Linux/Ubuntu

I am neither a DB administrator, nor a DevOps but I need to migrate a very large table (~500M rows) from one MySQL schema to another. For doing so, I use mysqldumpbackup tool. Also, since the DB is an ...
Armine's user avatar
  • 71
0 votes
1 answer
2k views

My Python application doesn't communicate with MySQL inside docker. Can someone help me?

The connection is not succeeding in docker. Look at my settings: Dockerfile FROM python:3.8.5-alpine WORKDIR /app COPY requirements.txt . RUN python3 -m pip install --upgrade pip RUN pip install -...
Flavio W.'s user avatar
2 votes
0 answers
77 views

How do I deploy and configure a MariaDB (Mysql) image for remote connection?

Specifically: I want to deploy a docker mariadb image to Heroku, that my other heroku app will connect to, in part because I want that skill, in part so I can extend the architecture in the future, ...
gcr's user avatar
  • 121
2 votes
3 answers
3k views

Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method

I have an AWS RDS MySQL Database. The size of the Database is around of 1.5 GB. We are using MySQL 5.7.32. We tried with SQL dump but in dump data is missing in Dump. We found out that we can use ...
Hiren Namera's user avatar
1 vote
1 answer
1k views

Bootstrapping Galera Cluster in Docker

I'm trying to bootstrap a MariaDB Galera cluster in Docker containers. The following configuration works when I set network_mode: host, but then I can't directly access the MariaDB from inside other ...
Gerald Schneider's user avatar
0 votes
1 answer
1k views

mysqld: [ERROR] Found option without preceding group in config file /root/.my.cnf at line 1!

I'm trying to create a .my.cnf file for my MySQL docker-container that would allow me to prefill the user and password for the MySQL client. To achieve this I created the following dockerfile: FROM ...
Beach Chicken's user avatar
0 votes
1 answer
368 views

Confluence mySQL image doesn't start anymore

I am running a confluence container containing an image for the application itself and one for the mySQL db. This was running smoothly until I run the latest Docker update. Since then, the mySQL image ...
Michi's user avatar
  • 11
0 votes
2 answers
40 views

How can I model this schema in MySQL?

I want to create a schema that reflects the following relationships, and I'm trying to do this in MySQL Workbench. (I'm no DB expert) I have 3 environments - sandbox, staging, and production I ...
Chris F's user avatar
  • 433
0 votes
2 answers
1k views

backup dockerise mysql database from host volume

I use a VPS (my host) where a LAMP server was installed. I already have a database associated to host mariaDB server Ver 15.1 Distrib 10.1.47 and automysqlbackup backups it. This part works well. For ...
bcag2's user avatar
  • 111
0 votes
1 answer
9k views

how to connect to a MySQL database in a docker container?

starting up the default mysql server: root $ root $ docker run --name mysql -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password mysql/mysql-server:latest ...
Nicholas Saunders's user avatar
0 votes
1 answer
481 views

How to gain console access to a MySQL server running on a docker container from the host?

I thought I had this working a few minutes ago: root $ root $ docker container ls CONTAINER ID IMAGE COMMAND CREATED STATUS ...
Nicholas Saunders's user avatar
0 votes
1 answer
666 views

How to create a "silent" MySQL docker container?

How can I create a MySQL docker container as below in the background: root:~# root:~# docker run -e MYSQL_ROOT_PASSWORD=pass --name sql-db -p 3306:3306 mysql & [1] 137878 root:~# 2020-09-01 08:25:...
Nicholas Saunders's user avatar
0 votes
1 answer
3k views

how to send a password to MySQL with docker?

Just getting started, want to run the downloaded version of mysql: root:~# root:~# docker images REPOSITORY TAG IMAGE ID CREATED SIZE basex/basexhttp ...
Nicholas Saunders's user avatar
0 votes
1 answer
520 views

Combining Two Containers

I'm working on a Windows laptop and running Docker for Windows on it. I want to run an Ubuntu container with a specific version and a MySQL server on it. So the question is, do I have to download ...
user19215's user avatar
  • 101
1 vote
1 answer
33 views

Managed MySQL cluster - similar solution for a private cloud

Is it possible to build a similar solution to managed MySQL cluster on a private cloud (VMware vSphere / Hyper V). Even with Kubernetes. A solution which supports auto-scaling, auto-upgrade, multi-...
jwalker's user avatar
  • 27
1 vote
1 answer
740 views

mariadb docker on raspberry

I've tried countless docker images, but all of them have the same behaviour. When I open up a console and try to import my database structure via the mysql/mariadb command. But I always get the same ...
Cowboy_Patrick's user avatar
0 votes
1 answer
176 views

Let docker containers work with each other

I’m new to docker and I want to dockerize a aleardy existing application. It consists of a react application (I already created a container for that one successfully), a REST-api based on node-...
Cowboy_Patrick's user avatar
1 vote
2 answers
10k views

docker | database connection refused between two containers

I have a mysql database running with the following docker-compose.yml: version: '3.3' services: db: image: mysql:5.7 restart: always environment: ...
ma77c's user avatar
  • 111
2 votes
0 answers
26 views

Connecting to MySQL Remotely on Azure VM

I am having trouble connecting remotely to my MySql install that runs on an Azure VM. Here is what I did: Ubuntu VM with MySql 5.7 installed Bind Address set to 0.0.0.0 User granted rights with ...
Nick's user avatar
  • 121
1 vote
1 answer
992 views

docker mysql container not running suddenly

docker mysql container was working perfectl.But after restarting of the server and using the start command to run the conatiner it is not working.My other containers are all up and running as normal....
Rajesh k's user avatar
0 votes
1 answer
67 views

Unable to create container after installing mysql and phpmyadmin | Ubuntu

I have installed docker successfully and try to install phpmyadmin and mysql. I have did following steps. Using below link I have pulled php version https://hub.docker.com/r/codepulse/php-7.2.0-...
Jaimin's user avatar
  • 101
2 votes
2 answers
452 views

How to handle AWS Offsite or cross-account RDS (mysql) backups?

AWS Provides a great solution to provide point-in-time recovery backups within RDS. However, while we take every measure to protect the root account, I'm paranoid that if someone were to gain access ...
Brad's user avatar
  • 179
0 votes
1 answer
47 views

Dockerized MySql slower in Wifi than ethernet

When I try to connect to a MySQL server that runs in a docker container(in System A) through my application(Running in system B) via wifi, it takes at least 4X amount of time than it would when both ...
daedalus_hamlet's user avatar
3 votes
1 answer
117 views

Mysql with Kubernetes

I am converting a webapp from monolithic to kubernetes based architecture. But how can mysql be persistent with data when we have 2 mysql pods in each of 2 differnet nodes? I think we can mount a ...
ankk98's user avatar
  • 131
2 votes
1 answer
4k views

Persistent data in MySQL with Docker

If I startup MySQL server during docker build (derived from official MySQL Dokcer Image) in two different statements, would be database files be pertained? I would say yes, but it seems to be wrong. ...
Ta Mu's user avatar
  • 6,782
5 votes
1 answer
751 views

Terraform: Delay the MySQL Provider

I have a Terraform project which uses the MySQL provider. Because of the way Terraform works, the MySQL provider will fail to load correctly because the AWS_RDS instance doesn't exist. Is there a ...
Black Dynamite's user avatar
1 vote
2 answers
9k views

Can't connect to my dockerized MySQL

I'm trying to implement this pre-cooked package of NGINX, PHP-FPM, MySQL, E-L-K. Everything is working fine but the connection with the database. It throws a ConnectionException. I'm not really sure ...
CarlosAS's user avatar
  • 435
8 votes
3 answers
3k views

How to create staging servers for multiple git branches?

I have to create a new staging process for our development and testing. At any given time, there are only around 4 git branches actively being developed and tested. Within each git branch, there may ...
max1221's user avatar
  • 81