Not too long ago, someone posted an article here about how common LDRs are becoming, and how, despite perceptions, they aren't more likely to fail than more conventional, closer relationships.
That being said, it is very hard, especially around goodbyes (before, during, and for a while after). You have to be more independent, and in a way, you're in this weird gray area. You're attached, yet you have to go to family get-togethers alone. You are deeply in love, yet you sleep alone hugging a pillow.
But in other ways, it is a very healthy basis for a relationship. You have to learn to trust your mate. I don't know if this is universal, but Mr. Moggs and I spend a lot more time talking and communicating than average married couples. When he's been here for extended periods of time, that has translated to a closeness that I've never had with anyone else. And after over six years of mostly LDR, the last thing I am worried about is whether or not we will get on well after Saturday.
If you're up for the extra work and consideration, I think that LDRs can eventually lead to the most solid of partnerships. Don't let naysayers discourage you, but really think about what you and your significant other want and need and go from there.