Building a scalable website
I am working on the design of a social media website which is expected to have around 500K active users. I am starting from scratch at the moment and I've some questions.

1.I understand that the scalability problems with relational databases (such as MySQL) is mainly due to the fact that they are ACID compliant. Is it possible to know the rough size of the database where scalability problems will start to arise in MySQL?

2.I was thinking of going with Amazon's DynamoDB. This should solve the problem of database but there is also intensive computation (recommendation engine) so what solution should I use for that ?


Building a scalable website
===

I am working on the design of a social media website which is expected to have around 500K active users. I am starting from scratch at the moment and I've some questions.

1.I understand that the scalability problems with relational databases (such as MySQL) is mainly due to the fact that they are ACID compliant. Is it possible to know the rough size of the database where scalability problems will start to arise in MySQL?

2.I was thinking of going with Amazon's DynamoDB. This should solve the problem of database but there is also intensive computation (recommendation engine) so what solution should I use for that ?

