Tuesday, September 15, 2009

Integrity Vs Performance

Its not an easy decision. If you love your data as much, you probably have nightmares all the time about your server crashing. And so, you have daily backups setup, and even binary logging on a separate physical device, may be even clusters, and yet you remain paranoid.

On the other hand, you have your application team constantly complaining about how your databases are sooooo slow. Yes, they don't have any idea how much work it took to organize the data the way it is, choosing the right storage engines, optimizing the tables ever so frequently, and tuning the several hundred server variables just to get to this point.

The fact remains, you can't have a perfect system. You have to compromise, depending on your use case.

It's all about the balance...

No comments:

Post a Comment