I've done this on the product I'm developing. You can set it up programmatically and it works exceptionally well. That being said, there are some performance considerations, especially if the sites you're hosting are high traffic.

I'd recommend reading the documentation and doing a bit of searching for a configuration that will fit your needs before you begin. It will save you a lot of time.

Good luck and let me know if you have any specific questions!