tshabatyn

<?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

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

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

ll /var/lib/mysql/grastate.dat

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

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

tshabatyn

# 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

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

tshabatyn

# 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

#!/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

# 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

# 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

Speed up warden for faster importing of large sql dumps.

1. Add the innodb options to the warden/environments/magento2.base.yml docker-compose YML file.
2. Restart warden environment warden env down && warden sync stop && warden env up -d && warden sync start
3. Import the .sql file with warden db import.
4. Remove options & restart warden enviornment once import completed.

Why these settings

• innodb_buffer_pool_size : Will cache frequently read data