3 ms·
I'd be curious to know what your company does which generates this volume of data (if you can disclose), what database you are using and how you are planning to
by n0ts0gr33n 4y ago
I'd be curious to know what your company does which generates this volume of data (if you can disclose), what database you are using and how you are planning to solve this issue.
- cogman10 4y agoFinance. MSSQL. There are multiple plans on how to fix this problem but they all end up boiling down to carving out domains and their owners and trying to pull apart the data from the database. What's been keeping the lights on is "Always On" and read only replicas. New projects aren't adding load to the db and it's simply been a slow going getting stuff split apart. What we've tried (and failed at) is sharding the data. The main issue we have is a bunch of systems reading directly from the db for common records rather than hitting other services. That means any change in structure requires a bunch of system wide updates.
- deleted 4y ago[deleted]