Originally Posted by
double76
Thanks for everyone's input.
@tanfwc: I know cluster is a good solution here, but it is more expensive than my budget.
@pixelcoder: Actually I may have several solutions: a new SSD drive, a new SAS drive or SAN drive. At the standpoint of cost, internal drive is lower than SAN. But in the past years, I kept upgrading server, each time I have to backup huge data and took long time. The upgrade gave me headache on mysqldump that was so sloooow even on my 15000rmp SAS + 8G + Q9550. I am thinking if I may find a better way to my problem. I want a free-touch-on-database solution when upgrading the server. My vendor introduces SAN that could attached to my server. When I move to another server, just re-attach SAN to the new server, simple and safe. Meanwhile, SAN was built on SAS array that is obvious safer and faster than my current single SAS drive by all means. And, the connection between SAS drive and my server is also faster than the internal drive because the SAN is IP-based solution rather than a fiber channel.
@Scott.Mc: The total db size is around 100G, not grown by 100G. The index is really big, almost half size of db. I am sorry for misunderstanding. But I hate doing mysqldump each time, it was way slow.
@Coolraul: I have not get confirmation from the vendor, but I believe it is shared SAN speaking of the price.
Actually I just expect SAN may do sample performance as my single SAS does, but I could gain the advantage of SAN's manageability and reliability. Is my expecation reasonable? Thanks.