I have knowledge of Oracle and SQL server databases. I have no prior experience with MySQL.

We are developing a web portal to be used by customers all over USA. We want the data to be partitioned by state, year (for archiving) at the minimum. Database schema may be fairly simple with less than 2 dozen tables, but we expect a lot of records per user every year. We want the user to write records to appropriate partition after logging...