Hello,
I need to build a high performance MySql server, business requirements are :
- support about 50-100 client/s which launch each one complex multi joined Select requests on 15 table (5 tables with 50K records max + 10 tables with 1K records max)
- present resultset into web pages (google style = first page of N ...), average records count returned will be near hundred
- need to reach real time
I notice that all operations on database will be on read only mode and MySql server will be tune to do at its best with the main purpose described above. Of course development and database structure are fully optimized.
My answer is about hardware, I intend to set up the following 8.000$ "beast" :
- core i7 965
- gigabyte + 14GO DDR3
- Fusion IO drive
Do you think it is the best choice ? I will be able to put two or three in parallel. Do i consider, rather than this unusual server, common multi core xeon system?
I have no budget limit.
Thanks
I need to build a high performance MySql server, business requirements are :
- support about 50-100 client/s which launch each one complex multi joined Select requests on 15 table (5 tables with 50K records max + 10 tables with 1K records max)
- present resultset into web pages (google style = first page of N ...), average records count returned will be near hundred
- need to reach real time
I notice that all operations on database will be on read only mode and MySql server will be tune to do at its best with the main purpose described above. Of course development and database structure are fully optimized.
My answer is about hardware, I intend to set up the following 8.000$ "beast" :
- core i7 965
- gigabyte + 14GO DDR3
- Fusion IO drive
Do you think it is the best choice ? I will be able to put two or three in parallel. Do i consider, rather than this unusual server, common multi core xeon system?
I have no budget limit.
Thanks