Just so I am clear here, you have 8 different DB servers hosting the same data that is being accessed and potentially modified simultaneously? You may want to consider the replication issues involved in that sort of arrangement with mysql. Aside from that, I am currently hosting an 18gb mysql database that is passing roughly 6gb/hr without any issue utilizing a single Dell R710 and mysql 5.0.77. Your mileage may differ based on the low end hardware/storage that you plan to use, the number of writes and the amount of data that you can cache in memory.
From: Yang Yang [mailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:38 PM To: David Brian Chait Cc: Johnny Withers; mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem about 8,000,000 visit,and about 40,000,000 sql do about 2g database,and the large table who aften use about 400m 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 1TB SATAII(*4 raid 10) 8gb ram thanks 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2011/2/28 David Brian Chait <dch...@invenda.com<mailto:dch...@invenda.com>> > -----Original Message----- > From: Yang Yang [mailto:dapiy...@gmail.com<mailto:dapiy...@gmail.com>] > Sent: Sunday, February 27, 2011 12:29 PM > To: Johnny Withers > Cc: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> > Subject: Re: centos server's mysql version's problem > thanks johnny > what about 5.1,did it performance better than 5.0 on centos when it has > large traffic? > 5.1 is newer,but i know not newer is better How much traffic is "large traffic"? How large is your database? How is it structured? What type of hardware are you using? -David
