Explain the difference between relational and non-relational databases, and when you would choose MySQL over a NoSQL alternative.