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 ...
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 ...
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
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 ...
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 ...
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 ...
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.
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
...
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 ...
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. ...
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,...
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: ...
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 ...
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....
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 ...
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 ...
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 ...
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.
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:...
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 $...
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 ...
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 ...
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:...
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 ...
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
...
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 ...
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
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 ...
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....
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.
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
mysql × 33docker × 21
kubernetes × 4
docker-compose × 4
containers × 4
amazon-web-services × 3
dockerfile × 3
networking × 3
databases × 3
images × 3
amazon-rds × 3
ubuntu × 2
backup × 2
ansible × 1
terraform × 1
git × 1
azure × 1
linux × 1
windows × 1
python × 1
testing × 1
microservices × 1
helm × 1
aws-lambda × 1
bash × 1