All About Data,Analytics and Databases
Here is the typical œBig data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[…]
BigData · Cloudera · Data Analytics · Data Science · Data Warehouse · Database · ETL · Hadoop · Mapreduce · MySQL · NoSQL · PostgreSQL · Reporting · Scalability
Today I brought Microsoft Surface with Windows RT from Microsoft store in Valley Fair mall, Santa Clara, CA. As everyone wrote elsewhere, surprised to see more crowd in Microsoft store[…]
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[…]
Database · Hardware · MySQL · NoSQL · Performance
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[…]
Data Warehouse · Database · Performance · PostgreSQL · Scalability
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,[…]
Database · MySQL · NoSQL · Performance · Scalability
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[…]
Data Warehouse · Database · MySQL · NoSQL · Scalability
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[…]
BigData · Cloudera · Data Analytics · Data Science · Database · Hadoop · Mapreduce · MySQL · NoSQL · Scalability
Last month, I blogged about a case involving InnoDB, where all threads acting on InnoDB tables completely stuck for about few hours doing nothing; until we found a way to[…]
Database · MySQL · Performance · Scalability
In MySQL, even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and[…]
Database · MySQL · Performance · Scalability
