Posts from — January 2011

Statement-based vs Row-based Replication

Replication as most people know it, has mostly been SQL statement propagation from master to slave. This is known as “statement-based” replication. But there is also another kind of replication that is available, “the row-based replication” and that has quite a lot of benefits. In this post I intend on highlighting the advantages and disadvantages of both the types of replication to help you choose the best one. I also follow up with my own recommendation.

January 27, 2011   Views: 28,989   12 Comments

Understanding InnoDB clustered indexes

Some people don’t probably know, but there is a difference between how indexes work in MyISAM and how they work in InnoDB, particularly when talking from the point of view of performance enhancement. Now since, InnoDB is starting to be widely used, it is important we understand how indexing works in InnoDB. Hence, the reason for this post!

January 20, 2011   Views: 28,889   23 Comments

My recommendation for a basic Mail Server setup

Ever wanted to setup a mail server complete with IMAP and POP access, one that was easy to configure and install and had a low memory footprint. Well I too wanted to have such a setup and after having tried Exim, Postfix together with Courier and Dovecot, I am pretty pleased with what Dovecot has to offer.

January 20, 2011   Views: 8,314   3 Comments