使用RDA巡检MYSQL数据库

jiawang

RDA(RemoteDiagnostic Agent)是oracle用来收集、分析数据库的工具，运行该工具不会改变系统的任何参数，RDA收集的相关数据非常全面，可以简化我们日常监控、分析数据库的工作。
一般Oracle 原厂的人巡检也是使用RDA工具。 不过一般国内的DBA 巡检时很少使用这个工具，一般都是通过AWR 或者自己整几个脚本，跑了在分析一下就ok了。

RDA 是一个客户端，解压缩之后就可以直接使用了。
同样RDA也可以对mysql数据库进行简单的检查，并生成检查报告。

参考文档：
Using Remote Diagnostic Agent (RDA) 4 with MySQL Server and MySQL Cluster (文档 ID 1437541.1)

实验环境：
Server version: 8.0.11

命令
RDA模块配置
./rda.sh -S  MYSQ
生成巡检结果
./rda.sh -v MYSQ

实验过程
[root@sztech opt]# cd rda
[root@sztech rda]# ll
total 256
drwxr-xr-x.  5 root root    42 Aug 24 10:42 admin
drwxr-xr-x. 16 root root   169 Aug 24 10:42 collect
drwxr-xr-x.  8 root root    74 Aug 24 10:42 Convert
drwxr-xr-x.  7 root root   256 Aug 24 10:43 da
drwxr-xr-x.  3 root root    20 Aug 24 10:42 dfw
-r--r--r--.  1 root root  4106 Aug 24 10:42 DISCLAIM.txt
drwxr-xr-x.  2 root root    63 Aug 24 10:42 engine
drwxr-xr-x.  9 root root    83 Aug 24 10:42 hcve
drwxr-xr-x.  3 root root    56 Aug 24 10:42 IRDA
-r-xr-xr-x.  1 root root 14790 Aug 24 10:42 irda.pl
drwxr-xr-x.  6 root root    53 Aug 24 10:42 mesg
drwxr-xr-x.  2 root root    21 Aug 24 10:42 modules
drwxr-xr-x.  3 root root    16 Aug 24 10:42 Pod
drwxr-xr-x. 19 root root  4096 Aug 24 10:42 RDA
-r-xr-xr-x.  1 root root  7273 Aug 24 10:42 rda.cmd
-r-xr-xr-x.  1 root root  7754 Aug 24 10:42 rda.com
-r-xr-xr-x.  1 root root  5636 Aug 24 10:42 rda_download.html
-r-xr-xr-x.  1 root root 43971 Aug 24 10:42 rda.pl
-r-xr-xr-x.  1 root root 12152 Aug 24 10:42 rda.sh
-r--r--r--.  1 root root  3346 Aug 24 10:42 README_irda.txt
-r--r--r--.  1 root root 17002 Aug 24 10:42 README_Unix.txt
-r--r--r--.  1 root root  5144 Aug 24 10:42 README_upgrade.txt
-r--r--r--.  1 root root 18199 Aug 24 10:42 README_VMS.txt
-r--r--r--.  1 root root 17023 Aug 24 10:42 README_Windows.txt
-r-xr-xr-x.  1 root root 25564 Aug 24 10:42 sdboot.pl
-r-xr-xr-x.  1 root root  6471 Aug 24 10:42 sdci.cmd
-r-xr-xr-x.  1 root root 26981 Aug 24 10:42 sdci.pl
-r-xr-xr-x.  1 root root  9487 Aug 24 10:42 sdci.sh
drwxr-xr-x.  2 root root    30 Aug 24 10:42 tools


执行RDA模块配置
[root@sztech rda]# ./rda.sh -S  MYSQ
Enter the network domain name for this server
> sztech

------------------------------------------------------------------------------
RDA.BEGIN: Initializes the Data Collection
------------------------------------------------------------------------------
Enter the Oracle home to be used for data analysis
> /usr/local/mysql

------------------------------------------------------------------------------
RDA.CONFIG: Collects Key Configuration Information
------------------------------------------------------------------------------
------------------------------------------------------------------------------
DB.MYSQ: Collects Oracle MySQL Server Information
------------------------------------------------------------------------------
Do you want RDA to collect Oracle MySQL Server information (Y/N)?
Press Return to accept the default (Y)
>

Enter the full path of the Oracle MySQL Server configuration file
Press Return to accept the default (/etc/my.cnf)
>

Enter the full path of the Oracle MySQL Server data directory
> root

