locked
Serving MySQL/PHP from a WHS machine? RRS feed

  • Question

  • I reviewed the threads and find some indication that serving MySQL/PHP from a WHS machine has been done successfully. These threads tended to be pretty old and not definitive on the How To aspects of setting this up.

     

    Anybody seen a good How To on this they could point me to?

     

    When I install WHS is there an option to use a larger primary partition than the apparently standard 20GB? Or is the best bet to teach MySQL to use the data partition(s) for its purposes?

    Wednesday, October 3, 2007 6:57 PM

Answers

  • You don't have any choice about how WHS sets up your disks. You get a 20 GB system partition on the system disk, an "everything minus 20 GB" DATA partition, and all other disks are formatted and added to the storage pool as secondary disks. But if your database is going to be small (under 1-2 GB, I'd say), there's no reason to not use the system partition. If it's going to be larger, but under maybe 10 GB, you could put it on the D: partition outside of any folders that WHS uses. It will take up some space, but 10 GB probably won't cripple you. If it's going to be huge, put another disk in (but don't add it to the storage pool) and store the database on that.

    As for PHP/MySQL, I know that there are a couple of people who have successfully installed them. I haven't, so can't help you too much there. One of them will likely chime in soon.

    But consider something before you install PHP/MySQL: WHS does limit your use of the hardware in a lot of ways, because it's designed primarily as an easy to use appliance that can be installed in a connected home. If you're looking for a development platform, WHS is really not your best choice. As much as I love the product, I wouldn't use it in a business environment, or as a development platform, or an FTP server, etc.
    Wednesday, October 3, 2007 11:12 PM
    Moderator

All replies

  • You don't have any choice about how WHS sets up your disks. You get a 20 GB system partition on the system disk, an "everything minus 20 GB" DATA partition, and all other disks are formatted and added to the storage pool as secondary disks. But if your database is going to be small (under 1-2 GB, I'd say), there's no reason to not use the system partition. If it's going to be larger, but under maybe 10 GB, you could put it on the D: partition outside of any folders that WHS uses. It will take up some space, but 10 GB probably won't cripple you. If it's going to be huge, put another disk in (but don't add it to the storage pool) and store the database on that.

    As for PHP/MySQL, I know that there are a couple of people who have successfully installed them. I haven't, so can't help you too much there. One of them will likely chime in soon.

    But consider something before you install PHP/MySQL: WHS does limit your use of the hardware in a lot of ways, because it's designed primarily as an easy to use appliance that can be installed in a connected home. If you're looking for a development platform, WHS is really not your best choice. As much as I love the product, I wouldn't use it in a business environment, or as a development platform, or an FTP server, etc.
    Wednesday, October 3, 2007 11:12 PM
    Moderator
  • Sound perfect. The database today is in the single digit megabytes and gets banged on very rarely. I appreciate your use case suggestions. The amount of development/FTP/IIS, etc., for this machine is very small and relatively infrequent, so I think the limitations won't be onerous at all.

     

    Thanks for the help.

    Thursday, October 4, 2007 1:35 AM
  • Saturday, August 15, 2009 7:53 PM