Today, one of the MySQL database server response time has been increased within the pool of servers and noticed it was returning the query in 0.20 secs (randomly) as opposed[...]
Data Warehouse · Database · Performance · PostgreSQL · Scalability
PostgreSQL : Slony Replication Lag – Manual Log Tables Cleanup
If you using slony for PostgreSQL replication for more than one node (multiple replicas or cascading); then occasionally you might experience delays in replication if any one node is lagging[...]
Database · MySQL · NoSQL · Performance · Scalability · Zynga
MySQL At Scale – Zynga Games
Recently am part of Zynga‘s database team as I was pretty much impressed with company’s database usage. As everyone knows how popular Zynga games like Farmville, Cafe World, Mafia Wars,[...]
Data Warehouse · Database · MySQL · NoSQL · Scalability
Why Kickfire is a fail in MySQL Data warehouse
Even though Data warehouse is picking very rapidly in the last year or so, but few companies who are already made a right mark in the right time could not[...]
BigData · Cloudera · Data Analytics · Data Science · Database · Hadoop · Mapreduce · MySQL · NoSQL · Scalability
MapReduce – DBInputFormat – Serialization on readers
Last week I was working on EC2 MySQL server where one of the slave is taking lot of time to catch-up; and only job that is running on that server[...]