MySQL Forums
Forum List  »  MySQL & Storage

MySQL on SAN or DAS w/ replication
Posted by: Khalid Shaikh
Date: October 23, 2009 05:43PM

Hey!

We have a DB server with 500qps. Its doing about 20 000 reads per second with iostat -x 1 and 5 000 writes per second.

The server is disk i/o bound. It is running at Engine Yard w/ a SAN by CoRaid.

My recommendation is to move this onto separate direct attach storage machines with master/slave replication in the short term.

In the long term we will break up the large tables with sharding.

Any feedback would be appreciated. Is SAN better? Is DAS better? Etc.

Options: ReplyQuote


Subject
Written By
Posted
MySQL on SAN or DAS w/ replication
October 23, 2009 05:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.