Ignite安装配置——中篇

Linux
Ignite配置——上篇大体介绍了一下Ignite工具的功能、特性等,以及如何在Linux
上安装配置。从上篇可见Ignite安装非常的简单方便。下面介绍一下Ignite Repository Wizard(SQL Server或
ORACLE)配置以及如何注册需要监控的数据库。

在上篇中介绍了如何启动Ignite服务,其实只需要进入/home/ignite8/ignite_8_3_407目录下。就可以看到startup.sh 和shutdwon.sh 两个shell脚本。用来启动和关闭Ignite服务。

不过如果要跟全面的了解如何使用Ignite,建议大家先看看/home/ignite/ignite_8_3_407/readme.txt , 里面介绍了启动Ignite服务,升级Ignite指导、迁移Ignite服务器等等,如下所示:

IGNITE - UNIX/LINUX README
===========================================================================
CONTENTS
---------------------------------------------------------------------------
- Startup Instructions
- Upgrade Instructions
- How to Move the Ignite Server
- Troubleshooting
- Release Notes
- Contacting Confio
STARTUP INSTRUCTIONS
---------------------------------------------------------------------------
Ignite Server is a web server. Make sure you install Ignite on a server that:
    - has network connectivity to the Repository and all of the monitored databases, and
    - is available at all times (e.g. a laptop might not be a good choice), and
    - is not running applications where performance is critical (e.g. do not install Ignite on monitored database machines)
1) Start Ignite Server
---------------------------------------------------------------------------
Change to the Ignite Home directory (containing this readme.txt), and then run:
./startup.sh
Ignite must remain running at all times to collect monitoring data. If you plan to log
out of the account from which you start Ignite, run the following instead:
nohup ./startup.sh
This will prevent the Ignite process from exiting when you log out.
     Note: You may want to setup this file to run whenever the server is
     rebooted (using the rc files) or run this command every few minutes
     via a cron job. The script starts the web server if it is not already
     running.
     -----------------------------------------------------------------
     -- Example Cron Entry that starts Ignite, if not already started,
     -- every minute.
     -----------------------------------------------------------------
     * * * * * /home/confio/ignite_8_2_14/startup.sh >/home/confio/ignite_8_2_14/startup.log 2>&1
     If the startup.sh script fails, manually create a file called
     java_loc.txt and place it in the <Ignite Home>/iwc/tomcat/ignite_config
     directory. The file should contain one line with the full path to a
     java executable.
     -----------------------------------------------------------------
     -- Example contents of java_loc.txt
     -- The file should only have ONE line.
     -- No comments are allowed in the file.
     -----------------------------------------------------------------
     /home/bea9/jrockit90_150_03/jre/bin/java
Go to step 2. For new installs, once you have opened a browser to Ignite,
a wizard will walk you through creating a repository and monitoring
database instances.
2) Use Ignite in a Browser
---------------------------------------------------------------------------
After Ignite has been started on the server (step 1 above), bring up this link
in your browser:
http://<Server Machine Name>:8123
 or
http://<Server Machine IP>:8123
     If the link does not work, see the Troubleshooting section below.
Congratulations! You have completed the Ignite installation.
UPGRADE INSTRUCTIONS (for Existing Ignite Installations)
---------------------------------------------------------------------------
Prerequisite: System has an existing Ignite installation
1. On the server that holds the existing Ignite installation, shut down
   Ignite (run shutdown.sh). If a cron job was setup, make sure it is
   commented out during the upgrade.
2. Locate the new installation directory that was created when you ran the
   installation.
   /home/confio/ignite_8_2_12 <= old Ignite home
   /home/confio/ignite_8_2_14 <= new Ignite home
   If you are upgrading from an Ignite Trial to a production Ignite
   version, the process is the same but the directory names will look a
   little different, for example:
   /home/confio/igniteTF_8_2_12 <= old Ignite home (for Trial)
   /home/confio/ignite_8_2_14 <= new Ignite home (for Production)
