2

I'm trying to figure out how to set up the storage for a site that currently requires only one server, but will certainly grow to demand more. I the database is largely innodb tables. I understand that clustering servers isn't an option because that ignores foreign keys. I saw reference to federated storage, but that seems to have issues too. Do you have any other storage suggestions that are compatible with foreign keys, and know the pros and cons? Thanks for the help.

-Storm

KPWINC
  • 11,394
  • 3
  • 37
  • 45
storm
  • 89
  • 2
  • 3
  • 12

2 Answers2

2


(source: oreilly.com)

The book above is a very good place to start reading about mySQL and its various storage engines as well as the pros and cons of each.

http://oreilly.com/pub/pr/2031

Glorfindel
  • 1,213
  • 4
  • 15
  • 22
KPWINC
  • 11,394
  • 3
  • 37
  • 45
  • ok, thanks. im going to go pick this up asap, and try to fully understand cagenut's suggestion. – storm Aug 28 '09 at 23:39
  • The book will help you A LOT. You can also find/purchase it online in .PDF format I believe. – KPWINC Aug 29 '09 at 00:45
0

short answer: 4 -8 spindles, 10krpm or above, raid10 w/BBU and write-back enabled

long answer: read the book and the website

cagenut
  • 4,848
  • 2
  • 24
  • 29