Welcome to WebmasterWorld Guest from 54.158.28.10

Forum Moderators: open

Message Too Old, No Replies

using multiple drives

why wouldn't you?

     
6:31 pm on Sep 12, 2013 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5612
votes: 33


I'm from a MS SQL shop, and i know things are a little different on the MySQL side of the world, so I am trying to learn as I go.

Let's say your MySQL setup has 2 hard drives:
- 20G partition on a SATA drive (slow)
- 140G partition on a SAS drive (fast)

Is there any reason why you would NOT want to have all your data files on the SAS drive from the setup?

And even assuming you originally set things up with just the SATA drive (later added the SAS drive), is there a compelling reason NOT to move the data files to the SAS drive?

Note- the server is not yet in production. So shutting down MySQL and moving the files will not affect any users.
2:30 am on Sept 17, 2013 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


I cannot speak to this question personally but have a look at this PDF from Percona
[percona.com...]
Let me know what you deduce!
1:31 pm on Sept 17, 2013 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5612
votes: 33


I may or may not need to have alcohol involved to make a deduction. ;)

Interesting page- it's going to take a while to absorb it all. Thanks!