[メモ] なんとなくBIなツールとかとか
Business intelligence, Software
[メモ] なんとなくBIなツールとかとか はコメントを受け付けていません。
10月 182017
久々にめぽ
# cat > /etc/tmpfiles.d/zabbix-agentd.conf <<END d /run/zabbix 0755 zabbix zabbix END # systemd-tmpfiles --create zabbix-agentd.conf
# cat > /etc/systemd/system/zabbix-agentd.service <<END [Unit] Description=Zabbix Agentd Daemon Requires=network-online.target After=network-online.target [Service] Type=forking PIDFile=/run/zabbix/zabbix_agentd.pid ExecStart=/usr/local/sbin/zabbix_agentd Restart=on-failure RestartSec=10 [Install] WantedBy=multi-user.target END
# yum install http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm # yum install http://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-3.noarch.rpm # yum install http://repo.zabbix.com/zabbix/2.4/rhel/7/x86_64/zabbix-release-2.4-1.el7.noarch.rpm
# yum install httpd Percona-XtraDB-Cluster-56 zabbix-agent zabbix-get zabbix-sender zabbix-server-mysql zabbix-web-japanese zabbix-web-mysql
# cat > /etc/my.cnf.d/my-plus.cnf <<END [client] default_character_set = utf8 [mysqld] thread_handling = pool-of-threads innodb_flush_method = O_DSYNC default_storage_engine = innodb character_set_server = utf8 collation_server = utf8_general_ci default-time-zone = +9:00 lc_time_names=ja_JP ft_min_word_len = 3 query_cache_type = 0 [mysql] no-auto-rehash default_character_set = utf8 END
# systemctl start mysql # mysql_secure_installation Set root password? [Y/n] n Remove anonymous users? [Y/n] y Disallow root login remotely? [Y/n] n Remove test database and access to it? [Y/n] y Reload privilege tables now? [Y/n] y
# mysql mysql> create database zabbix character set utf8; mysql> grant all privileges on zabbix.* to 'zabbix'@'%' identified by 'zabbix'; mysql> use zabbix mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/schema.sql mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/images.sql mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/data.sql mysql> flush privileges; mysql> quit
# cat >> /etc/zabbix/zabbix_server.conf <<END DBPassword=zabbix StartSNMPTrapper=1 END
# systemctl start zabbix-server # systemctl start zabbix-agent
# vi /etc/httpd/conf.d/zabbix.conf php_value date.timezone Asia/Tokyo <VirtualHost *:80> DocumentRoot /usr/share/zabbix </VirtualHost>
# systemctl start httpd # firewall-cmd --add-service=http --zone=public --permanent # firewall-cmd --zone=public --add-port=3306/tcp --permanent # firewall-cmd --zone=public --add-port=10050/tcp --permanent # firewall-cmd --zone=public --add-port=10051/tcp --permanent # firewall-cmd --zone=public --add-port=162/udp --permanent # firewall-cmd --reload
# systemctl enable mysql # systemctl enable zabbix-server # systemctl enable zabbix-agent # systemctl enable httpd
とりあえずコレで……
mysqldump \ --single-transaction \ --force \ -–no-data \ -–add-drop-table \ zabbix \ >zabbix-schema.sql mysqldump \ --single-transaction \ --quick \ --compress \ --force \ --hex-blob \ --disable-keys \ --no-create-info \ --default-character-set=utf8 \ --ignore-table=zabbix.history \ --ignore-table=zabbix.history_log \ --ignore-table=zabbix.history_str \ --ignore-table=zabbix.history_str_sync \ --ignore-table=zabbix.history_sync \ --ignore-table=zabbix.history_text \ --ignore-table=zabbix.history_uint \ --ignore-table=zabbix.history_uint_sync \ --ignore-table=zabbix.trends \ --ignore-table=zabbix.trends_uint \ zabbix \ >zabbix-data.sql
# yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm # yum localinstall http://repo.zabbix.com/zabbix/2.2/rhel/6/x86_64/zabbix-release-2.2-1.el6.noarch.rpm
# yum update # yum install mysql-community-client mysql-community-server # yum install zabbix-server-mysql zabbix-web-mysql zabbix-web-japanese # yum install zabbix-agent net-snmp-utils
# vi /etc/my.cnf default_storage_engine = innodb character_set_server = utf8 collation_server = utf8_general_ci lc_time_names=ja_JP innodb_file_per_table = 1 innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DSYNC innodb_log_files_in_group = 3
# service mysqld start # mysql_secure_installation
# mysql create database zabbix character set utf8; grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix'; \q
# vi /etc/zabbix/zabbix_server.conf NodeID=1 DBPassword=zabbix
# cd /usr/share/doc/zabbix-server-mysql-2.2.2/create # mysql zabbix < schema.sql # mysql zabbix < images.sql # mysql zabbix < data.sql
# zabbix_server -n 1
# service zabbix-server start
# /etc/httpd/conf.d/zabbix.conf php_value date.timezone Asia/Tokyo <VirtualHost *:80> DocumentRoot /usr/share/zabbix </VirtualHost>
# service httpd start
# chkconfig mysqld on # chkconfig zabbix-server on # chkconfig zabbix-agent on # chkconfig httpd on