MySQL Enterprise Monitor安装
来源:互联网 发布:linux查看登录失败日志 编辑:程序博客网 时间:2024/05/16 02:58
体系架构
----------------------------------------------------
Monitired MySQL Server <--> Agent --> Monitor
安装步骤
----------------------------------------------------
1. 建立一个作为Repository独立的MySQL数据库,也可以用EM自带的
2. 安装EM
3. 在每个要监视的MySQL server上安装EM agent
安装文件
EM:
mysqlmonitor-2.3.9.2137-linux-x86_64-installer.bin
mysqlmonitor-2.3.9.2137-linux-x86_64-update-installer.bin
EM agent:
mysqlmonitoragent--2.3.9.2137-linux-x86_64-installer.extension
安装EM
----------------------------------------------------
./mysqlmonitor-2.3.9.2137-linux-x86_64-installer.bin --mode unattended \
--mysql_installation_type bundled \
--installdir /data/enterprise/monitor \
--adminuser em_admin --adminpassword em_password
./mysqlmonitor-2.3.9.2137-linux-x86_64-update-installer.bin --mode unattended \
--installdir $MYSQL_ROOT/enterprise/monitor \
--createDataBackup 0
Repository用EM自带的mysql,缺省会在13306端口启动,所有的配置文件,数据文件都放到了安装目录:
mysql -u em_admin -padmindemo -h 127.0.0.1 -P 13306
mysql> select user,password,host from mysql.user;
+----------+-------------------------------------------+------------+
| user | password | host |
+----------+-------------------------------------------+------------+
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | localhost |
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | mysql02-us |
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | 127.0.0.1 |
+----------+-------------------------------------------+------------+
3 rows in set (0.00 sec)
mysql> show variables like '%datadir%';
+---------------+---------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------+
| datadir | /mysql/enterprise/monitor/mysql/data/ |
+---------------+---------------------------------------+
1 row in set (0.00 sec)
mysql>
启停EM:
mysqlmonitorctl.sh start
mysqlmonitorctl.sh status
mysqlmonitorctl.sh stop
EM用的是tomcat作为web服务器的
http://hostname:18080
第一次登录需要做如下的初始化设置
1. Set up your My Oracle Support credentials.
2. Create a user name and password for the dashboard administrator.
dba/oracle123
3. Create a user name and password for the Monitor Agent.
em_agent/agentdemo
4. 在页面上上传AdvisorScript-Platinum-2.3.9.2137.jar
EM Agent的的安装
----------------------------------------------------
mysqlmonitoragent-version-linux-glibc2.3-x86-64bit-installer.bin --mode unattended \
--installdir mysql/enterprise/agent
--mysqlhost 127.0.0.1 --mysqlport 3306 --mysqluser agent --mysqlpassword mysql --checkmysqlhost yes ##被监视的数据信息
--managerhost em_hostname --managerport 18080 --agentuser AGENTUSER --agentpassword PASSWORD ##连接monitor的信息
--proxyport 44044 --enableproxy 0
--createaccount 1 --rootuser ROOTUSER --rootpassword PASSWORD
enableProxy就是让agent具有mysql proxy的功能,应用通过agent来连接数据库,这样agent就可以收集到sql语句来做Query Analyzer
这个功能对单机数据库用用
Em agent需要两个连接
一个连接management服务器,就是EM monitor,需要哦能够到前面建立的agent用户名和密码
一个连接被监视的MySQL,一般是本机3306端口的数据库,它需要用被监视数据库的root用户登录来建立自己需要的agent用户名和密码
启动和停止agent
/etc/init.d/mysql-monitor-agent start
/etc/init.d/mysql-monitor-agent status
/etc/init.d/mysql-monitor-agent stop
----------------------------------------------------
Monitired MySQL Server <--> Agent --> Monitor
安装步骤
----------------------------------------------------
1. 建立一个作为Repository独立的MySQL数据库,也可以用EM自带的
2. 安装EM
3. 在每个要监视的MySQL server上安装EM agent
安装文件
EM:
mysqlmonitor-2.3.9.2137-linux-x86_64-installer.bin
mysqlmonitor-2.3.9.2137-linux-x86_64-update-installer.bin
EM agent:
mysqlmonitoragent--2.3.9.2137-linux-x86_64-installer.extension
安装EM
----------------------------------------------------
./mysqlmonitor-2.3.9.2137-linux-x86_64-installer.bin --mode unattended \
--mysql_installation_type bundled \
--installdir /data/enterprise/monitor \
--adminuser em_admin --adminpassword em_password
./mysqlmonitor-2.3.9.2137-linux-x86_64-update-installer.bin --mode unattended \
--installdir $MYSQL_ROOT/enterprise/monitor \
--createDataBackup 0
Repository用EM自带的mysql,缺省会在13306端口启动,所有的配置文件,数据文件都放到了安装目录:
mysql -u em_admin -padmindemo -h 127.0.0.1 -P 13306
mysql> select user,password,host from mysql.user;
+----------+-------------------------------------------+------------+
| user | password | host |
+----------+-------------------------------------------+------------+
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | localhost |
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | mysql02-us |
| em_admin | *B994AC90D2010A61C3E18636CB3225DD173DFD23 | 127.0.0.1 |
+----------+-------------------------------------------+------------+
3 rows in set (0.00 sec)
mysql> show variables like '%datadir%';
+---------------+---------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------+
| datadir | /mysql/enterprise/monitor/mysql/data/ |
+---------------+---------------------------------------+
1 row in set (0.00 sec)
mysql>
启停EM:
mysqlmonitorctl.sh start
mysqlmonitorctl.sh status
mysqlmonitorctl.sh stop
EM用的是tomcat作为web服务器的
http://hostname:18080
第一次登录需要做如下的初始化设置
1. Set up your My Oracle Support credentials.
2. Create a user name and password for the dashboard administrator.
dba/oracle123
3. Create a user name and password for the Monitor Agent.
em_agent/agentdemo
4. 在页面上上传AdvisorScript-Platinum-2.3.9.2137.jar
EM Agent的的安装
----------------------------------------------------
mysqlmonitoragent-version-linux-glibc2.3-x86-64bit-installer.bin --mode unattended \
--installdir mysql/enterprise/agent
--mysqlhost 127.0.0.1 --mysqlport 3306 --mysqluser agent --mysqlpassword mysql --checkmysqlhost yes ##被监视的数据信息
--managerhost em_hostname --managerport 18080 --agentuser AGENTUSER --agentpassword PASSWORD ##连接monitor的信息
--proxyport 44044 --enableproxy 0
--createaccount 1 --rootuser ROOTUSER --rootpassword PASSWORD
enableProxy就是让agent具有mysql proxy的功能,应用通过agent来连接数据库,这样agent就可以收集到sql语句来做Query Analyzer
这个功能对单机数据库用用
Em agent需要两个连接
一个连接management服务器,就是EM monitor,需要哦能够到前面建立的agent用户名和密码
一个连接被监视的MySQL,一般是本机3306端口的数据库,它需要用被监视数据库的root用户登录来建立自己需要的agent用户名和密码
启动和停止agent
/etc/init.d/mysql-monitor-agent start
/etc/init.d/mysql-monitor-agent status
/etc/init.d/mysql-monitor-agent stop
- MySQL Enterprise Monitor安装
- 安装MySQL Enterprise Monitor
- Linux 下卸载MySQL Enterprise Monitor
- 安装MySQL Enterprise Edition
- MySQL Enterprise Monitor 3.0.7 has been released
- 在RedHat Enterprise Linux5上安装MySQL
- Redhat Enterprise Linux 6.3 下安装mysql
- linux enterprise 5下安装mysql 5.6
- Redhat Enterprise 7.2 安装 MySQL 5.7
- MySQL replication monitor
- zabbix monitor mysql
- Red Hat enterprise linux 5 -mysql安装步骤
- Red Hat enterprise linux 6卸载默认安装的 mysql
- SuSE Linux Enterprise Server 11 SP2 安装mysql
- 安装MySQL -- SuSE Linux Enterprise Server 11 SP2
- oracle enterprise linux 7下安装mysql 5.6
- SuSE Linux Enterprise Server 11 SP2 安装mysql
- Kafka-Offset-Monitor安装
- 搜狗CEO王小川杀出重围的三个产品
- cannot expose session attribute '_from_source' because of an existing model object of the same name
- 【android开发】手机应用管理器的实现之实现软件加锁(四)
- worldwind学习笔记-9-从头开始,单例模式
- 错误日志struts2 http 404 not found可能原因之一
- MySQL Enterprise Monitor安装
- oracle11gr2_rac_删除节点最佳实践
- 税盾(Tax Shield)
- MySQL存储过程中使用游标和临时表
- [转]最牛B的编码套路
- windows环境下部署django mod_wsgi apache
- Building an MFC project for a non-Unicode character set is deprecated
- linux下C语言errno
- DShow实现一个avi视频的播放(含有个人解释和注释)