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

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
  • sr_backup_snapshot.py
  • sr_restore_snapshot.py
• 02-data-processing | 数据处理
  • 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
  • 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_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
  • hardware_info.sh
  • mysql_f_rollback_time_calc.sql
  • mysql_pt_slave_repair.py
  • mysql_reverse_sql.py
  • sr_zabbix_check.py
• 05-db-install | 数据库安装
  • docker
    • mongodb
      • docker-compose.yaml
    • mysql
      • docker-compose.yaml
      • slave
        • docker-compose.yaml
        • setup_replication.sh
  • mssql_offline_install.sh
  • mysql_generic_install.sh
  • oracle_shell_install.sh
  • pg_souece_install.sh