The fundraising production database has been growing at very roughly 50% per year, and is currently about 1.6. The data partition on our database machines ranges from 3.6T to 5.2T. frdev1001 is approaching capacity fairly quickly since it hosts a live replica of the civi/drupal/fredge/pgehres/faulkner/smashpig database (~1.6TB) plus several dev databases (~970GB). We need to start planning for a refactor of some kind.
Current 2020-06-29 database footprint:
| smashpig| 2G |
| geonames | 6G |
| fredge | 39G |
| drupal | 56G |
| pgehres | 293G |
| faulkner | 354G |
| civicrm | 820G |
Rough growth numbers for the civicrm database are here https://docs.google.com/spreadsheets/d/1FqQtn4XnXBnAIH8_FjFEp0mDty5RD85gJvWBh2xXyyY/edit?usp=sharing
Data partition (/srv) capacity varies by server according to when we bought them:
| host| /srv | purchase | dc | notes |
| frdb1001 | 3.6T | 2016-05-13 | eqiad | standard civi/drupal db|
| frdb1002 | 3.6T | 2017-02-24 | eqiad | standard civi/drupal db (master) |
| frdb2001 | 5.2T | ? | codfw | standard civi/drupal db |
| frdb2002 | 5.2T | 2019-12-03 | codfw | standard civi/drupal db |
| frdev1001 | 3.6T | 2017-02-24 | eqiad | dev database (eqiad, also includes civi etc)
| frdb1003 | 5.2T | 2019-11-01 | eqiad| analytics (also includes civi etc) |