I want to know about setting up database like Facebook using MySQL, without any slow down or timout on huge database.
i heard about Read-Only and Read-Write databases. if Facebook is running a Read-Write database, and replicating this Database to 30 miror/replicas so i think that these 30 are also Read-write because they are being in update process. it also place a table lock when updating a line.
Assuming 3000000 users access Facebook and do only login request in a second ,
My question is how MySQL or any other database performs this ?