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.
- Which Version of Mysql shd be used ?
- DB Design - Table design recommendations ?
- Performance strategies ? Partitioning ?
Please let me know.
Thanks in advance.