In one of my projects, I was using redis database to collect some statistics and I thought of saving data into it at apache level. This would considerably enhance the speed of saving data as it would not require the interception of grails to save data.<\/p>\n
The first step for this was to install apache by firing the following command in terminal :<\/p>\n
[bash]sudo apt-get install apache2[\/bash]<\/p>\n
After installing apache, it was required to set up a site. For that I created a file named www.raj.com in \/etc\/apache2\/sites-available directory and configured it as follows:<\/p>\n
[bash]
\n<VirtualHost *:80>
\nServerAdmin webmaster@localhost
\nServerName www.raj.com
\nServerAlias raj.com<\/p>\n
DocumentRoot \/usr\/lib\/cgi-bin<\/p>\n
<Directory \/>
\nOptions FollowSymLinks
\nAllowOverride All
\nOrder allow,deny
\n<\/Directory><\/p>\n
ScriptAlias \/cgi-bin\/ \/usr\/lib\/cgi-bin\/
\n<Directory "\/usr\/lib\/cgi-bin">
\nAllowOverride All
\nAddHandler cgi-script .cgi
\nOptions +ExecCGI -MultiViews +SymLinksIfOwnerMatch
\nOrder allow,deny
\nAllow from all
\n<\/Directory><\/p>\n
ErrorLog ${APACHE_LOG_DIR}\/error.log<\/p>\n
# Possible values include: debug, info, notice, warn, error, crit,
\n# alert, emerg.
\nLogLevel warn<\/p>\n
CustomLog ${APACHE_LOG_DIR}\/access.log combined<\/p>\n
Alias \/doc\/ "\/usr\/share\/doc\/"
\n<Directory "\/usr\/share\/doc\/">
\nOptions Indexes MultiViews FollowSymLinks
\nAllowOverride All
\nOrder deny,allow
\nDeny from all
\nAllow from 127.0.0.0\/255.0.0.0 ::1\/128
\n<\/Directory><\/p>\n
<\/VirtualHost><\/p>\n
[\/bash]<\/p>\n
Here the ServerName is set to www.raj.com and DocumentRoot is set to \/usr\/lib\/cgi-bin. It means that if I hit url www.raj.com, then i will see the contents of \/usr\/lib\/cgi-bin directory (This will come into action after enabling the site).
\nAddHandler cgi-script .cgi means that we are adding a cgi-script handler for files whose extension is cgi.<\/p>\n
Now my site is in the list of available sites, but it’s still not enabled. To enable it I fired the following command in terminal :<\/p>\n
[bash]a2ensite www.raj.com[\/bash]<\/p>\n
This command created a soft link of my site into \/etc\/apache2\/sites-enabled directory and now my site was enabled.<\/p>\n
The last step was to make an entry for my site in\u00a0 \/etc\/hosts. I appended following line to \/etc\/hosts to do so :<\/p>\n
[bash]127.0.0.1 www.raj.com[\/bash]<\/p>\n
Finally, i was required to reload apache using command<\/p>\n
[bash]service apache2 reload [\/bash]<\/p>\n
And now my site was live. To save data into the redis database, i created a file named saveData.cgi in \/usr\/lib\/cgi-bin folder, given execution permissions to it and entered the following script into it.<\/p>\n
[bash]<\/p>\n
#!\/bin\/sh
\necho "Content-type: text\/html\\n\\n"<\/p>\n
date="na"
\npartnerSite="na"
\nvideoId="na"<\/p>\n
date=`echo $QUERY_STRING | sed ‘s\/.*date\\=\\([^&]\\+\\).*\/\\1\/’`<\/p>\n
partnerSite=`echo $QUERY_STRING | sed ‘s\/.*partnerSite\\=\\([^&]\\+\\).*\/\\1\/’`<\/p>\n
videoId=`echo $QUERY_STRING | sed ‘s\/.*videoId\\=\\([^&]\\+\\).*\/\\1\/’`<\/p>\n
`redis-cli hincrby "$videoId-$date-views" $partnerSite 1`<\/p>\n
[\/bash]<\/p>\n
Here shebang is used to execute script in the bash shell and the content type is set to text\/html.
\nIn redis, HINCRBY command is used in relation with hashes, where a key has one or more fields each with a corresponding value.
\nIf the key and field already exists in the redis database, HINCRBY command would increment the value of the field by specified number. If the key doesn’t exists, HINCRBY creates a key with specified filed and value.<\/p>\n
Thus, if i hit the url in my browser, then date, partnerSite and videoId are extracted from the query string using sed command and in the redis database an entry would be saved whose key will be “wwYXWU-20July2012-views”, field will be “facebook” and value will be 1. If the same url is received again, the value of field “facebook” of key “wwYXWU-20July2012-views” will become 2 and so on.<\/p>\n
In this way, we can easily use apache to save and update data in redis database.<\/p>\n","protected":false},"excerpt":{"rendered":"
In one of my projects, I was using redis database to collect some statistics and I thought of saving data into it at apache level. This would considerably enhance the speed of saving data as it would not require the interception of grails to save data. The first step for this was to install apache […]<\/p>\n","protected":false},"author":46,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10},"categories":[7],"tags":[18,260,857,453],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/6056"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=6056"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/6056\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=6056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=6056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=6056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}