Skip to content

Instantly share code, notes, and snippets.

View kevinbin's full-sized avatar

hongbin kevinbin

14 followers · 1 following
View GitHub Profile
@kevinbin
kevinbin / clusterset.py
Created April 30, 2025 04:57
deploy and test innodb cluster set
#!/usr/bin/env mysqlsh --file
import os
import sys
import time
import json
import argparse
import datetime
import socket
import signal
from pathlib import Path
@kevinbin
kevinbin / mgr_test.py
Created April 29, 2025 04:32
mysql group replication failover test
#!/usr/bin/env python3
# 无论单主或多主配置双向复制必须启用skip_replica_start，否则可能导致节点启动后加入集群前先同步到对方集群数据导致和本组gtid不一致无法加入集群
# 单主不建议做双向复制，最好用mysql-shell部署clusterset架构，利用mysqlrouter 实现两集群双活
# 多主模式可以开双向复制。
from typing import List, Dict, Literal
import subprocess
import time
from dataclasses import dataclass
@kevinbin
kevinbin / analyze_mysql_cve.sh
Last active April 29, 2025 04:32
mysql cve search using duckdb
# git clone https://github.com/CVEProject/cvelistV5.git
#!/bin/bash
# usage: ./analyze_mysql_cve.sh 8.0.32
TARGET_VERSION="$1"
duckdb <<EOF
CREATE TABLE IF NOT EXISTS mysqlcve AS
@kevinbin
kevinbin / scsi.sh
Created June 1, 2024 12:20
scsi test
#!/bin/bash
persist_tool='mpathpersist'
register() {
local key=$1
local disk=$2
echo "register:$disk "
$persist_tool -o -I -S $key -d $disk
}
unregister() {
@kevinbin
kevinbin / ibd2sql.py
Last active September 4, 2022 05:11
Parsing MySQL 8.0 ibd2sdi json output
#!/usr/bin/env python3
import json
import sys
# not support list partition type
# only support default Btree index, no other index types tested
# only gb* latin1 utf8mb3 utf8mb4
char_collate = {
248:["gb18030","gb18030_chinese_ci"],249:["gb18030","gb18030_bin"],250:["gb18030","gb18030_unicode_520_ci"],24:["gb2312","gb2312_chinese_ci"],86:["gb2312","gb2312_bin"],28:["gbk","gbk_chinese_ci"],87:["gbk","gbk_bin"],
@kevinbin
kevinbin / PostgreSQL Dashboard.json
Last active November 9, 2021 06:22
PostgreSQL Dashboard View
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
@kevinbin
kevinbin / gist:e6ff4cb43024be43b2326cfd784202d8
Created June 20, 2020 03:09
centos 7 gcc4.8 upgrade 5.0
cat <<EOF > /etc/yum.repos.d/fedora.repo
[warning:fedora]
name=fedora
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=fedora-23&arch=$basearch
enabled=1
EOF
yum -y update gcc gcc-c++
@kevinbin
kevinbin / gist:718ecdfa9434c7ac544f4685c7d53a6c
Created October 23, 2018 15:57
alirds-to-jdrds.json
{
"Name":"tpcc1-ali-jd",
"Failover":false,
"Orders":[],
"Type":"synchronous",
"Tasks":[
{
"Type":"Src",
"NodeId":"90f3cd4d-7997-7b1b-cd99-e2c4d05c69e1",
"Config":{
@kevinbin
kevinbin / ndb_mgmd.sh
Created January 20, 2014 03:25
MySQL Cluster ndb_mgmd process init start script
#!/bin/bash
# chkconfig: 345 99 30
# description: ndb_mgmd start/stop script
### BEGIN INIT INFO
# Provides: ndb_mgmd start/stop
# Required-Start: $local_fs $network $remote_fs
# Required-Stop: $local_fs $network $remote_fs
# Default-Start: 3 4 5
@kevinbin
kevinbin / ndbmtd.sh
Created January 20, 2014 03:25
MySQL Cluster ndbmtd process init start script
#!/bin/bash
# chkconfig: 345 60 40
# description: datanode start/stop script
### BEGIN INIT INFO
# Provides: datanode
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Default-Start: 3 4 5