We are looking at developing a website that will have approximately one million users over the span of the website. Users will be responding to questions from other users. Will mySQL be able to handle this kind of data or would we be better going with an enterprise solution?

mysql ~is~ an enterprise solution

and it can handle terabytes

just buy enough disks