At 10/3/03 04:42 PM, AMDAthlon wrote:
Hey Tom and Wade,
Can you get someone to wire two or more servers in paralell with each other? If you can do this, you could have one huge database machine made up of multiple segments that could be controlled as one huge machine from a single workstation. In this way you would have the combined RAM of all the machines together as one huge chunk instead of having a huge lone server. It would take some major networking, but it could be done with the right programs and hardware.
I must agree. Whoever told you that you must have one giant database server is full of shit.
While this may be true for mySQL database software(which I assume you're using) I seriously doubt that the commercial databases are restricted to a single machine. I can't imagine that all the Banks and Insurance companies (etc) are using a single machine to handle their databases.
Obviously, switching to commercial database software is going to cost money, but with you guys spending so much money on database servers everytime you get traffic spikes, It could prove to SAVE money.
On another note, While mySQL is VERY fast for small sites, with small databases, Commercial packages such as Oracle, and Microsoft SQL Server are far better suited to large operations. LIKE NG.