I'm completely new to buying a database hosting and I would greatly appreciate your opinion about the following situation. I just created an App and I want to go live this weekend. I want to be prepared as good as possible so I will write some statistics of the database usage I think to see every 24 hours.
- 20 000 000 inserts into a table which contains 1 bigint, 7 ints and 1 date. - 5 000 000 updates on above table - 10 000 000 inserts into mapping table 1 bigint 1 int - 2 000 000 inserts into table with 3 ints - 5 000 000 select queries with WHERE pk reference of first table described above
I will use the MySQL 5.5 database with all InnoDB tables. At the moment I am thinking about buying a dedicated server with these stats:
Intel Xeon E3-1220LV2 2.3GHz 100 Mbps Uplink 4 GB DDR3 Memory 500 GB RAID-1 Drives 10 TB Bandwidth Up to 5 Dedicated IPs
For a price of $140 dollar a month. What do you think, will this be enough? Would it be overkill? You know a better hosting? At the moment I am on a shared webhost ($12 a month) and I get a fifth of the numbers above, but the shared database is really not optimized for innoDB.