如何使用RDA巡检MYSQL数据库

2024-04-02 19:55

短信预约 -IT技能 免费直播动态提醒

本篇内容主要讲解“如何使用RDA巡检MYSQL数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用RDA巡检MYSQL数据库”吧!

实验环境：
Server version: 5.6.37

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

实验过程
[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)

操作完成后生成如下检查结果
如何使用RDA巡检MYSQL数据库
下载解压后可以进行相关查看：