December 2020
« Apr    

MySQL : How to create multiple root user (Super admin)

I have a situation to create multiple root users for managing a large Database. I used to execute ‘ grant all *. user@localhost identified by ‘password’ ” to create super users earlier. But I realized that these users can’t alter the existing users permission set even though they can create same privilege set users.

Knowing […]

How to block http /https access to specified hosts /network only

It was quite a long time I’d a visit to my blog. There were 2 reason, I got a new office and was strugging to keep up the rythom with new enviorments. Also there are certain personal stuff at my native place has to fixed which need my physical presence. So I was quite busy […]

Renaming database having innodb tables/Moving inoodb database

While you are working with Huge MySQL data, you will need to switch your tables to innodb storage engine to get fast transactions performance. Suppose if you have a requirement to restore the database which having +>400G volume and the target server having the same database name exist. So if you restore the database, the […]

Amazon EC2 : Enforcing HIPPA compliance hosting

HIPPA (Health Insurance Portability and Accountability Act) which directs the U.S. Department of Health and Human Services to establish national standards for processing electronic healthcare transactions. It also requires healthcare organizations to implement secure electronic access to health data and to remain in compliance with privacy regulations set by HHS. So any data which carry […]

Nginx Error : 413 Request Entity Too Large

The Web server (running the Web site) thinks that the HTTP data stream sent by the client (e.g. your Web browser or something you feed in application) was simply too large i.e. too many bytes than normal. What constitutes ‘too many bytes‘ depends partly upon the operation being attempted. For example a request to upload […]

GeoIP : How to manage the web traffic on Amazon loadbalencer or block web accesss to a country

Recently we had an issue with the nodes which added in Loadbalencers due to heavy traffic. Server load become high during the peak time and identified that most of the busy traffic are being used for spamming and marketing purpose. Also we getting many referral traffic from banned countries as showing below,

1. Russia 2. […]