4 ms·
> to route to different sql clusters That's called sharding and is pretty widely used nowadays. There is even readily available middleware that handles this fo
by 411111111111111 6y ago
> to route to different sql clusters
That's called sharding and is pretty widely used nowadays. There is even readily available middleware that handles this for you, so no need to put it into the backend.
- yellowapple 6y agoKeep in mind this is more than a decade ago. Sharding was almost certainly state-of-the-art and exotic back then (hell, it's arguably pretty unusual in the wild even today, even if a lot more mature of a concept).
- 411111111111111 6y agoOh, of course! I did not wish to come of as arrogant. I just wanted to add the term (for easier googling if someone is interested) and a note that it's no longer necessary to modify your api to use that strategy.
- dhosek 6y agoIIRC, this was actually a step beyond the sharding that MS SQL supported. They were really the first people to do big data.