We have to launch a new service in my company with a big database.
And I currently don't have that much knowledge.
We did a small preview of the service and our biggest table had more than 2 100 000 rows. Our second biggest table had 300 000 rows.
Currently our database if only 15GB but the final one will be at least 75 times bigger.
And no need to say that we need to access to our database very quickly and to run queries quickly as well.
What's your advice about our infrastructure (One big server or several servers) and what database system should we use ?