March 15th, 2023
Docker Commands
MySQL docker
> docker run --name docker-mysql -v /var/lib/mysql-lively-data:/var/lib/mysql -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=oplink456 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d -p:3306:3306 --net livelyhealth --restart always mysql:8 --default-authentication-plugin=mysql_native_password
> docker run --name docker-mysql -v /var/lib/mysql-lively-data:/var/lib/mysql -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=secret -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d -p:3306:3306 --restart always mysql:8 --default-authentication-plugin=mysql_native_password
> docker run --name docker-durgesh -v /var/lib/mysql-durgesh-data:/var/lib/mysql -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=secret -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d -p:3307:3306 --restart always mysql:8 --default-authentication-plugin=mysql_native_password
Mongo docker
> docker run --name mongodb0 -v /data/mongodb0:/data/db -p 27017:27017 -e MONGO_INITDB_ROOT_USERNAME=root --privileged=true -e MONGO_INITDB_ROOT_PASSWORD=root -d mongo --auth
> docker exec -it b654ee788e95 bash
> mongodb://root:root@127.0.0.1:27017/?authSource=admin
Postgres docker
> docker run -d -p 5432:5432 \
--restart always \
--name some-postgres \
-e POSTGRES_PASSWORD=mysecretpassword \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-v ~/AWSMO/postgres-data:/var/lib/postgresql/data \
postgres
> docker run -d -p 5432:5432 \
--restart always \
--name some-postgres \
-e POSTGRES_PASSWORD=mysecretpassword \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-v /home/soundarya/temp/db-data/postgres/data1:/var/lib/postgresql/data \
postgres
Remove all images with tag none
docker rmi $(docker images --filter "dangling=true" -q --no-trunc)
Remove all exited containers docker
docker rm $(docker ps -a -f status=exited -q)
docker rm $(docker ps -a -q)
Find all images using wildcharacter search
docker images --filter=reference='*hands*/*:*latest*'
REPOSITORY TAG IMAGE ID CREATED SIZE
hands-on/product-composite-service latest 319db4ad7810 15 minutes ago 337MB
hands-on/gateway latest 7dc5a3abb416 15 minutes ago 328MB
hands-on/config-server latest db7c7bceb7bc 15 minutes ago 309MB
Save docker images on other server using wild character
docker images --filter=reference='*hands*/*:*latest*' | awk '{print $1 " " $2 " " $3 }' | while read REPOSITORY TAG IMAGE_ID
do
echo "== Save image: $REPOSITORY"
docker save "$REPOSITORY" | ssh -i ~/.ssh/multipass-k8s -C ubuntu@10.131.187.176 docker load
done
## RabbitMQ docker
# --------------------
docker run --rm -it -d --hostname my-rabbit -p 15672:15672 -p 5672:5672 rabbitmq:3-management
http://localhost:15672/
credentials guest:guest
https://codeburst.io/get-started-with-rabbitmq-on-docker-4428d7f6e46b
## connect mysql in terminal
docker exec -it bcf53fb14786 bash
mysql --protocol=tcp -u root -p -P 3306
mysql -uroot -p -h 127.0.0.1
mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' IDENTIFIED BY "admin";
FLUSH PRIVILEGES;
## run docker local container
# -----------------------------------------------------------
# Connect MySQL and Spring with separate docker containers
# -----------------------------------------------------------
# 1) build docker for backend
docker build -t longevity-backend .
# 2) create network to be used
docker network create livelyhealth
# 3) start mysql with network name
docker run --name docker-mysql -v /var/lib/mysql-lively-data:/var/lib/mysql -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=oplink456 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d -p:3306:3306 --net livelyhealth --restart always mysql:8 --default-authentication-plugin=mysql_native_password
# 4) start backend with network name
docker run -d -p 8080:8080 -t --net livelyhealth longevity-backend
# -----------------------------------------------------------
# E N D
# -----------------------------------------------------------
# -------- application.properties --------------
spring.datasource.url=jdbc:mysql://docker-mysq
l:3306/longevity
# -----------------------------------------------------------
docker network ls
docker network inspect livelyhealth
# once mysql docker starts, change the user/pwd
mysql -u homestead -p -h 127.0.0.1
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'oplink456';
ALTER USER 'homestead'@'%' IDENTIFIED WITH mysql_native_password BY 'secret';
FLUSH PRIVILEGES;
# use in compass
mongodb://admin:password@localhost:27017/tutorialmern?readPreference=primary&appname=MongoDB%20Compass&ssl=false
# use in code
mongodb://admin:password@localhost:27017/tutorialmern?authSource=admin
## if error with client comes while running
# ==============================
https://stackoverflow.com/questions/55763428/react-native-error-enospc-system-limit-for-number-of-file-watchers-reached
# insert the new value into the system config
echo fs.inotify.max_user_watches=524288 | sudo tee -a /etc/sysctl.conf && sudo sysctl -p
# check that the new value was applied
cat /proc/sys/fs/inotify/max_user_watches
# config variable name (not runnable)
fs.inotify.max_user_watches=524288
# ==============================
# kill process of any port
kill $(lsof -t -i:3001)
sudo lsof -i -P -n | grep 3306
kill -9 $(lsof -t -i:3306)
# get folder size
du -h --max-depth=1
mongodb+srv://soundarya:<password>@cluster0.ny9zr.mongodb.net/myFirstDatabase?retryWrites=true&w=majority
DATABASE='mongodb+srv://soundarya:droisys@cluster0.ny9zr.mongodb.net/mernstack?retryWrites=true&w=majority';
DATABASE="mongodb://admin:password@localhost:27017/mernstack?authSource=admin"
XuH4tfjE6ZjZXC_xoG48wGaQlU1vcLGWk
# Shortcuts
ln -s /media/soundarya/h_drive/hdrive_data/ ~/hdrive_data
ln -s ~/hdrive_data/MERN/projects/mern_thapa_local/docker_info.md ~/Desktop/desktop_info.md
ln -s ~/hdrive_data/spring ~/spring
ln -s ~/hdrive_data/spring-durgesh ~/spring-learn
ln -s ~/hdrive_data/MERN ~/mern
ln -s ~/hdrive_data/Freedom_financial ~/ff
ln -s ~/hdrive_data/NodeJS ~/NodeJS
#encfs
encfs /mnt/h_drive/hdrive_data/temp/J1A /mnt/h_drive/hdrive_data/temp/J2
fusermount -u /mnt/h_drive/hdrive_data/temp/J2
sudo umount -l /mnt/h_drive/hdrive_data/temp/J2
#compress file
tar cfz bin.tgz bin
#uncompress tar.gz file
tar -xvzf file.tar.gz
#search
grep -rnw '/path/to/somewhere/' -e 'pattern'
#Timestream databases
https://www.g2.com/categories/time-series-databases
#InfluxDB
https://hub.docker.com/_/influxdb
$ docker run -p 8086:8086 \
-v $PWD/data:/var/lib/influxdb2 \
-v $PWD/config:/etc/influxdb2 \
-v $PWD/scripts:/docker-entrypoint-initdb.d \
-e DOCKER_INFLUXDB_INIT_MODE=setup \
-e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
-e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
-e DOCKER_INFLUXDB_INIT_ORG=my-org \
-e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
-e V1_DB_NAME=v1-db \
-e V1_RP_NAME=v1-rp \
-e V1_AUTH_USERNAME=v1-user \
-e V1_AUTH_PASSWORD=v1-password \
influxdb:2.0
$ docker run -d -p 8086:8086 \
--restart always \
-v ~/AWSMO/InfluxDB-data/data:/var/lib/influxdb2 \
-v ~/AWSMO/InfluxDB-data/config:/etc/influxdb2 \
-v ~/AWSMO/InfluxDB-data/scripts:/docker-entrypoint-initdb.d \
-e DOCKER_INFLUXDB_INIT_MODE=setup \
-e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
-e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
-e DOCKER_INFLUXDB_INIT_ORG=my-org \
-e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
-e V1_DB_NAME=v1-db \
-e V1_RP_NAME=v1-rp \
-e V1_AUTH_USERNAME=v1-user \
-e V1_AUTH_PASSWORD=v1-password \
influxdb:2.1.1
influx config create --config-name influx-config \
--host-url http://localhost:8086 \
--org awsmo \
--token PJ7zd8rw0ai7rOMnTUil_kIz2wlcOzVH9_qD4p_LYxehQS6Uyp6mJ3X9QQUjNAEIigvsMSdyKlvrd5lOLtANRA== \
--active
3.216.123.152
postgres/awsmo@123
db: awsmodb
====
https://www.tutorialspoint.com/spring_boot/spring_boot_database_handling.htm
Restart Postgres server
----------------------------------
Postgres live
3.216.123.152
> cd /usr/pgsql-14/bin
> sudo su postgres
> bash-4.2$ ./pg_ctl restart -D /var/lib/pgsql/14/data
Find number of open connections
----------------------------------
> ps ax | grep post | wc -l
influx -username admin -password 'awsmo@12345'
influx config \
--host-url http://localhost:8086 \
--org my-org \
--token z5XiyReADjf0W915EzfZVGlkGXwhdZjJjOCGVeFjr7iZZ8HTVXK15Z7zA5oySQdn303k6a-uozf2rP67GAo60g== \
--active
influx query 'from(bucket:"my-bucket") |> range(start:-30d)'
https://techviewleo.com/how-to-install-influxdb-on-amazon-linux/
CREATE USER admin WITH PASSWORD 'awsmo@12345' WITH ALL PRIVILEGES
GRANT ALL PRIVILEGES TO admin
curl -G "http://localhost:8086/query?u=admin&p=AWSMO@Password" --data-urlencode "q=SHOW DATABASES"
#QuestDB
https://questdb.io/docs/get-started/docker/
docker run -p 9000:9000 \
-p 9009:9009 \
-p 8812:8812 \
-p 9003:9003 \
questdb/questdb
#open elementary code
io.elementary.code
Influxdb history:
================
Date: 22 Feb 2022
Exported Data: 14000 records, excel size: 3.8 mb
Influxdb Full Backup size: 1.3G
Git commands
# create git repo
git init --bare ~/mern/project.git
# go to project, initialize the git
git init .
# add git remote to local repo
git remote add origin ~/mern/project.git
# complete the remaining git commands
git add .
git commit -m "msg"
git push
# connect git on local network
git remote add origin ssh://soundarya@192.168.1.6:/home/soundarya/spring-durgesh/Springboot-LSF.git
git branch --set-upstream-to=origin/master
Leave a Reply