Warning: The specified directory does not -yet- exist
Do you want to specify a new value (Y/N)? n  


Enter the user name for the Oracle MySQL Server connection
> root

------------------------------------------------------------------------------
RDA.OCM: Set up the Configuration Manager Interface
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.STATUS: Produces the Remote Data Collection Reports
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.LOAD: Produces the External Collection Reports
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.FILTER: Controls Report Content Filtering
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.END: Finalizes the Data Collection
------------------------------------------------------------------------------
[root@sztech rda]#

生成巡检结果
[root@sztech rda]# ./rda.sh -v  MYSQ
Collecting diagnostic data ...
------------------------------------------------------------------------------
RDA Data Collection Started 04-Nov-2022 12:03:10
------------------------------------------------------------------------------
Processing RDA.BEGIN module ...
Inside BEGIN module, testing the RDA engine code build
Inside BEGIN module, testing the report directory
Inside BEGIN module, testing the module targets
Inside BEGIN module, launching parallel executions
Processing RDA.CONFIG module ...
Inside CONFIG module, getting Oracle home inventory (can take time)
Processing DB.MYSQ module ...
Inside MYSQ module, gathering database information (can take time)
Enter password:
Inside MYSQ module, collecting the configuration files
Inside cat_report, looking for my.cnf in /etc
Inside MYSQ module, listing the files in /usr/local/mysql/data directory
Inside MYSQ module, collecting the log files
Processing RDA.LOAD module ...
Inside LOAD module, running CRS diagnostic collection tool
Inside LOAD module, gathering system comparison reports
Inside LOAD module, gathering EPM validation reports
Inside LOAD module, gathering HCVE reports
Inside LOAD module, gathering JRockit tool reports
Inside LOAD module, gathering jvm tool reports
Inside LOAD module, gathering Trace Merge reports
Inside LOAD module, gathering Network Advisor reports
Inside LOAD module, gathering Oracle Configuration Manager information
Inside LOAD module, gathering ORA600 reports
Inside LOAD module, gathering ORADDC reports
Inside LOAD module, gathering OSWatcher information
Inside LOAD module, gathering database performance reports
Inside LOAD module, gathering the most recent redo tool results
Inside LOAD module, gathering the most recent TLsecure report
Inside LOAD module, gathering Siebel crash reports
Inside LOAD module, gathering siga/sosreport/sysreport reports
Processing RDA.END module ...
Inside END module, gathering system information
Inside END module, getting CPU information (linux)
Inside END module, getting memory information (linux)
Inside END module, producing the file catalog
Inside END module, producing target overview
Inside END module, waiting for parallel execution completion
Inside END module, producing setting overview
------------------------------------------------------------------------------
RDA Data Collection Ended 04-Nov-2022 12:04:27
------------------------------------------------------------------------------
Generating the reports ...
        - collect/DB_MYSQ_db_info.txt ...
        - collect/DB_MYSQ_cfg_my_cnf.txt ...
        - collect/DB_MYSQ_datadir_overview.txt ...
        - collect/DB_MYSQ_log_files.txt ...
        - collect/RDA_END_system.txt ...
        - collect/RDA_END_files.txt ...
        - collect/RDA_END_target.txt ...
        - collect/RDA_END_report.txt ...
        - Report index ...
Packaging collection results ...
  You can review the reports by transferring the /opt/rda/output directory
  structure to a location where you have web-browser access. Then, point your
  browser at this file to display the reports:
    RDA__start.htm

  Based on your server configuration, some possible alternative approaches
  are:
  - If your client computer with a browser has access to a web-shared
    directory, copy the /opt/rda/output directory structure to the web-shared
    directory and visit this URL:
    http://machine:port/web_shared_directory/RDA__start.htm
  or
  - If your client computer with a browser has FTP access to the server
    computer with the /opt/rda/output directory, visit this URL:
    ftp://root@sztech.sztech//opt/rda/output

  If this file was generated to assist in resolving a Service Request, send
  /opt/rda/RDA_output_sztech.zip to Oracle Support by uploading the file via
  My Oracle Support. When sending with FTP, make sure you send it in BINARY
  format.

  Note: Do not submit any health, payment card or other sensitive production
  data that requires protections greater than those specified in the Oracle
  GCS Security Practices
  (http://www.oracle.com/us/support ... ractices-069170.pdf).
  Information on how to remove data from your submission is available at
  https://support.oracle.com/rs?type=doc&id=1227943.1

操作完成后生成如下检查结果

登录/注册后可看大图