If scaling is not an issue, I highly recommend using MySQL. But of course we need to understand when scaling becomes an issue. If you are using PHP or Python with a MySQL database with more than 100M rows and more than 10 GB of data, scaling becomes a problem. You can try optimizing MyISAM or Innodb tables, but you won’t see more than a 30% performance gain in most cases. If you have 470M rows with 200 GB of data in a MyISAM table, you are probably at the limits of what MySQL can do for you (unless you shard and use master-slave tables).
In terms of scaling, NoSQL is great. It’s not as easy or intuitive as MySQL, but MongoDB has pretty good documentation, and a smaller learning curve than most NoSQL databases.