tin_the_fatty weblog

Photography is a road long and lonely.

tin_the_fatty weblog header image 2

MySQL vs PostgreSQL

July 26th, 2005 · No Comments

Long story short:-

  1. Mother’s email system uses MySQL as table lookup.
  2. Since hosting a couple of additional domains which are constantly being bombarded by spammers, the MySQL server under heavier load kept losing connections (dropped email connection/transfer, no big deal, the other side would just retry in a few minutes) and sometimes even hanged (big problem as this takes down the email system as well as phpBB and WordPress).
  3. I was reluctant to run two SQL database servers. No point using up twice the resources to have two servers doing the same thing.
  4. I couldn’t get MySQL to work reliably on mother. I was getting desperate to fix the problem, so I tried it w/ switching to PostgreSQL as table lookup for email system.
  1. Seems to work fine.

Tags: Coop