Vasily Asakasinsky asakasinsky

## .gitlab-ci.yaml
image: docker:latest
services:
  - docker:dind
stages:
  - build
  - test
  - release
variables:
  CONTAINER_IMAGE: registry.anuary.com/$CI_PROJECT_PATH
  DOCKER_DRIVER: overlay2

## dockerCMD.txt
docker exec -i mysql_container mysql -uexampleName -ppassword database_name < filename.sql

docker cp filename.sql conatianer_ID:/filename.sql
docker exec -it container_ID bin/bash
mysql -u<username> -p
mysql> use <DB_NAME>;
mysql> source ./<FILE_NAME>.sql


docker exec $db_id mysql -hdb -uopencart -ppassword opencart -e "SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));"

## clickhouse.sh
sudo mkdir -p /opt/clickhouse/{data,etc,log}
sudo chmod 777 /opt/clickhouse/{data,etc,log}
sudo docker run -d --name clickhouse \
     --ulimit nofile=262144:262144 \
     -p 127.0.0.1:8123:8123 -p 127.0.0.1:9000:9000 \
     -v /opt/clickhouse/log:/var/log/clickhouse-server \
     -v /opt/clickhouse/data:/var/lib/clickhouse \
     yandex/clickhouse-server

## [docker-machine create] #docker #docker-machine
docker-machine create \
	--driver virtualbox \
	--virtualbox-cpu-count "4" \
	--virtualbox-memory "4000" \
	--virtualbox-no-vtx-check \
	default

## rabbitmq, docker-compose
version: '3'
services:
  rabbitmq:
    image: rabbitmq:3.7.14-management-alpine
    hostname: "rabbit"
    environment:
      RABBITMQ_DEFAULT_VHOST: "/"
    ports:
      - "15672:15672"
      - "5672:5672"

## list-containers-horizontally
# This can be in .zshrc or .bash_profile
export FORMAT="\nID\t{{.ID}}\nIMAGE\t{{.Image}}\nCOMMAND\t{{.Command}}\nCREATED\t{{.RunningFor}}\nSTATUS\t{{.Status}}\nPORTS\t{{.Ports}}\nNAMES\t{{.Names}}\n"

docker ps --format $FORMAT

## docker_disk_usage.sh
docker system df --verbose

## docker_command_essentials.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                asakasinsky
                / docker_command_essentials.md
            
            
              Created
              December 30, 2022 00:28
                — forked from askalee/docker_command_essentials.md
            
              
                docker: docker command essentials
              
          
    Folder

├── service1
│   └── Dockerfile
├── service2
│   └── Dockerfile  
├── service3
│   └── Dockerfile  
├── docker-compose.yml
└── docker-compose-dev.yml  


## docker.txt
# Show running containers
docker container ls

# Show all containers
docker container ls -a

# Create container from image
# -d run as daemon in background
# -p say what port to map in container
# --name give container a name

## sample.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                asakasinsky
                / sample.md
            
            
              Created
              December 30, 2022 00:28
                — forked from yasokamoto/sample.md
            
              
                docker in docker sample
              
          
    tl;dr

memo about docker in docker
Dockerfile

FROM ubuntu:14.04

RUN apt-get update -qq && apt-get install -qqy \
    apt-transport-https \
 ca-certificates \
	image: docker:latest
	services:
	- docker:dind
	stages:
	- build
	- test
	- release
	variables:
	CONTAINER_IMAGE: registry.anuary.com/$CI_PROJECT_PATH
	DOCKER_DRIVER: overlay2
	docker exec -i mysql_container mysql -uexampleName -ppassword database_name < filename.sql

	docker cp filename.sql conatianer_ID:/filename.sql
	docker exec -it container_ID bin/bash
	mysql -u<username> -p
	mysql> use <DB_NAME>;
	mysql> source ./<FILE_NAME>.sql


	docker exec $db_id mysql -hdb -uopencart -ppassword opencart -e "SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));"
	sudo mkdir -p /opt/clickhouse/{data,etc,log}
	sudo chmod 777 /opt/clickhouse/{data,etc,log}
	sudo docker run -d --name clickhouse \
	--ulimit nofile=262144:262144 \
	-p 127.0.0.1:8123:8123 -p 127.0.0.1:9000:9000 \
	-v /opt/clickhouse/log:/var/log/clickhouse-server \
	-v /opt/clickhouse/data:/var/lib/clickhouse \
	yandex/clickhouse-server
	docker-machine create \
	--driver virtualbox \
	--virtualbox-cpu-count "4" \
	--virtualbox-memory "4000" \
	--virtualbox-no-vtx-check \
	default
	version: '3'
	services:
	rabbitmq:
	image: rabbitmq:3.7.14-management-alpine
	hostname: "rabbit"
	environment:
	RABBITMQ_DEFAULT_VHOST: "/"
	ports:
	- "15672:15672"
	- "5672:5672"
	# This can be in .zshrc or .bash_profile
	export FORMAT="\nID\t{{.ID}}\nIMAGE\t{{.Image}}\nCOMMAND\t{{.Command}}\nCREATED\t{{.RunningFor}}\nSTATUS\t{{.Status}}\nPORTS\t{{.Ports}}\nNAMES\t{{.Names}}\n"

	docker ps --format $FORMAT
	# Show running containers
	docker container ls

	# Show all containers
	docker container ls -a

	# Create container from image
	# -d run as daemon in background
	# -p say what port to map in container
	# --name give container a name