GoFuckYourself.com - Adult Webmaster Forum - View Single Post - We need 2 HEAVY Database servers setup. $75 for the person that can give me advice.

Nathan · 12-21-2005, 04:35 AM

You can not get a fault-tolerant system handling 10mil transactions a day and 250gig of space each raided for 10k.. forget it.

Anything anyone tells you you should get, it will not be fault-tolerant.

I would get 2 NAS (SAN or DAS) systems with at least 500gig raided (raid 6 most likely) each. Those alone would cost you something like 6-8k if you find them cheap. Then you would need 2 servers on top of that to handle the mysql dbs themself. Each one most likely dual p4s with 4gigs of ram. Get freebsd5 and mysql 5 installed and attach them to the DAS systems via NFS. Use one for master, one for slave. Do all writes to the master, all reads from the slave and the master. That would be rather fault-tolerant, but would cost you around 15k.

If you need details, let me know. I can post more.

12-21-2005, 04:35 AM
Nathan Confirmed User Industry Role: Join Date: Jul 2003 Posts: 3,108	You can not get a fault-tolerant system handling 10mil transactions a day and 250gig of space each raided for 10k.. forget it. Anything anyone tells you you should get, it will not be fault-tolerant. I would get 2 NAS (SAN or DAS) systems with at least 500gig raided (raid 6 most likely) each. Those alone would cost you something like 6-8k if you find them cheap. Then you would need 2 servers on top of that to handle the mysql dbs themself. Each one most likely dual p4s with 4gigs of ram. Get freebsd5 and mysql 5 installed and attach them to the DAS systems via NFS. Use one for master, one for slave. Do all writes to the master, all reads from the slave and the master. That would be rather fault-tolerant, but would cost you around 15k. If you need details, let me know. I can post more. __________________ "Think about it a little more and you'll agree with me, because you're smart and I'm right." - Charlie Munger