Month: May 2020

Upgrading from Grafana 6 to Grafana 7

Install Latest version of Grafana RPM on top of existing version (6) , in order to Upgrade Grafana. wget https://dl.grafana.com/oss/release/grafana-7.0.1-1.x86_64.rpmsudo yum install grafana-7.0.1-1.x86_64.rpm Ensure to backup everything before proceeding with the Upgrade: Backup the database. If you’re using SQLite Db then the Default Location would be as below: [grafanaadmin@itpanther02 ~]$ ll /var/lib/grafana/total 460-rw-r–r–. 1 grafana grafana 471040 …

Upgrading from Grafana 6 to Grafana 7 Read More »

Setting up Redis Clustering

Create Redis Configuration File with below directive for each node: port 7000 cluster-enabled yes cluster-config-file nodes.conf cluster-node-timeout 5000 appendonly yes Move each configuration file to it’s folder: mkdir 700{1..6} Run redis-cli –cluster create command redis-cli –cluster create 127.0.0.1:7001 127.0.0.1:7002 127.0.0.1:7003 127.0.0.1:7004 127.0.0.1:7005 127.0.0.1:7006 –cluster-replicas 1

Redis Sets Datatype and Commands

Redis SADD – Creating and Adding Members to Redis Sets. sadd users_ip 10.0.0.1 sadd users_ip 10.0.0.2 10.0.0.3 192.168.0 Redis SCARD – Checking total numbers of members available in a list also known as checking cardinality. scard users_ip Redis SMEMBERS – Checking Total Numbers of Members in a set: smembers users_ip Redis SDIFF – Checking Members …

Redis Sets Datatype and Commands Read More »

Installing Apache NiFi Cluster on Linux

Step 1: Update hosts file entry with below 10.128.0.4 nifi0110.128.0.7 nifi0310.128.0.5 nifi02 Step 2: Update zookeeper.properties File on all the serversserver.1=nifi01:2888:3888;2181server.2=nifi02:2888:3888;2181server.3=nifi03:2888:3888;2181 Step 3: Create myid File Create ./state/zookeeper/myid file on all the 3 instances Step 4: Update content of myid file Update the value of myid file to 1 on instance 1, 2 on instance 2 …

Installing Apache NiFi Cluster on Linux Read More »

Installing NiFi Cluster on Windows Server

Step 1: Update hosts file entry with below  127.0.0.1 node1127.0.0.1 node2127.0.0.1 node3 Step 2: Update zookeeper.properties File on all the 3 instances server.1=node1:2888:3888;2181server.2=node2:2889:3889;2182server.3=node3:2890:3890;2183 Step 3: Create myid File Create ./state/zookeeper/myid file on all the 3 instances Step 4: Update content of myid file Update the value of myid file to 1 on instance 1, 2 …

Installing NiFi Cluster on Windows Server Read More »

Splitting Large Files to Smaller Files in NiFi

See the complete Video or scroll down to continue reading. Thumb Rule is, You should always use split record processor to split your total records divided by 10. So for example, If you have a file with 1,000,000 records and you want final output with only 10 records per FlowFile. Then you should first split …

Splitting Large Files to Smaller Files in NiFi Read More »

Changing Grafana Database From SQLite to MySQL

Installing MySQL Server wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm sudo yum install mysql-server Starting MySQL Server sudo systemctl start mysqld sudo systemctl status mysqld sudo grep ‘temporary password’ /var/log/mysqld.log Creating a New Database and a New User in MySQL Database sudo mysql_secure_installation create database grafanadb CREATE USER ‘grafana’@’localhost’ IDENTIFIED BY ‘grafana’; GRANT ALL PRIVILEGES ON …

Changing Grafana Database From SQLite to MySQL Read More »