cwarn23 Posted May 11, 2009 Share Posted May 11, 2009 Hi, I have been trying to find a way to get my databases on two external hard drives plus one internal hard drive but I just can't find a way to place each database on a separate drive. The only thing I have come across is windows junctions but can't find tutorials on windows junctions but not sure if that will even work. Does anybody know how I can place 3 MySQL databases on 3 different drives without merging the drives? Operating System: Windows XP Pro Hard Drive Sizes: 500GB, 1.5TB, 300GB MySQL Version: 5.1.30 Quote Link to comment https://forums.phpfreaks.com/topic/157678-storing-mysql-on-3-drives/ Share on other sites More sharing options...
fenway Posted May 11, 2009 Share Posted May 11, 2009 You can specify a datadir for each instance of the server, but I'm fairly certain you can't do this on a DB level. Quote Link to comment https://forums.phpfreaks.com/topic/157678-storing-mysql-on-3-drives/#findComment-831564 Share on other sites More sharing options...
cwarn23 Posted May 12, 2009 Author Share Posted May 12, 2009 Then could you please explain how to specify a datadir for multiple drives? I am clueless on how to solve this one as a file based system with over a million folders just crashed the harddrive. That is why I need a database system in place. Quote Link to comment https://forums.phpfreaks.com/topic/157678-storing-mysql-on-3-drives/#findComment-832070 Share on other sites More sharing options...
fenway Posted May 12, 2009 Share Posted May 12, 2009 One datadir = one drive. You can't "span" drives with the datadir options. Why not use LVM? Quote Link to comment https://forums.phpfreaks.com/topic/157678-storing-mysql-on-3-drives/#findComment-832611 Share on other sites More sharing options...
cwarn23 Posted May 13, 2009 Author Share Posted May 13, 2009 Well 2 of the drives are removable drives and I don't think it's possible to merge removable drives I guess currently my ownly options are to have separate database programs on each drive or to have a huge file which php will read section by section. It's unfortunate that MySQL does not offer such a feature as it would really make things easier. Quote Link to comment https://forums.phpfreaks.com/topic/157678-storing-mysql-on-3-drives/#findComment-832956 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.