Is MySQL the good solution for website like cnn.com or freelancer.com? Or should I use some other solution? Thanks for your opinion.
MySQL is RDBMS and is solution for almost all data needs. It depends on how you design your database and how you optimize it to deliver fast and accurate results. MySQL is best open source RDBMS that one can leverage to build high performance applications. At times you may have to take help of other search engines like Sphinx in support, but that's when data volume is too high and you need free text search onto it. In nutshell, yes, MySQL is the good solution for website, however, it also depends on the one who is implementing it.