no, MDs only need to be turned on when you are using them. be aware that any hardware (such as tuner cards, hard drives, etc) will only be available to the rest of the system if the MD is turned on though.
boot times can be a problem, but thats up to you if its too long or not. i know there was someone on the past that had his on timers to turn on and off at certain times.