Tag Archives: mysql

Tip-toe through Naukri, India’s No.1 job site #OneDayTale

Glipmse of Hackathon 2016. We love open source and hence we are very open to transparency. The inception to this blog post was an idea to share the walk through of how a user is served in a typical day by your beloved Naukri.com. Naukri is a black box which gives you results but under the hood it is way more than what anyone can think. Under the hood [caption id="" align="alignnone" width="800"] Under the hood working of a car, GIF image.[/caption] Source Something like below is what we are continuously doing to serve you better. [caption id="" align="alignnone" width="549"] Car engine... Read More

MySQL Installation/Configuration Automation

MySQL Installation Automation In today’s fast paced technology world, where numbers are growing be it data size, no. of requests per second, no of databases etc., to manage these big volumes, standard operation procedures play a key role. It helps not only in ensuring smooth operations of web based products but also plays a major role for administrators to manage it in a controlled fashion. Standards are important, but enforcing them if one have multiple human resources to work towards achieving them is difficult. Configuring the setups manually is error prone and not manageable as your no. of installations grow... Read More

User Data Logging Using Mongo

Torture the data, and it will confess to anything......... Why bother capturing data ? Data has become the most valuable commodity to every Internet company out there and therefore collection of data turns up to be a very essential task. Such was the need encountered by Naukrigulf team. The product team asked us to come up with the solution to log the modified and view timestamp for every jobseeker fields like username, salary, photo, work experience, etc. So, we needed to capture when a particular jobseeker viewed a particular field and which ones he edited. The very sole purpose of... Read More

How we converted Latin1 encoding to UTF8 in Mysql DB

The problem statement of converting latin 1 encoding to UTF-8 encoding in mysql  database is something similar to upgrading your linguistic skills from english to any other language in the world. Sounds impractical!! Correct, you may find it difficult to learn all the languages in the world as it is practically impossible to learn the rules of so many languages. But machines can do it easily. You just need to feed it with character set of that language and rules i.e. in technical term collation. We at naukrigulf deal with middle east countries so our system needs to understand ARABIC... Read More

MyTrend for MySQL

Data – the heart of any website. MySQL – most websites (including ours) are powered by it. With increasing transactions, servers and database sizes, it was becoming a pain to manage and monitor all of it. We thus built MyTrend – an ingenious tool to monitor data growth trend and server space utilization simple enough to be customized easily. This is what it does :  * Monitor Everything - Everything inside your MySQL can be monitored (Database Size, Connections, Slow Queries etc)  * Analyze MySQL data collected over a period of time  * Capacity Planning - Plan the growth... Read More