title: EC2 server, Would a Micro Instance be enough?
body: <p>I've been developing a website that will import ~12million lines of code per hour (~1GB/Data) into a mySQL database. After looking at different VPS' and then amazon ec2 I was thinking of going with the most cost effective solution.</p>
  
  <p>As for visitors to the website there should only be ~300-600k page views a month(max of 15GB of Bandwidth), evenly spreadout through the day.</p>
  
  <p>When I import the data I use "IN FILE" and it imports ~200-350k lines at time and only takes ~1-3seconds. The imports are ran via a Cron Job and will run 1 every minute (that's ~1400 times a day).</p>
  
  <p>Would it be better to have a VPS, or go with Amazon EC2? And if I go with Amazon EC2 would the CPU spikes be too much for a micro or even a small (would I need a High-CPU Medium Instance)?</p>
  
  <p>If anyone could share some insight on how much CPU mySQL would actually pull in those ~1-3seconds or how much a micro Instance is allowed in CPU time.</p>
  
  <p>If I go with the VPS route I will be getting the S1 package from <a href="http://x10vps.com/self-managed-vps.php" rel="nofollow">http://x10vps.com/self-managed-vps.php</a> and upgrade to S3 if needed.</p>