Cluster or not?

[Robin Draxl]

Hello fellow readers

I'm currently looking for hosting services that offer mysql-cluster architectures. But I'm still wondering IF I really need a cluster.

The problem is, that there will be about 500 users connecting to my webservice. There may be some tables that could be about 20GB in size, if i store all the data in one table. (The content will be nothing more than
PartsNr;UserID;Value;Date)

If I would split the table and create one for every year I would have to use JOINs. If not, the table will kind of explode.

The question is:
If 20 people would select data from this table at the same time - what solution would be better? Splitted tables or one table? Single Server or Cluster?

When is the point reached to switch to a cluster system?

Thanks
Robin

PS: I'm REALLY sorry for the grammar