softlang/mysql repository overview

#!/bin/bash
cmd='innobackupex --no-timestamp --databases="mysql sys information hlzyb" --parallel=2 --stream=xbstream -t /tmp/xtrabackup '
#ssh etl04.prd "docker exec -i mysql-m1 bash -c '$cmd'" > zzz/abc.bak
ssh [email protected] "docker exec -i mysql-m1 bash -c '$cmd'" | xbstream -x -C /opt/bak1

# xbstream -x -C /data/temp/"
ssh -i ~/.ssh/id_rsa [email protected] "docker exec -i mysql-m1 bash -c '$cmd'" | xbstream -x -C /opt/bak1

# success
cmd='innobackupex --parallel=2 --stream=xbstream /tmp/xtrabackup '
ssh -i ~/.ssh/id_rsa [email protected] "docker exec -i mysql-m1 bash -c '$cmd'" | xbstream -x -C /opt/bak1
cmd='xtrabackup --backup --no-timestamp --databases="mysql information_schema performance_schema sys hlzyb wbmeet" --parallel=2 --stream=xbstream -t=/tmp/xtrabackup '

ssh -i ~/.ssh/id_rsa root@remote "docker exec -i mysql-m1 bash -c '$cmd'" | xbstream -x -C /opt/bak1
innobackupex --apply-log /backups/2018-07-30_11-04-55/


# testing
cmd='xtrabackup --backup --no-timestamp --databases="mysql information_schema performance_schema sys hlzyb wbmeet" --parallel=2 
--stream=xbstream -t=/tmp/xtrabackup '

# better format
my_containerid=`docker ps -f "label=com.docker.swarm.service.name=gitlab_gitlab" --format "{{.ID}}"`
docker exec -it $my_containerid bash

# You could use the following command to print the container id:
docker container ls  | grep 'container-name' | awk '{print $1}'

# As a bonus point, if you want to login to the container with a container name:
docker exec -it $(docker container ls  | grep 'container-name' | awk '{print $1}') /bin/bash

# docker-compose -p mysql8-uat -f compose.yaml up -d
# docker-compose -p mysql8-uat down
# conf@container:`/etc/mysql/conf.d/mysqld.cnf`
version: "3.7"
networks:
  default:
    name: app
    external: true

services:
  mysql8-uat:
    image: mysql:8.0.29
    #image: mysql:8.0.29-debian
    hostname: "mysql8-uat"
    container_name: "mysql8-uat"
    environment:
      TZ: "Asia/Shanghai"
      MYSQL_ROOT_PASSWORD: "xxx"
      MYSQL_USER: dev
      MYSQL_PASSWORD: "xxx"
    volumes:
      - "./backup:/backup:rw"
      - "./data:/var/lib/mysql:rw"  
      - "./conf:/etc/mysql/conf.d:ro"
    network_mode: host
    restart: always
    deploy:
      resources:
        limits:
          cpus: '2'
          memory: 4G
  
  v57-mykit:
    image: softlang/mysql:v57kit
    hostname: "v57-mykit"
    container_name: "v57-mykit"
    environment:
      TZ: "Asia/Shanghai"
    volumes:
      - "./backup:/backup:rw"
      - "./data:/app:rw"
    restart: always
    deploy:
      resources:
        limits:
          cpus: '2'
          memory: 2G

# ~/.ssh/config
Host *
 StrictHostKeyChecking no
 UserKnownHostsFile=/dev/null