本篇內(nèi)容主要講解“如何使用RDA巡檢MySQL數(shù)據(jù)庫(kù)”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強(qiáng)。下面就讓小編來(lái)帶大家學(xué)習(xí)“如何使用RDA巡檢MYSQL數(shù)據(jù)庫(kù)”吧!
創(chuàng)新互聯(lián)公司主要為客戶提供服務(wù)項(xiàng)目涵蓋了網(wǎng)頁(yè)視覺設(shè)計(jì)、VI標(biāo)志設(shè)計(jì)、成都全網(wǎng)營(yíng)銷、網(wǎng)站程序開發(fā)、HTML5響應(yīng)式重慶網(wǎng)站建設(shè)公司、手機(jī)網(wǎng)站制作設(shè)計(jì)、微商城、網(wǎng)站托管及網(wǎng)站維護(hù)公司、WEB系統(tǒng)開發(fā)、域名注冊(cè)、國(guó)內(nèi)外服務(wù)器租用、視頻、平面設(shè)計(jì)、SEO優(yōu)化排名。設(shè)計(jì)、前端、后端三個(gè)建站步驟的完善服務(wù)體系。一人跟蹤測(cè)試的建站服務(wù)標(biāo)準(zhǔn)。已經(jīng)為紙箱行業(yè)客戶提供了網(wǎng)站營(yíng)銷推廣服務(wù)。
實(shí)驗(yàn)環(huán)境：
Server version: 5.6.37
命令
RDA模塊配置
./rda.sh -S MYSQ
生成巡檢結(jié)果
./rda.sh -v MYSQ
實(shí)驗(yàn)過(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)
操作完成后生成如下檢查結(jié)果
下載解壓后可以進(jìn)行相關(guān)查看：
到此，相信大家對(duì)“如何使用RDA巡檢MYSQL數(shù)據(jù)庫(kù)”有了更深的了解，不妨來(lái)實(shí)際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！
重慶分公司
重慶分公司
