We plan to move our Piwik database from our dedicated servers to Amazon AWS.
Our piwik database handles 1 site with more than 1,1M pages daily and 23GB data.
I have not found documentation about installing and scaling Piwik into AWS so I thought it would be interesting to ask questions here and give my feedback as the project is going forward.
My first questions:
- EBS or RDS ?
- MyISAM or Innodb ? (Currently on MyISAM)
- Do you guys looked at DynamoDB ? (Seems nice to scale analytics)
- Apache2 or nginx ? (Currently on Apache2)
- EC2 Instance type ? (Extra Large Instance seems fine)
- Any feedback ?