Is replication the right tool to do this kind of work? Or there is a
better design to handle such problems.
I have read something that it is possible only by partitioning the table in the older versions of MySQL.
Is there any advancement in latest versions of MySQL ( 5.6 or 5.7 ) for such kind of replication.
Even a pointer to the right tutorial/document would be helpful.