Skip to content

Instantly share code, notes, and snippets.

View tshabatyn's full-sized avatar

Taras Shabatyn tshabatyn

View GitHub Profile
@tshabatyn
tshabatyn / readme.md
Last active April 25, 2024 14:32
Install node yarn and pm2 version 14.21.3 for gitlab
# Run bash as gitlab user
sudo -E -H -u gitlab-runner -- bash

# Install NVM
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.7/install.sh | bash

# List node versions
nvm list-remote
@tshabatyn
tshabatyn / commands.bash
Last active April 1, 2024 16:14
Adding context to k8s
# Outputs current value of KUBECONFIG
echo $KUBECONFIG
# Adding PATH of all the context files separated with semicolon
export KUBECONFIG=~/Downloads/dev-cluster-kubeconfig.yaml:~/Downloads/qa-cluster-kubeconfig.yaml
# Outputs merged configuration of the joined context files
kubectl config view --flatten
# Save the merged configuration to the default kube config location
@tshabatyn
tshabatyn / MagentoGetOrderRestApi.sh
Created April 11, 2023 15:02
Get Magento 2 Order details by REST API
#!/usr/bin/env bash
set -e
# Determining path to the current shell script
THIS_FILE_DIR=$(dirname $(cd $(dirname $0); pwd))
STORE_URL=''
USER='admin'
PASS='123123q'
@tshabatyn
tshabatyn / confirm.Makefile
Created February 3, 2023 16:37 — forked from Pierstoval/confirm.Makefile
"confirm" action for your Makefile
# To use the "confirm" target inside another target,
# use the " if $(MAKE) -s confirm ; " syntax.
mycommand:
@if $(MAKE) -s confirm ; then \
execute_your_command_here ; \
fi
.PHONY: mycommand
# The CI environment variable can be set to a non-empty string,
@tshabatyn
tshabatyn / read.md
Created June 3, 2021 20:40
Compare two directories

rsync -n -avrc /home/sample1/* server2:/home/sample2/

@tshabatyn
tshabatyn / my.sql
Last active February 7, 2023 18:59
Create db and user for it
# MySQL 8.0
CREATE DATABASE my_db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
# Edit collation of existing DB
ALTER DATABASE my_db_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
# MySQL 5.7
CREATE DATABASE my_db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# Edit collation of existing DB
ALTER DATABASE my_db_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
@tshabatyn
tshabatyn / README.MD
Created September 1, 2020 20:48
Galera Cluster Recovery

Возврат к жизни кластера Галера

На всех нодах(серверах) где установлена Галера выполняем команду

ll /var/lib/mysql/grastate.dat

Нам нужена нода на которой этот файл был позже всех изменён.

На ноде с самым свежим файлом /var/lib/mysql/grastate.dat выполняем команду

@tshabatyn
tshabatyn / cleanImages.php
Created August 4, 2020 14:21 — forked from peterjaap/cleanImages.php
Script to clean up the images tables in a Magento installation. Removes references to non-existing images, removes duplicate images, sets correct default image and deletes orphaned images from the filesystem.
<?php
/*
* This script deletes duplicate images and imagerows from the database of which the images are not present in the filesystem.
* It also removes images that are exact copies of another image for the same product.
* And lastly, it looks for images that are on the filesystem but not in the database (orphaned images).
*
* This script can most likely be optimized but since it'll probably only be run a few times, I can't be bothered.
*
* Place scripts in a folder named 'scripts' (or similar) in the Magento root.
@tshabatyn
tshabatyn / blocklist.txt
Created August 4, 2020 13:33 — forked from hn-support/blocklist.txt
A curated list of user agents that use lot's of resources but don't cause more conversion or add any value to most of the webshops
360Spider
80legs\.com
ADmantX
Abonti
AcoonBot
Acunetix
AddThis\.com
AhrefsBot
AngloINFO
Antelope
import sys
import shelve
# Loading data fom dataname.db
def loadD():
db = shelve.open('dataname')
dbItems = []
for i in range(0, db['last_index'] + 1):
dbItems.append(db[str(i)])
return dbItems