Tuesday, June 30, 2015

Mysql new user addition

login as root

add new user:

mysql> CREATE USER 'some_user'@'localhost' IDENTIFIED BY 'my_password';


grant all the permissions to the new user:

mysql> GRANT ALL PRIVILEGES ON *.* TO ’some_user’@’localhost’;

grant only usage permissions to the newly crated user:
mysql> GRANT USAGE ON *.* TO 'some_user'@'localhost' IDENTIFIED BY 'my_password';

Saturday, June 13, 2015

Big data

Large scale data processing - hadoop
High rate data processing - kafka + storm    (optional samza)
Map-Reduce

Wednesday, June 3, 2015

zabbix agent installation in AWS

[ec2-user@ip-172-31-14-34 ~]$ wget http://sourceforge.net/projects/zabbix/files/ZABBIX%20Latest%20Stable/2.4.5/zabbix-2.4.5.tar.gz/download
[ec2-user@ip-172-31-14-34 ~]$ mv download zabbix-2.4.5.tar.gz
[ec2-user@ip-172-31-14-34 ~]$ tar -xf zabbix-2.4.5.tar.gz
[ec2-user@ip-172-31-14-34 ~]$ cd zabbix-2.4.5
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ sudo yum groupinstall "Development Tools"
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ ./configure --help
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ ./configure --prefix=/opt/zabbix-2.4.5 --enable-agent
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ sudo make install
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ sudo vim /opt/zabbix-2.4.5/etc/zabbix_agentd.conf
Server=172.31.29.64   //point to the ip address of zabbix server
ServerActive=172.31.29.64   //point to the ip address of zabbix server
AllowRoot=1  //change from 0 to 1
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ sudo /opt/zabbix-2.4.5/sbin/zabbix_agentd -c /opt/zabbix-2.4.5/etc/zabbix_agentd.conf
[ec2-user@ip-172-31-14-34 zabbix-2.4.5]$ ps -ef | grep zabbix



Followers