# dba-gadgets

**Repository Path**: y9x/dba-gadgets

## Basic Information

- **Project Name**: dba-gadgets
- **Description**: 自己在DBA工作中编写与搜集的工具脚本整合整理，用法已在各脚本内注明。 Tools and scripts developed and collected by the DBA in their work, with usage instructions included in each script. mysql、oracle、mongo、redis、postgresql、starrocks...
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2026-04-10
- **Last Updated**: 2026-04-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 📚 dba-gadgets
- 自己在DBA工作中编写与搜集的通用工具脚本整合整理，用法已在各脚本内注明。
- Tools and scripts developed and collected by the DBA in their work, with usage instructions included in each script.
- mysql、oracle、mongo、redis、postgresql、starrocks...


> 以下目录树，使用脚本 `python .\03-files-processing\files_tree.py --markdown` 生成

dba-gadgets
- [01-backup-restore-archive](./01-backup-restore-archive) | 备份、恢复、归档
  - [mongo_backup_mongodump.sh](./01-backup-restore-archive/mongo_backup_mongodump.sh)
  - [mongo_restore_mongodump.sh](./01-backup-restore-archive/mongo_restore_mongodump.sh)
  - [mysql_backup_mysqldump.sh](./01-backup-restore-archive/mysql_backup_mysqldump.sh)
  - [mysql_restore_mysqldump.sh](./01-backup-restore-archive/mysql_restore_mysqldump.sh)
  - [mysql_restore_xtrabackup.py](./01-backup-restore-archive/mysql_restore_xtrabackup.py)
  - [oracle_rman_backup.sh](./01-backup-restore-archive/oracle_rman_backup.sh)
  - [sr_backup_snapshot.py](./01-backup-restore-archive/sr_backup_snapshot.py)
  - [sr_restore_snapshot.py](./01-backup-restore-archive/sr_restore_snapshot.py)
- [02-data-processing](./02-data-processing) | 数据处理
  - [mysql_concurrency_test.py](./02-data-processing/mysql_concurrency_test.py)
  - [mysql_csv_to_table.py](./02-data-processing/mysql_csv_to_table.py)
  - [open_metadata_lineage](./02-data-processing/open_metadata_lineage)
    - [execute_demo.py](./02-data-processing/open_metadata_lineage/execute_demo.py)
    - [get_etl_add_lineage.py](./02-data-processing/open_metadata_lineage/get_etl_add_lineage.py)
    - [open_metadata_db_info.py](./02-data-processing/open_metadata_lineage/open_metadata_db_info.py)
    - [open_metadata_lineage.py](./02-data-processing/open_metadata_lineage/open_metadata_lineage.py)
  - [oracle_clear_tabhwm](./02-data-processing/oracle_clear_tabhwm)
    - [oracle_f_get_part.sql](./02-data-processing/oracle_clear_tabhwm/oracle_f_get_part.sql)
    - [oracle_proc_clear_tabhwm.sql](./02-data-processing/oracle_clear_tabhwm/oracle_proc_clear_tabhwm.sql)
    - [oracle_tb_clear_hwm.sql](./02-data-processing/oracle_clear_tabhwm/oracle_tb_clear_hwm.sql)
  - [oracle_job_log](./02-data-processing/oracle_job_log)
    - [oracle_proc_job_log.sql](./02-data-processing/oracle_job_log/oracle_proc_job_log.sql)
    - [oracle_tb_job_log.sql](./02-data-processing/oracle_job_log/oracle_tb_job_log.sql)
  - [oracle_proc_Increment_seq.sql](./02-data-processing/oracle_proc_Increment_seq.sql)
  - [oracle_table_tool](./02-data-processing/oracle_table_tool)
    - [oracle_f_str_split.sql](./02-data-processing/oracle_table_tool/oracle_f_str_split.sql)
    - [oracle_pkg_tab_tool.sql](./02-data-processing/oracle_table_tool/oracle_pkg_tab_tool.sql)
    - [oracle_tb_tab_tool.sql](./02-data-processing/oracle_table_tool/oracle_tb_tab_tool.sql)
  - [oracle_tbs_autoext.sh](./02-data-processing/oracle_tbs_autoext.sh)
  - [redis_del_big_list.py](./02-data-processing/redis_del_big_list.py)
  - [redis_del_idle_key.py](./02-data-processing/redis_del_idle_key.py)
  - [sr_alter_table_rn.py](./02-data-processing/sr_alter_table_rn.py)
  - [sr_alter_view_rn.py](./02-data-processing/sr_alter_view_rn.py)
