Why hundreds of databases? One for each stackexchange site?
Two per site - one for main Q&A, one for its meta.
Re:Stack Overflow: How We Do Deployment
by nickpsecurity on Tuesday May 03, 2016 @09:03PM
(#11625459)
You couldn't do one with some different tables? What was justification for both separate DB's and the Q&D/meta split? Just curious.
Re:Stack Overflow: How We Do Deployment
by Nick-Craver on Tuesday May 03, 2016 @09:34PM
(#11625565)
If you did different tables, that's even more complicated by making every query dynamic. It also makes backups, etc. far more complicated as well. Multiple databases is simply the simplest solution for multiple things that need a database with the same schema :)
Re:Stack Overflow: How We Do Deployment
by nickpsecurity on Tuesday May 03, 2016 @10:21PM
(#11625720)
Appreciate the tip.
As for backups: absolutely. We handle this independently though. We do full backups every night as well as T-logs every 15 minutes. If I had to restore every database we had to a very specific point in time or just before a migration command was run: we have T-logs to do that going back 4 days at all times.
I'm sure there are good solutions for single database applications way more fully featured than our approach, they just do little to solve any problems we actually run into.