Relational database doesn't really scale horizontally. So you can either use RAID5/10/50/60 of multiple drives or deal with the drive size later. If you don't need transactions then I would even recommend using NoSQL database (CouchDB, MongoDB etc) because these databases have "sharding" support where your data is being distributed horizontally (across multiple servers/drives).