MySQL - Recommendation needed

MySQL & MariaDB Other MySQL® Questions
1

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.