Docker & mysql – import data from host
docker exec -i your-docker-name /bin/bash -c ” mysql -D your-datat-base-name ” < '/path/to/your/data.sql'
Archive for the ‘ Uncategorized ’ Category
OS X routing changed by Cisco AnyConnect
If you connect via VPN Cisco client, the routing table is changed. You can see the actual routes with following command: netstat -nr | grep “192.168” # this is my result: 192.168.0/16 10.0.255.208 UGSc 1 0 utun1 192.168.191 link#17 UCS 2 0 utun1 192.168.191.255 link#17 UHWIi 2 2 utun1 192.168.203 link#17 UCS 2 0 utun1 […]
Reset multipath bindings
To do it, remove adequate lines in the /etc/multipath/bindings Thus, you can reset mpatha, mpathb, etc.
Docker with mysql not starting
How to check what happend. I add that docker logs -f container_name | container id neither does work. The solution for me is to remove the actual container (condition that it has some persistent storage) and run new one with entrypoint parameter replaced: Was: docker run -v /dockers_persistent/data/database_1:/var/lib/mysql -v \ MYSQL_ROOT_PASSWORD=’*******’ -d f44353327cb6 To be: […]
boost performance for bulk insert operation into large table.
I have encountered some performance issues while migrating data from SSD pure Linux environment (no virtualization) into hybrid paravirtualized multi-tier stuff. I used docker containers and bCache hybrid storage. Frontend consists of NVMe (fusionIO) 400G RAID1 and backend is EMC VNX5200 SAS RAID6. In my case the process of mass inserts was not stable – […]
Plesk, spamassassin and bayes
spamd[8917]: plugin: eval failed: bayes: (in learn) locker: safe_lock: cannot create lockfile user@domain.pl/.spamassassin/bayes.mutex: No such file or directory How to fix: mkdir /var/qmail/bayes chown popuser:popuser /var/qmail/bayes chmod 770 /var/qmail/bayes mkdir /var/spamassassin chown popuser:popuser /var/spamassassin chmod 770 /var/spamassassin
NVMe, software raid disappears after reboot
# Annoying… mdadm –create /dev/md3 –level=1 –raid-disks=2 /dev/nvme0n1p3 /dev/nvme1n1p3 [root@db7 ~]# parted /dev/nvme0n1 p Model: Unknown (unknown) Disk /dev/nvme0n1: 400GB Sector size (logical/physical): 512B/512B Partition Table: gpt Disk Flags: Number Start End Size File system Name Flags 1 1049kB 40.0GB 40.0GB primary raid 2 40.0GB 80.0GB 40.0GB mysql raid 3 80.0GB 84.0GB 4000MB xd raid […]
Docker, storage isolation >= 1.8
lvcreate -n pool0 -L 20G dockers lvcreate -n pool0meta -L 1G dockers lvconvert –type thin-pool –poolmetadata dockers/pool0meta dockers/pool0 # check how it is working? [root@db7 ~]# docker daemon –storage-opt dm.thinpooldev=/dev/mapper/dockers-pool0 Install to systemctl echo ‘OPTIONS=”–storage-opt dm.thinpooldev=/dev/mapper/dockers-pool0″‘ >> /etc/sysconfig/docker vi /usr/lib/systemd/system/docker.service [Unit] Description=Docker Application Container Engine Documentation=https://docs.docker.com After=network.target docker.socket Requires=docker.socket [Service] EnvironmentFile=-/etc/sysconfig/docker Type=notify ExecStart=/usr/bin/docker daemon -H […]
Docker, volume sharing
docker run -it -v /host_storage/:/storage_inside_docker –name=”vol1″ –cpu-quota=2 -m 128M 9eb167f08bdd permission denied? http://stackoverflow.com/ Solution: docker run -it -v /host_storage/:/storage_inside_docker:Z –name=”vol1″ –cpu-quota=2 -m 128M 9eb167f08bdd
Docker, storage isolation < 1.8
How to isolate Docker containers and stuff… [root@localhost ~]# pvs PV VG Fmt Attr PSize PFree /dev/md0p1 dockers lvm2 a– 37.25g 37.25g /dev/md0p2 mysql lvm2 a– 37.25g 764.00m /dev/sda3 centos lvm2 a– 12.93g 4.00m [root@localhost ~]# echo VG=dockers > “/etc/sysconfig/docker-storage-setup” [root@localhost ~]# docker-storage-setup Rounding up size to full physical extent 40.00 MiB Wiping xfs signature […]
Information
Change this sentence and title from admin Theme option page.
Recent entry
- 2017-11-09
- firewall-cmd, xargs and formatting
- 2017-05-05
- Data alignment in block devices
- 2017-05-05
- Spark and CSV and SQL
- 2017-05-04
- Spark and CSV for python language
- 2016-12-08
- Docker & mysql – import data from host
Archive
- November 2017
- May 2017
- December 2016
- November 2016
- June 2016
- May 2016
- February 2016
- November 2015
- October 2015
- September 2015
- August 2015
- April 2015
- March 2015
- February 2015
- January 2015
- November 2014
- August 2014
- May 2014
- April 2014
- March 2014
- January 2014
- December 2013
- February 2013
- September 2012
- May 2012
- January 2012
- September 2011
- June 2011
- April 2011
- March 2011
- February 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- February 2010