You can always partition your MySQL database (maybe on date created, dunno) so that performance is still okay.
If you are looking for sharding, not sure if MySQL supports that out of the box. But programming frameworks (e.g. Hibernate) supports sharding on application level.