I have 100 users making requests to the database server simultaneously -> request take around 3 seconds.
What changes should i make to the current database so that to server 10 000 requests simultaneously BUT request should continue to take 3 seconds.
I’ve heard about MySQL Cluster, MySQL Relication, Load Balancing etc but i can’t figure out how to use these techniques to accomplish my task. Can some one help me PLZ since i am new to MySQL. Some clear directives/approaches to solve this problem will prove a great help to me.
Thanks in advance )