# dba-gadgets **Repository Path**: fixpng/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**: 1 - **Forks**: 0 - **Created**: 2025-04-13 - **Last Updated**: 2026-01-04 ## 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) - [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) - [oracle_generating_focused_AWR_reports.sql](./04-db-check/oracle_generating_focused_AWR_reports.sql) - [sr_zabbix_check.py](./04-db-check/sr_zabbix_check.py) - [05-db-install](./05-db-install) | 数据库安装 - [docker](./05-db-install/docker) - [mongodb](./05-db-install/docker/mongodb) - [docker-compose.yaml](./05-db-install/docker/mongodb/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) - [otter](./05-db-install/docker/otter) - [docker-compose.yaml](./05-db-install/docker/otter/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) - [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_souece_install.sh](./05-db-install/pg_souece_install.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) - [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)