Skip to content

Instantly share code, notes, and snippets.

View tshabatyn's full-sized avatar

Taras Shabatyn tshabatyn

10 followers · 121 following
View GitHub Profile
@tshabatyn
tshabatyn / ublock.sh
Created November 5, 2025 06:13
returning back ublock to chrome on macos
#!/usr/bin/env bash
cd '/Applications/Google Chrome.app/Contents/MacOS' || exit 1
if [ -f 'Google-Chrome-bin' ]; then
echo 'It is already fixed.'
exit 1
fi
mv 'Google Chrome' 'Google-Chrome-bin'
cat > 'Google Chrome' << 'EOF'
@tshabatyn
tshabatyn / README.md
Created July 31, 2024 16:59 — forked from molotovbliss/README.md
Speed up warden for faster importing of large sql dumps.

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
@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.