MySQL dump over SSH to a remote host

Dec 14, 2015 · 1 min read · mysql bash ssh ·

Original Article - http://christiank.org/wp/2010/12/pipe-a-gzipped-mysql-dump-over-ssh/ If you want to take a SQL dump from some host, compress it and send it across SSH to another host then this is the command you are chasing mysqldump -u MYSQL_USERNAME -p YOUR_DATABASE | gzip -c | ssh USERNAME@YOUR_TO_HOST 'cat > …

Cinder - Resize root volume

Nov 11, 2015 · 2 min read · cinder openstack ·

Share on:

Some code To resize the root volume of an instance can be tricky, this worked for me Note some commands, particularly "cinder reset-state" returned a HTTP 403, i had to run those as admin 1[root@vm-os-ks01 ~]# source admin.rc 2[root@vm-os-ks01 ~]# cinder reset-state --state available …

Add suer to docker group

Jan 1, 0001 · 1 min read · linux bash ·

Share on:

It feel like every time I run docker ps I get blah blah blah, permission denied The simple oneliner fix.. And the bonus, you dont even need to log out :) sudo usermod -G docker -a $USER && newgrp docker

Notes on exporting and importing individual PG's to OSD's

Jan 1, 0001 · 1 min read · ceph ·

Share on:

ceph-objectstore-tool --data-path /var/lib/ceph/osd/ceph-275/ --pgid 13.480 --op list | wc -l ceph-objectstore-tool --data-path /var/lib/ceph/osd/ceph-263/ --pgid 13.480 --op export --file ~/pg-13.480-ss5-osd263.old ceph-objectstore-tool --data-path /var/lib/ceph/osd/ceph-263/ --type bluestore --pgid 13.480 --op import …

Thoughts and notus for using swap space

Jan 1, 0001 · 2 min read · linux swap ·

Share on:

Whats using swap space for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{ print ""}' $file; done | sort -k 2 -n -r | less Who is eating all of my RAM? ps aux --sort=-%mem | head Where are my swap files cat /proc/swaps How to add more swap space 1. Create empty file: This file will contain virtual …