What is MySQL and why has it historically been so popular for web applications?