SQL is a language, MySQL is a database implementation (and arguably a pretty crappy one). There is nothing about SQL that makes it so that it can't operate at 'webscale'. Oddly enough, Facebook and Google have both made MySQL work at 'webscale'. Most 'webscale' databases rely on keeping data in memory, you'll see equally impressive performance improvments in MySQL if you run it in a ramdisk.