We are starting new project in scale of 3,000,000 of users and 60,000,000 records yearly.
there will be complex queries with join on tables to generate reports and/or check users history and limits while creating new record, we are currently on Yii2 and MySQL database,
but there is concern about MySQL performance and we have no clue how much MySQL is reliable in this scale of data.
We hope some experienced guy can give us advice about this.
Unfortunately none of your suggested solution is not available for us, since we live in Iran and unfair US goverment sanctions prevent American companies to sell service to Iran event start-up companies like us.