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