A generic set of commands to reference when working with Docker
$ sudo docker run --name mydb -e MYSQL_ROOT_PASSWORD=pass -d mysql:latest| """ | |
| # Export FatSecret Weight History CSV | |
| A simple script for exporting all FatSecret weight history to CSV. | |
| ## Installation | |
| *Install Dependencies* | |
| ```sh |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| import os | |
| import base64 | |
| encoded_env_file = os.environ.get("ENV_FILE") | |
| if encoded_env_file != None: | |
| decoded_env_file = base64.b64decode(encoded_env_file).decode('utf-8') | |
| with open("./" + str(os.environ.get("FILE_NAME", ".env")), "w") as text_file: | |
| text_file.write(decoded_env_file) |
| for node in $(kubectl get nodes -l cloud.google.com/gke-nodepool=default-pool -o=name); do | |
| kubectl drain --force --ignore-daemonsets --delete-local-data --grace-period=10 "$node"; | |
| done |
| for node in $(kubectl get nodes -l cloud.google.com/gke-nodepool=default-pool -o=name); do | |
| kubectl cordon "$node"; | |
| done |
| gcloud container node-pools create my-pool \ | |
| --cluster=my-cluster \ | |
| --machine-type=n1-highmem-2 \ | |
| --num-nodes 1 --enable-autoscaling | |
| --min-nodes 1 --max-nodes 3 |
| kubectl create -f ingress-service.yml | |
| # Verify exposed IP address is ready | |
| kubectl get ingress |