Hello All,

I am new to mysql.

I am building a site based on mysql. The database design mainly consist of 3 tables which will store billions of rows ( terabyte size ). These table are of "heavy write /low read" types.

I have following queries.

1. Which Version of Mysql shd be used ?
2. DB Design - Table design recommendations ?
3. Performance strategies ? Partitioning ?

Please let me know.

Thanks in advance.