Hot answers tagged

7 votes

How to create staging servers for multiple git branches?

1) How can I run several different branches on the staging server? Docker 2) How would I set up the DB evolution system to make sure it always has appropriate DB for each branch? This depends on ...
user avatar
  • 3,674
4 votes
Accepted

how to send a password to MySQL with docker?

As the documentation clearly states docker run command should be invoked as follows: docker run [OPTIONS] IMAGE[:TAG|@DIGEST] [COMMAND] [ARG...] so when you run docker run mysql -p 3306:3306 -e ...
user avatar
3 votes
Accepted

How to create a "silent" MySQL docker container?

You can run the container in detached mode by passing -d or --detach with the run command: https://docs.docker.com/engine/reference/run/#detached-vs-foreground
user avatar
  • 835
3 votes
Accepted

Can't connect to my dockerized MySQL

Since the response is Access denied for user so the port and the ip address is correct. I guess the only issue as @James said will be in the permission, you have to allow root access to mysql from ...
user avatar
2 votes

How to create staging servers for multiple git branches?

I'd argue that this isn't actually about staging servers. A staging server closely mimics the production environment, and is where a release goes immediately prior to going to production. A feature ...
user avatar
2 votes

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

On top of protecting your root account as best as you can, you should be able to reduce the risk of such resource deletion if you have more than 1 resource to protect. For example if all AWS ...
user avatar
  • 650
2 votes

Mysql with Kubernetes

I would suggest to only run stateless apps in k8s. One should run statefull apps like databases in dedicated database solutions like AWS RDS.
user avatar
  • 12.6k
2 votes
Accepted

Persistent data in MySQL with Docker

That's a known issue .. since image layers are built using containers, data saved to folders does not make it to the next layer or your final container Removing intermediate container b3ff83bbf273 ...
user avatar
  • 1,689
2 votes

docker | database connection refused between two containers

Your golang api should be included in the compose file and added to the same network. It also looks like when you run the golang api that you are adding it to a network other than backend, which is ...
user avatar
2 votes

Let docker containers work with each other

What would be the best way to share ports among the containers? You don't really "share" ports between containers. Instead, you want to create network and attach each container to that network. ...
user avatar
  • 261
2 votes

Combining Two Containers

At first, I misread your question, thinking you wanted to run more than one service together, so I had recommended Docker Compose which makes it easy to run multiple services together, with networking,...
user avatar
2 votes

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

Solution: root $ root $ mysql -h localhost -P 3306 --protocol=tcp -u user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: ...
user avatar
1 vote
Accepted

K8S + HELM. Create a persistence volume for mysql database

It seems that you are using the host file system for the persistent volume. Assuming that you have multiple worker nodes and the pod restarts on a different node, the data is “lost” (only exists in ...
user avatar
  • 71
1 vote
Accepted

ansible mysql query not showing results

The community.mysql.mysql_query module documents its return values as: executed_queries query_results rowcount So, if you're registering r_query, and you want to see the result, you can call r_query....
user avatar
  • 3,058
1 vote

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

The python_app and mysql_db services/containers do not share a network namespace, thus they don't have the same localhost. Just use mysql_db as the hostname when connecting to the DB. I would ...
user avatar
  • 158
1 vote

Bootstrapping Galera Cluster in Docker

For now I gave up on this approach after stumbling over this paragraphs in the Redis cluster documentation: Currently Redis Cluster does not support NATted environments and in general environments ...
user avatar
1 vote

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

The default Dockerfile shell is sh. I don't think echo there has the -e modifier for backslash. Newline & other special symbols will work by default. In your command, resulting .my.cnf would ...
user avatar
  • 66
1 vote
Accepted

Confluence mySQL image doesn't start anymore

I actually found the solution here: https://stackoverflow.com/a/64150016/1526406 Maybe this helps others as well.
user avatar
  • 11
1 vote

How can I model this schema in MySQL?

Have you thought about what happen with stale/old data?? Each new version creates a ton of new entries. Management becomes a nightmare the DB becomes a SPOF(single point of failure). Better Solution:...
user avatar
  • 46
1 vote
Accepted

backup dockerise mysql database from host volume

based on @ulrich answer, but with mysqldump : DATE_TIME=`date +"%Y%m%d_%H%M" CONTAINER_NAME="mysql_server" CONTAINER=`docker ps -q -f name=${CONTAINER_NAME}` PASSWORD=`docker exec $...
user avatar
  • 111
1 vote

backup dockerise mysql database from host volume

I have a little script for my MariaDb database inside a docker container. The setup is comparable. I have a database container with a mounted volume. Furthermore I have a second volume for backups ...
user avatar
1 vote
Accepted

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

One way to achieve this is by using the MySQL socket to connect instead of port. For this you would have bind a mount to your container. You would anyway need a host directory bound to container to ...
user avatar
1 vote

Managed MySQL cluster - similar solution for a private cloud

There shouldn't be any reason why you can't. I think that the issue would be in getting the memory management correct on the host. The orchestration would be the same. Here's some resources: https:...
user avatar
  • 209
1 vote
Accepted

mariadb docker on raspberry

Does the following work? docker-compose exec mariadb /usr/bin/mysql -u <your_db_username> --password=<your_db_password> < your_db_backup.sql Note: mariadb is the name of your ...
user avatar
  • 835
1 vote

docker | database connection refused between two containers

In addition to connecting app container with same backend network, you will also need to fix MySQL host parameter in connection string. Looking at main function you have MySQL host set to localhost ...
user avatar
  • 51
1 vote

docker mysql container not running suddenly

Without seeing the specific error it looks like the container's runtime process is either crashing or exiting. When a docker container's runtime process exits the container stops. You can get more ...
user avatar
1 vote

Unable to create container after installing mysql and phpmyadmin | Ubuntu

Pulling the images only make them available for you to use locally. Therefore, to use them within a container you should run the command docker run with the appropriate configuration for each services
user avatar
1 vote

Terraform: Delay the MySQL Provider

I think you could achieve something similar by first running Terraform against your RDS resources, and then running Terraform again on all resources. On your first pass, you can use -target option to ...
user avatar
1 vote

Can't connect to my dockerized MySQL

First, confirm that the container is actually listening for connections and has properly bound to the interface. If not, you probably need to fix the bind-address= and/or port= directives in your my....
user avatar
  • 3,674
1 vote

How to create staging servers for multiple git branches?

That is what gitlab does best, consider to move to gitlab, setup a kube cluster and auto deploy. This will deploy each branch to an unique URL for testing.
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible