I have a table that I'm pretty sure in the very near future (within a year) will reach 14 million rows, and I'm trying to scale out my web app before hitting any bottleneck. I'm in dilemma whether I should use sharding or replication?
What is a good strategy for my web app?
Table structure in which I'll have millions of rows:
id mediumint(8) unsigned NO NULL auto_increment user_id smallint(5) unsigned NO NULL jqci_id mediumint(8) unsigned NO NULL selected_answer enum('a','b','c','d') NO NULL