SuperDennis

Hello, I think of a big project, which gonna take much load on sever resources and bandwidth. It should work with huge MySQL database of different webpages (maybe about 20 million, I hope MySQL can handle such amount of records). But I will need to share the requests to the database between several servers I think, because one single server won't be able to handle such a load. I wonder how big projects like Google or Archive.org are doing this? I thought of primitive method, which is like follows: [*]The MySQL database is located on an independent standalone server. [*]The MySQL database table contains a field, say, "server", with particular server name, for which the record is allocated for processing. [*]Each server connects MySQL server and works ONLY with records, which are allocated to that server (by looking into "server" field in that table). I feel like this is a noob method, but I would like to know your opinion, and maybe the ways you see how this can be implemented in more optimized and clever form. Will be happy for any tip. Thanks, Dennis.