What is the last Mysql Version supported in REDHAT 6?
Here's a list of supported platforms: http://www.mysql.com/support/supportedplatforms/database.html.

The MySQL yum repo is detailed here: http://dev.mysql.com/downloads/repo/ - That has binaries for MySQL 5.5, 5.6 and 5.7.