What are some guidelines to follow when it comes to sizing MySQL Servers? CPUs, RAM, Disk Space, Clock Speeds, etc?
We're going to go with either the community edition or the enterprise edition, and use it to run Drupal for a www and other top-level sites. OS is RHEL 6.x, on VMWare. We'll also probably run a caching tool, like memCache or Varnish. At the moment we are looking at two load balanced web servers that connect to one or more MySQL servers. There is talk of possibly using a master-slave or multi-master configuration. DB engine is going to be InnoDB.
We're looking at about 6000 pages of content to start, and grow quickly. Our normal throughput is about 40Mbps (observed over one hour), although we've seen it as high as 70Mbps occasionally.