Database parallelism choices greatly impact scalability

Sam Madden in the The Database Column blog covers some database architectures. Quick summary:
  • Shared-memory systems don't scale well as the shared bus becomes the bottleneck
  • Shared-disk systems don't scale well either
  • Shared-nothing scales the best