Ok, so you are selling by internet. Amazon.com, eBay.com and Woot.com all sell buy internet. All three are very, very different in what they require. Amazon sells a ton of products and provides store fronts/hosting for many other companies. eBay sells tons of products, but also needs to track bids. Woot sells one product each day and only 5 days a week. Very different software and hardware requirements and probably traffic patterns. Amazon and eBay would both require clustering and load balancing, Woot would probably only require automatic failover.
Many is a relative term and so is high performance and high availability (i.e. five 9's). Maybe you need a cluster or maybe just replication.
Short answer, go with an IBM dual core Power based system with 32GB of RAM (or more), 16CPUs (or more), and 4GB per second FibreChannel array for storage. Or, order a bunch of cheap off the shelf generic PC systems and cluster them like Google does.
Really, it all depends on what your traffic patterns will look like. iTunes needs fast disks and lots of them to handle all the downloads that can take a while. The systems also need to handle many many long lasting active connections. Amazon really only ships products, so it's traffic patterns will be different than iTunes. And of course, poor database design will bring any hardware to it's knees.
On May 6, 2005, at 10:17 AM, Berta Alcala Larramendi wrote:
Hello,
I'm doing an University project and I need to "buy" a server for a business. I have to simulate an enterprise that sells by Internet. There are many clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much information as possible about the hardware requirements like number of processors, necessary memory, cache, HD... to use in a high performance MySQL server
Thanks very much for your help
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