- [03-files-processing](./03-files-processing) | 文件处理
  - [delete_files.sh](./03-files-processing/delete_files.sh)
  - [files_backup.sh](./03-files-processing/files_backup.sh)
  - [files_rsync_migration.sh](./03-files-processing/files_rsync_migration.sh)
  - [files_tree.py](./03-files-processing/files_tree.py)
  - [generate_test_files.sh](./03-files-processing/generate_test_files.sh)
  - [hw_rds_download_audit_logs.py](./03-files-processing/hw_rds_download_audit_logs.py)
  - [sql_to_excel](./03-files-processing/sql_to_excel)
    - [sql.xlsx](./03-files-processing/sql_to_excel/sql.xlsx)
    - [sql_to_excel.py](./03-files-processing/sql_to_excel/sql_to_excel.py)
- [04-db-check](./04-db-check) | 数据库检查
  - [app_batch_management.sh](./04-db-check/app_batch_management.sh)
  - [disk_performance_test.sh](./04-db-check/disk_performance_test.sh)
  - [hardware_info.sh](./04-db-check/hardware_info.sh)
  - [mysql_bussine_test.py](./04-db-check/mysql_bussine_test.py)
  - [mysql_f_rollback_time_calc.sql](./04-db-check/mysql_f_rollback_time_calc.sql)
  - [mysql_pt_slave_repair.py](./04-db-check/mysql_pt_slave_repair.py)
  - [mysql_reverse_sql.py](./04-db-check/mysql_reverse_sql.py)
  - [mysql_state_dump.sh](./04-db-check/mysql_state_dump.sh)
  - [oracle_generating_focused_AWR_reports.sql](./04-db-check/oracle_generating_focused_AWR_reports.sql)
  - [zabbix](./04-db-check/zabbix)
    - [mysql_zabbix_monitor.sh](./04-db-check/zabbix/mysql_zabbix_monitor.sh)
    - [sr_zabbix_check.py](./04-db-check/zabbix/sr_zabbix_check.py)
- [05-db-install](./05-db-install) | 数据库安装
  - [Oracle一键安装命令生成工具v2.0.html](./05-db-install/Oracle一键安装命令生成工具v2.0.html)
  - [docker](./05-db-install/docker)
    - [mongodb](./05-db-install/docker/mongodb)
      - [docker-compose.yaml](./05-db-install/docker/mongodb/docker-compose.yaml)
    - [mssql](./05-db-install/docker/mssql)
      - [docker-compose.yaml](./05-db-install/docker/mssql/docker-compose.yaml)
    - [mysql](./05-db-install/docker/mysql)
      - [docker-compose.yaml](./05-db-install/docker/mysql/docker-compose.yaml)
      - [slave](./05-db-install/docker/mysql/slave)
        - [docker-compose.yaml](./05-db-install/docker/mysql/slave/docker-compose.yaml)
        - [setup_replication.sh](./05-db-install/docker/mysql/slave/setup_replication.sh)
    - [oracle](./05-db-install/docker/oracle)
      - [docker-compose.yaml](./05-db-install/docker/oracle/docker-compose.yaml)
    - [otter](./05-db-install/docker/otter)
      - [docker-compose.yaml](./05-db-install/docker/otter/docker-compose.yaml)
    - [postgresql](./05-db-install/docker/postgresql)
      - [docker-compose.yaml](./05-db-install/docker/postgresql/docker-compose.yaml)
    - [proxysql](./05-db-install/docker/proxysql)
      - [docker-compose.yaml](./05-db-install/docker/proxysql/docker-compose.yaml)
      - [proxysql.cnf](./05-db-install/docker/proxysql/proxysql.cnf)
    - [redis](./05-db-install/docker/redis)
      - [docker-compose.yaml](./05-db-install/docker/redis/docker-compose.yaml)
  - [mssql_offline_install.sh](./05-db-install/mssql_offline_install.sh)
  - [mysql_generic_install.sh](./05-db-install/mysql_generic_install.sh)
  - [oracle_shell_install.sh](./05-db-install/oracle_shell_install.sh)
  - [pg_install.sh](./05-db-install/pg_install.sh)
  - [pg_souece_install.sh](./05-db-install/pg_souece_install.sh)
  - [vastbase_g100_install_v17.sh](./05-db-install/vastbase_g100_install_v17.sh)