3. Copy certain folders from old directory (Do NOT copy any hotfix files)
   cp -fr <OLD_home>/iwc/tomcat/ignite_config/* <NEW_home>/iwc/tomcat/ignite_config/
   cp -fr <OLD_home>/iwc/tomcat/logs/* <NEW_home>/iwc/tomcat/logs/
4. If you are upgrading from 8.2.x or higher, and you are using SSL, LDAPS or have changed the default Ignite ports
    cp -fr <OLD_home>/iwc/tomcat/conf/server.xml <NEW_home>/iwc/tomcat/conf/
    cp -fr <OLD_home>/iwc/tomcat/conf/.keystore <NEW_home>/iwc/tomcat/conf/
    If you are using LDAPS but your web server is not configured to use SSL, it is not necessary to copy the server.xml file.
   If you are upgrading from 8.1.x or below (to 8.2 or higher), and you are using SSL or have changed the default Ignite ports
    cp -fr <OLD_home>/iwc/tomcat/conf/.keystore <NEW_home>/iwc/tomcat/conf/
    The format of server.xml has changed significantly, so you'll need to copy over the appropriate values.
    Open server.xml in both OLD and NEW directories, and copy over the port values and, if you want to use SSL,
    uncomment the SSL section (see detailed instructions in <NEW_home>/iwc/ssl_setup.txt.
5. If you previously disabled a cron job, update the path in those scripts to
   the new directory name and re-enable the job.
6. The upgrade is complete. The next step is to start Ignite (see the
   section on Startup Instructions).
===========================================================================
REFERENCE INFORMATION
===========================================================================
How to Move the Ignite Server
---------------------------------------------------------------------------
1) Install the software on the new server.
2) Shutdown Ignite on the old server (run ./shutdown.sh).
3) Copy the directory "<Ignite Home>/iwc/tomcat/ignite_config" from the
    old server overwriting the same subdirectory on the new server.
4) Delete the "cat.txt" and "java_loc.txt" files from the directory
    "<Ignite Home>/iwc/tomcat/ignite_config" on the new server.
5) Startup Ignite on the new server again.
Troubleshooting
---------------------------------------------------------------------------
Ignite doesn't seem to start:
   Check the logs located in <Ignite Home>/tomcat/logs
The error logs don't show errors but I cannot access Ignite from a browser:
   Make sure you do not have a firewall that may prevent Ignite from listening
   on the ports that are specified in <Ignite Home>/tomcat/conf/server.xml.
   Also, make sure the client machine can ping the server running Ignite.
The error logs indicate default ports are already in use:
     You can change the default ports of 8123 and 8127 by editing
     <Ignite Home>/tomcat/conf/server.xml
     and updating the line <Connector port="8123"/>
     and updating the line <Server port="8127" shutdown="SHUTDOWN">
     NOTE: You cannot use the same port for both settings.
            We do not recommend changing this ports unless there is a port
            conflict.
Release Notes
---------------------------------------------------------------------------
Version Information:
  To check the version of your install, look in the
  <Ignite Home>/iwc/tomcat/webapps/iwc/meta-inf/manifest.mf
  after you have started Ignite at least once.
Ignite Server Port:
  You can change the default ports that the Ignite Server uses (8123 and 8127)
  by editing the file <Ignite Home>/tomcat/conf/server.xml and updating the
  following lines:
      <Server port="8127" shutdown="SHUTDOWN">
      <Connector port="8123"/>
     NOTE: You cannot use the same port for both settings.
            We do not recommend changing this ports unless there is a port
            conflict.
SSL:
  Instructions to setup SSL are contained in the ./iwc/ssl_setup.txt file.
IE 6:
The search dialog listbox for the Reports will always show on top when the
View SQL Properties dialog is displayed. To correctly view the SQL Properties,
the dialog can be moved away from the search dialog.
Viewing server logs from IE 6 will cause the error
"Can't find the <very long temp dir>/<log_file_name>.log file". To view the log
file, save it to disk, then open the log file in a text file.
IE Browser:
When you are using tabs in IE the cookies used for the user's session are
the same. If you log out of one of the tabs, the other tab will be logged
out as well. Using two different IE browsers will have separate session
cookies, thus allowing independent functionality.
Firefox Browser:
When you are using two Firefox browsers or tabs, the cookies used for the
user's session are the same. If you log out of one the others will be
loggedout as well.
JRE/JDK Version:
It is highly recommended to use JRE/JDK version 1.5 or higher. Old versions of
the JRE/JDK (1.4.2.17 and below) could cause the following error:
Unexpected Signal : 11 occurred at PC=0xFEDBBCFC
Function=[Unknown. Nearest: JVM_NativePath+0x8AE0]
Library=/usr/j2se/jre/lib/sparc/server/libjvm.so
Contacting Confio
---------------------------------------------------------------------------
The best method of contacting us for any product related question is via
email:
  support@confio.com
Other methods of contact:
  Phone: +1 303-938-8282
  Toll free: 1-866-CONFIO1 (1-866-266-3461)
Current Confio customers requiring technical support assistance should request
support via support@confio.com or by calling one of the above phone numbers
and selecting Option 2.

创建Ignite Repository

启动Ignite服务后,在IE浏览器输入http://<Machine Name>:8123 or http://<Machine IP>:8123后(端口可以在配置文件修改),就会看到如下界面:

点击“Create New Ignite Repository" 后,会进入下面界面,你可以选SQL SERVER 数据库或Oracle 数据库作为Igntie的Repository,用来保存Ignite抓取的数据信息。 请留意”Multi-Byte“选项

输入数据库服务器的IP地址。以及数据库的端口号。如果没有修改则端口号为默认的1433,另外需要SYSTADMIN login权限

你可以用Windows Authentication 或SQL Authentication方式

接下来会在数据库创建一个账号(最好使用SQL Server Authentication)用来登录Ignite系统。如果数据库已经有了该账号,可以选择”No"选项

接下来,你可以选择创建一个新的数据库或从数据库实例中挑选一个已经存在的数据库用来保存监控数据。

接下来输入你的名字或邮箱,用来接收Ignite的告警邮件或报表。

    使用Oracle数据库作为Ignite
的Repository的配置过程大同小异,在此不作过多介绍。唯一比较遗憾的是,如果使用SQL Server作为Repository
数据库,只能选择一个数据库作为Repository,而不能选择多个,这样就有一个弊端。随着数据库数据量增长以及监控的数据库

越来越多。非常难以管理。而使用Oracle作为Repository的话,可以为被监控的数据库选择某一个表空间用来保存数据,这样就非常方便管理。

监控SQL SERVER数据库

接下来在Home界面选择“Register DB Instance for Monitoring",监控你像监控的数据库

例如我要监控的数据库类型为Microsoft SQL Server,如下所示,选择”Microsoft SQL Server“选项

输入被监控数据库的Ip地址或计算机名称,以及一个SYSADMIN权限的登录名

创建一个用来采集数据库的账号

监控ORACLE数据库

你可以选择“Direct Connect" 、”TNS Connect
Description“、”LDAP or TNS Name"连接方式链接到Oracle数据库,下面我们选择“TNS Connect
Description“,然后输入一个DBA Username登录系统用来创建后面相关账号

 

后面跟监控SQL Server 数据库的操作步骤一样了,在此略过。

下面我们看看Ignite使用Oracle 数据库作为Repositor时,注册监控数据库的向导步骤。

前面步骤大体类似,唯一不同的是在下面,可以为被监控的数据库选择Repository Tablespace,便于管理。

时间: 2025-01-20 09:02:04

Ignite安装配置——中篇的相关文章

Ignite安装配置——上篇

Ignite介绍       Ignite 是SolarWinds公司开发的一款数据库性能监控.性能分析并提供优化解决方案的性能检测分析工具,Ignite配置简单.方便:它会收集实时会话数 据.服务器资源使用情况,以及数据库服务器性能数据.提供实时监控和告警.它不仅可以从多个维度-如等待类型.程序. 执行计划分析历史趋势的响应时间.而且有着非常优秀的图形化界面,用户体验非常棒.当然这款工具并非是免费的,但是提供试用版本.大家可以去http://www.ignitefree.com/了解一下Ign

安装配置bugzilla笔记

因为自己在安装配置的时候走了些弯路,所以一方面自己提个醒,另一方面可以让有这方面需要的朋友做个参考 bugzilla是一个可以发布bug以及跟踪报告bug进展情况的开源软件,有关的官方文档可以查看:http://www.bugzilla.org/docs/ 本人是在RH9上安装配置成功bugzilla-2.18rc3的,事先也成功安装配置过2.16.7,后来发现在2.18中加入了图表的功能,觉得蛮有意思的,所以升级了一下.在安装前先确定自己机器上一些软件版本的情况:perl(5.6 or abo

Winodws下IIS/Apache+PHP+MySQL的安装配置

apache|iis|mysql 我写过的教程不多,而且大部分都是来源于别人的教程,不过,这里所介绍的,都是融入我所总结的经验.--引言 PHP的执行效率是有目共睹的,这也是我喜欢它的原因之一,和它称为绝妙搭档的Mysql以及Apache想融合,不能不惊叹其效率了.PHP更新也很快,这里列举了目前最新版本PHP4.3.2RC4(几乎没有BUG了,估计写完这篇不久后正式版就出了),和最新版本的Mysql4.0.13的安装过程. PHP的安装文件可以直接到 http://www.php.net/ 下

Oozie-3.3.2安装配置运行实践

Oozie是一个开源的工作流调度系统,它能够管理逻辑复杂的多个Hadoop作业,按照指定的顺序将其协同运行起来.例如,我们可能有这样一个需求,某个业务系统每天产生20G原始数据,我们每天都要对其进行处理,处理步骤如下所示: 通过Hadoop先将原始数据同步到HDFS上: 借助MapReduce计算框架对原始数据进行转换,生成的数据以分区表的形式存储到多张Hive表中: 需要对Hive中多个表的数据进行JOIN处理,得到一个明细数据Hive大表: 将明细数据进行复杂的统计分析,得到排序后的报表信息

Hue安装配置实践

Hue是一个开源的Apache Hadoop UI系统,最早是由Cloudera Desktop演化而来,由Cloudera贡献给开源社区,它是基于Python Web框架Django实现的.通过使用Hue我们可以在浏览器端的Web控制台上与Hadoop集群进行交互来分析处理数据,例如操作HDFS上的数据,运行MapReduce Job等等.很早以前就听说过Hue的便利与强大,一直没能亲自尝试使用,下面先通过官网给出的特性,通过翻译原文简单了解一下Hue所支持的功能特性集合: 默认基于轻量级sq

Cacti安装配置及使用

工作原理图: 整个系统有四部分组成: 1.Cacti系统平台用于用户设置与查看图表:Cacti需要LAMP环境的支持. 2.snmp用于采集数据给rrdtool绘制成图,使用161.162端口,用MIB数据库来保持数据信息,根据OID定位数据(类似1.3.6.1.2.1):Linux下使用net-snmp自带的snmpget和snmpwalk等程序,Windows下使用php的snmp功能. 3.RRDTool绘图引擎用于性能数据的存储和绘画图像. 4.Mysql数据库用来存储RRDTool绘图

Windows系统下XAMPP的安装配置图文教程

  这是关于在windows下XAMPP的安装配置图文教程,XAMPP 是什么?在linux ubuntu系统下安装配置LAMP时提到了XAMPP,XAMPP为我们提供了一种在Linux.Solaris.Windows和Mac OS X系统下简易安装Apache服务器发行版的快捷方法. XAMPP(X-系统,A-Apache,M-Mysql,P-php,P- Phpmyadmin/Perl)这个缩写名称说明了XAMPP安装包所包含的文件:Apache web 服务器, MySQL数据库, PHP

php5.3.10的安装配置步骤详解

在linux中php安装配置与windows中有不小的区别了,在linux中几乎都是代码形式了,下面我们一起来看看php5.3.10的安装配置步骤详解,希望下文可帮助到各位. 下面以最新的php-5.3.10为例进行安装. wget http://cn.php.net/distributions/php-5.3.10.tar.gz tar -zxvf php-5.3.10.tar.gz cd php-5.3.10 ./configure --prefix=/usr/local/php --wit

Grunt安装配置教程:前端自动化工作流

文章简介:Grunt 打造前端自动化工作流. Grunt这货是啥? 最近很火的前端自动化小工具,基于任务的命令行构建工具 http://gruntjs.com Grunt能帮我们干啥? 在开始介绍前,先向大家描述下面的场景: [场景1:项目开始前] 先建立一个 projA 的文件夹 再建 html css js images (建5个或以上文件夹,花费1分钟) 拷贝 CSS库(Yui Reset bootstrap)JS库(Requiet.js Seajs jQuery jQuery插件 ) 进