Question
Database choice for large data volume?
I'm about to start a new project which should have a rather large database.
The number of tables will not be large (<15), majority of data (99%) will be contained in one big table, which is almost insert/read only (no updates).
The estimated amount of data in that one table is going to grow at 500.000 records a day, and we should keep at least 1 year of them to be able to do various reports.
There needs to be (read-only) replicated database as a backup/failover, and maybe for offloading reports in peak time.
I don't have first hand experience with that large databases, so I'm asking the ones that have which DB is the best choice in this situation. I know that Oracle is the safe bet, but am more interested if anyone have experience with Postgresql or Mysql with similar setup.