- [06-auxiliary-tools](./06-auxiliary-tools) | 辅助工具
  - [MobaXterm-Keygen.py](./06-auxiliary-tools/MobaXterm-Keygen.py)
  - [ssh_setup_keyless.sh](./06-auxiliary-tools/ssh_setup_keyless.sh)
  - [ssh_trust.sh](./06-auxiliary-tools/ssh_trust.sh)
- [07-sre-install](./07-sre-install) | 运维安装
  - [FTPServerAutoCreate.py](./07-sre-install/FTPServerAutoCreate.py)
  - [docker](./07-sre-install/docker)
    - [SQLBot](./07-sre-install/docker/SQLBot)
      - [docker-compose.yaml](./07-sre-install/docker/SQLBot/docker-compose.yaml)
    - [frpc](./07-sre-install/docker/frpc)
      - [data](./07-sre-install/docker/frpc/data)
        - [frpc.toml](./07-sre-install/docker/frpc/data/frpc.toml)
        - [frpc_full.toml](./07-sre-install/docker/frpc/data/frpc_full.toml)
        - [ssl](./07-sre-install/docker/frpc/data/ssl)
      - [data.yml](./07-sre-install/docker/frpc/data.yml)
      - [docker-compose.yml](./07-sre-install/docker/frpc/docker-compose.yml)
      - [scripts](./07-sre-install/docker/frpc/scripts)
        - [init.sh](./07-sre-install/docker/frpc/scripts/init.sh)
    - [frps](./07-sre-install/docker/frps)
      - [data](./07-sre-install/docker/frps/data)
        - [frps.toml](./07-sre-install/docker/frps/data/frps.toml)
        - [frps_full.toml](./07-sre-install/docker/frps/data/frps_full.toml)
        - [ssl](./07-sre-install/docker/frps/data/ssl)
      - [data.yml](./07-sre-install/docker/frps/data.yml)
      - [docker-compose.yml](./07-sre-install/docker/frps/docker-compose.yml)
      - [scripts](./07-sre-install/docker/frps/scripts)
        - [init.sh](./07-sre-install/docker/frps/scripts/init.sh)
    - [minio](./07-sre-install/docker/minio)
      - [docker-compose.yaml](./07-sre-install/docker/minio/docker-compose.yaml)
    - [n9e](./07-sre-install/docker/n9e)
      - [docker-compose.yaml](./07-sre-install/docker/n9e/docker-compose.yaml)
    - [node_exporter](./07-sre-install/docker/node_exporter)
      - [docker-compose.yml](./07-sre-install/docker/node_exporter/docker-compose.yml)
      - [prometheus-config-example.yml](./07-sre-install/docker/node_exporter/prometheus-config-example.yml)
    - [prometheus-grafana](./07-sre-install/docker/prometheus-grafana)
      - [docker-compose.yaml](./07-sre-install/docker/prometheus-grafana/docker-compose.yaml)
      - [grafana](./07-sre-install/docker/prometheus-grafana/grafana)
        - [dashboards](./07-sre-install/docker/prometheus-grafana/grafana/dashboards)
        - [provisioning](./07-sre-install/docker/prometheus-grafana/grafana/provisioning)
          - [dashboards](./07-sre-install/docker/prometheus-grafana/grafana/provisioning/dashboards)
            - [default.yml](./07-sre-install/docker/prometheus-grafana/grafana/provisioning/dashboards/default.yml)
          - [datasources](./07-sre-install/docker/prometheus-grafana/grafana/provisioning/datasources)
            - [prometheus.yml](./07-sre-install/docker/prometheus-grafana/grafana/provisioning/datasources/prometheus.yml)
      - [prometheus](./07-sre-install/docker/prometheus-grafana/prometheus)
        - [prometheus.yml](./07-sre-install/docker/prometheus-grafana/prometheus/prometheus.yml)
        - [prometheus.yml.example](./07-sre-install/docker/prometheus-grafana/prometheus/prometheus.yml.example)
        - [rules](./07-sre-install/docker/prometheus-grafana/prometheus/rules)
          - [example.yml](./07-sre-install/docker/prometheus-grafana/prometheus/rules/example.yml)
  - [openssh-update.sh](./07-sre-install/openssh-update.sh)
  - [zabbix](./07-sre-install/zabbix)
    - [install_zabbix_server5.0.sh](./07-sre-install/zabbix/install_zabbix_server5.0.sh)
    - [install_zabbix_server6.0.sh](./07-sre-install/zabbix/install_zabbix_server6.0.sh)
    - [install_zabbix_server7.sh](./07-sre-install/zabbix/install_zabbix_server7.sh)