Sharding is possible on same node with different db?

Question

MySQL (EN)

Lachhman Pandey

Sharding is possible on same node with different db?

#english #programming #sql

0

21.04.2024

3 ответов

7 просмотров

Lachhman Pandey Автор вопроса

Какой-то Хмырь
sharding is an external concept. mysql doesn't kno...

How to implement externally any documentation

0

17 дней назад

Какой-то Хмырь

Lachhman Pandey
How to implement externally any documentation

make your application use several connections based on some parameter or value. use a proxy application, that will do it for you. you still have to write, how to select replica, based on some input value. so your application connects to proxy. proxy parses query amd decides "hey, this id is 625816, which should be found on node2, redirect there" if you use second approach - google docs of proxy of your choice. if you use first - no docs needed it is made with an if statement) just pick the right sharding key

0

17 дней назад

Какой-то Хмырь · Accepted Answer

Какой-то Хмырь

sharding is an external concept. mysql doesn't know anything about it. and there is no point in having different shards on same server. whole point of sharding is load distribution across several servers. but theoretically - why not?)

0

17 дней назад

169 похожих чатов

Sharding is possible on same node with different db?

3 ответов

Похожие вопросы