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 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. 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. 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? 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. 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
Archived
This topic is now archived and is closed to further replies.