I'm just thinking about how famous internet services like facebook or twitter manage fast growing databases.
Which could be a solution for this kind of problem?
What about ids ? I read there is a limit in MySQL - 18446744073709551615 - in unsigned bigint... how would you generate and manage a bigger value ?
Just a theoric problem, but i'm curious about a possible solution.