如何使用RDA巡檢MYSQL數據庫

本篇內容主要講解“如何使用RDA巡檢數據庫”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強。下面就讓小編來(lái)帶大家學(xué)習“如何使用RDA巡檢MYSQL數據庫”吧!

實(shí)驗環(huán)境：
Server version: 5.6.37

命令
RDA模塊配置
./rda.sh -S  MYSQ
生成巡檢結果
./rda.sh -v MYSQ

實(shí)驗過(guò)程
[mysql@jing1 rda]$ ./rda.sh -S  MYSQ
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.CB18030"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Enter the network domain name for this server
> jing1


------------------------------------------------------------------------------
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)
> /data/mysqldata/3306/my.cnf


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


------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
[mysql@jing1 rda]$ 
[mysql@jing1 rda]$ 
[mysql@jing1 rda]$ ./rda.sh -v MYSQ
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.CB18030"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Collecting diagnostic data ...
------------------------------------------------------------------------------
RDA Data Collection Started 04-Dec-2017 10:26:01
------------------------------------------------------------------------------
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, listing Oracle homes
 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 /data/mysqldata/3306
 Inside MYSQ module, listing the files in /data/mysqldata/3306/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-Dec-2017 10:29:57
------------------------------------------------------------------------------
Generating the reports ...
        - collect/DB_MYSQ_datadir_overview.txt ...
        - collect/RDA_END_report.txt ...
        - collect/DB_MYSQ_db_info.txt ...
        - collect/RDA_END_system.txt ...
        - collect/RDA_END_target.txt ...
        - collect/RDA_END_files.txt ...
        - collect/DB_MYSQ_cfg_my_cnf.txt ...
        - collect/DB_MYSQ_log_files.txt ...
        - Report index ...
Packaging collection results ...
  You can review the reports by transferring the
  /data/mysqldata/scripts/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 /data/mysqldata/scripts/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 /data/mysqldata/scripts/rda/output directory, visit this
    URL:
    ftp://root@jing1.jing1//data/mysqldata/scripts/rda/output


  If this file was generated to assist in resolving a Service Request, send
  /data/mysqldata/scripts/rda/RDA_output_jing1.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/library/customer-support-security-practices-069170.pdf).
  Information on how to remove data from your submission is available at
  https://support.oracle.com/rs?type=doc&id=1227943.1


RDA-00033: Warning - 2 command(s) not executed in RDA.CONFIG, RDA.END module(s)

操作完成后生成如下檢查結果

下載解壓后可以進(jìn)行相關(guān)查看：