puppet 安装mysql_puppet学习—默认WEBRick安装DashBoard

DashBoard是puppet的控制台，用于显示puppet master和puppet agent的相关信息。本文以默认的WEBRick提供Web服务。DashBoard 安装在master.test.com。并且在客户端配置文件做如下配置

#vim /etc/puppet/puppet.conf

[agent]

report = true

一、安装依赖软件包

#yum -y install mysql mysql-devel mysql-server ruby ruby-devel ruby-irb ruby-mysql ruby-rdoc ruby-ri rubygems

#gem install rake

二、安装DashBoard软件包

#yum install -y  puppet-dashboard

三、配置DashBoard

1创建数据库

#vim /etc/my.cnf

max_allowed_packet = 32M

#service mysqld start

#chkconfig mysqld on

#mysql

mysql>create database dashboard CHARACTER SET utf8;

mysql>create user 'dashboard'@'localhost' IDENTIFIED BY 'dashboard';

mysql>grant all privileges on dashboard.* TO 'dashboard'@'localhost';

mysql>flush privileges;

2修改配置文件

#vim /usr/share/puppet-dashboard/config/database.yml

production:

database: dashboard

username: dashboard

password: dashboard

encoding: utf8

adapter: mysql

#vim /usr/share/puppet-dashboard/config/settings.yml

time_zone: 'Asia/Shanghai'

3导入数据库,启动服务

#cd /usr/share/puppet-dashboard/config

#rake RAILS_ENV=production db:migrate

#service puppet-dashboard start

#chkconfig puppet-dashboard on

#rake RAILS_ENV=production db:raw:optimize   #优化数据库

4导入现有报告

#cd /usr/share/puppet-dashboard

#rake RAILS_ENV=production reports:import

5配置实时发送报告

#vim /etc/puppet/puppet.conf

reports = store,tagmail,log,puppet_dashboard,http

reporturl = http://172.16.30.220:3000/reports

6开启报告

#rake RAILS_ENV=production jobs:work 2 &>1 &

7访问dashboard

四、数据库管理

1当puppet dashboard数据量过多的时候，需要优化数据库，可使用命令：

#rake RAILS_ENV=production db:raw:optimize

2清理dashborad一个月之前的数据：

#rake RAILS_ENV=production reports:prune upto=1 unit=mon

3备份puppet dashborad数据库：

#rake RAILS_ENV=production FILE=/my/backup/file.sql db:raw:dump

4恢复数据：

#rake RAILS_ENV=production FILE=production.sql db:raw:restore