Skip to content

Instantly share code, notes, and snippets.

View su3010's full-sized avatar

su3010 su3010

0 followers · 41 following
View GitHub Profile
@su3010
su3010 / es-dump-index.py
Created September 10, 2022 00:01 — forked from spikeekips/es-dump-index.py
The simple script to dump the data from ElasticSearch for inserting by bulk API.
# -*- coding: utf-8 -*-
"""
################################################################################
Dump ElasticSearch index for inserting BULK
################################################################################
requires `rawes`.
for more details, run `-h` to show help message.
@su3010
su3010 / install-mongodb-2.6.12-from-tarball.sh
Created May 17, 2021 21:45 — forked from abepark01/install-mongodb-2.6.12-from-tarball.sh
install mongodb-2.6.12 from the tarball
#!/usr/bin/env bash
# run this script from your home folder
# sudo bash
curl -O http://downloads.mongodb.org/linux/mongodb-linux-x86_64-2.6.12.tgz
tar -zxvf mongodb-linux-x86_64-2.6.12.tgz
cp mongodb-linux-x86_64-2.6.12/bin/* /usr/local/bin
groupadd mongodb
useradd --system --no-create-home -g mongodb mongodb
@su3010
su3010 / sql_safe_updates
Created July 7, 2020 17:51 — forked from stormwild/sql_safe_updates
How to disable MySQL Safe Mode
UPDATE table_name SET bDeleted=0 WHERE name='xyz';
“You are using safe update mode and you tried to update a table without a WHERE clause that uses a KEY column.”
SET SQL_SAFE_UPDATES=0;
UPDATE table_name SET bDeleted=0 WHERE name='xyz';
SET SQL_SAFE_UPDATES=1;
#http://www.xpertdeveloper.com/2011/10/mysql-safe-update/
@su3010
su3010 / MySQL Replication Check
Created March 28, 2020 18:37 — forked from ssimpson89/MySQL Replication Check
Just a simple Mysql Replication Health Check script I wrote. You can put this in a cron.
#!/bin/bash
### VARIABLES ### \
EMAIL=""
SERVER=$(hostname)
MYSQL_CHECK=$(mysql -e "SHOW VARIABLES LIKE '%version%';" || echo 1)
LAST_ERRNO=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G" | grep "Last_Errno" | awk '{ print $2 }')
SECONDS_BEHIND_MASTER=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G"| grep "Seconds_Behind_Master" | awk '{ print $2 }')
IO_IS_RUNNING=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G" | grep "Slave_IO_Running" | awk '{ print $2 }')
SQL_IS_RUNNING=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G" | grep "Slave_SQL_Running" | awk '{ print $2 }')