2010数据库技术大会王丹敬EM Plugin For MySQL 监控.ppt

实战 EMPluginForMySQL监控搜狐DBA王丹敬 主题大纲 为什么选择开发EMPlugin EMPlugin能做些什么 EMPlugin的开发流程及代码示例EMPlugin的优点 缺点 为什么选择开发EMPlugin EMPlugin能做些什么 基于EM框架的功能 InformationPublisher sReports 基于EM框架的功能 ConfigurationManagement 基于EM框架的功能 ConfigurationManagement 基于EM框架的功能 Metric的使用 History 基于EM框架的功能 Metric的使用 Compare 基于EM框架的功能 Metric的使用 基于EM框架的功能 邮件报警 EMPlugin能做些什么 MetricPolicyReport ChartLink EMPlugin的开发流程 定义TargetType Metric Properties 根据Oracle提供的DTD编写XML文件 OracleEnterpriseManagerExtensibilityGuide AGENT HOME sysman admin dtds TargetMetadata dtd AGENT HOME sysman admin dtds TargetCollection dtd AGENT HOME sysman admin metadata xml AGENT HOME sysman admin default collection xmlmetadata xml定义收集哪些metric 定义metric的收集方法定义metric是否在UI显示 collection xml定义metric的收集频率报警阀值 MySQLDB metadata xml架构 ResponseStatusCurrentStatusoftheServerResponsetime ms emdRootscriptsDirperlBinhostportunamepassmysqlhomemydelimiter perlBin perl scriptsDir emx TYPE response pl mysqlhome mydelimiter host port uname pass mydelimiter em result em error 120 metadata xml架构 定义Metric示例 ShowStatus metadata xml架构 定义InstanceProperties示例 collection xml架构 收集Metric的方法 FetchletsOSCommand 推荐使用PerlSQLSNMPURLTimingDynamicMonitoringService DMS HTTPDataURLXMLWBEMJDBCOJMX SOAPReceiveletsSNMPReceiveletsAdvancedQueueReceiveletsHTTPReceivelets Chart展示 Report展示 Report展示 ResponseTiming375150southtrueResponseTime ms reportTabMySQLHealthStatusReports 定义Chart BEGINDECLARE 作为create report definition的p late binding target types参数值l target typesMGMT IP TARGET TYPES 定义报表的guidl report guidRAW 16 定义元素的guidl element guidRAW 16 create report definition和add element to report def的p parameters参数值l param valuesMGMT IP PARAM VALUE LIST 序列变量l curr order应该连续增长 从1到报表中的元素总数 BEGIN INITIALIZEREPORTORDERFORPLUGININTERFACEl report order 0 目标类型l target type targettype specifythetargettypeassociatedwiththisreport 报表名称l report title nlsid MySQLInnodbDeadlockReports 得到报表所有者 定义报表 createareportdefinitionforthereportl report guid mgmt ip create report definition 加入图l param values MGMT IP PARAM VALUE LIST commit END END 定义Report 打包Plugin文件 MPA ManagementPlug inArchive 检查metadata xml和collection xml文件的正确性emclicheck mp metadata file export home oracle mysql plugin satine meta xml collection file export home oracle mysql plugin satine coll xml err level info打包文件emcliadd mp to mpa mpa export home oracle mysql plugin mpa 1 5 20090601 MYSQL TEST INTEGRATION jar mp version 1 5 20090601 ttd export home oracle mysql plugin satine meta xml dc export home oracle mysql plugin satine coll xml file HOMEPAGE DEFINITION export home oracle mysql plugin homepage charts xml file REPORT DEFINITION export home oracle mysql plugin reports SlowLog sql file REPORT DEFINITION export home oracle mysql plugin reports HealthStatusReports sql file MONITORING SCRIPT export home oracle mysql plugin scripts response pl file MONITORING SCRIPT export home oracle mysql plugin scripts MysqlIsAlive pl file ECM DEPLOY export home oracle mysql plugin ecm mysql ecm deploy sql file ECM UNDEPLOY export home oracle mysql plugin ecm mysql ecm undeploy sql func desc Justfortesting 导入MPA SetupManagementPlug insImportListArchiveOK 发布Plugin到Agents DeployAddAgentsNextFinish 添加Mysql对象到EM 找到用于监控的AgentAdd选择对象类型Go输入正确信息OK Plugin性能测试 使用工具 EMManagementPlug inDevelopmentKit EMPDK lintandperformancetools下载地址 Plugin性能测试 报告 报告规格 MetadataStatisticsTargetRuntimeStatisticsAgentProcessStatisticsPerformanceChartsSystemCPUUtilizationSystemPhysicalMemoryUtilizationMemoryU