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 […]

Read more...

If your architecture uses MySQL replication and you make some ETL transformations and you observed some incredible values in autoincrement columns (i.e. the value dramatically increases – by hundred of thousands or event millions) – it means you have just experienced a bug. Very clear description is presented on site http://bugs.mysql.com/. However, in my case […]

Read more...

### Partitioning: mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; ERROR 1005 (HY000): Can’t create table ‘inforia.#sql-7f30_17f4dd0’ (errno: 150) Cannot resolve table name close to …. mysql>alter table clipping3 remove partitioing; mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; Query OK, […]

Read more...

PL/SQL: I wouldn’t recommend to use the following construction: IF EXISTS (SELECT 1 FROM `table_a` WHERE `id` = `_ID`) THEN UPDATE `table_a` SET `value` = 1 WHERE `id` = `_ID`; ELSE INSERT INTO `table_a` […]; END IF; In my case there was a trigger (on table_a) who additionaly modifed “table_b”. When I changed the engine […]

Read more...

Install JQ to make Json more human readable. #!/bin/bash # Backup of elasticsearch # Scenario: make backup of every open index once a day function write_to_stderr { echo “$@” 1>&2 } INDEX_TO_EXLUDE=”^_\|SOME_SPECIAL_INDEX” REPOSITORY=”backup” for INDEX_NAME in `curl ‘localhost:9200/_cat/indices?v’ 2>/dev/null | grep “\sopen\s” | awk ‘{print $3}’ `; do INDEX_LOG_FILE=”/tmp/bck.$INDEX_NAME.log” IS_SPECIAL_INDEX=`echo “$INDEX_NAME” | grep -c “$INDEX_TO_EXLUDE” […]

Read more...