Connection via proxysql

Question

Connection via proxysql

shafiev opened this issue 5 years ago · 6 comments

shafiev commented 5 years ago

Is there way to work through a proxysql ? The standart schema is

clickhouse ---> proxysql ---> mysql master 1

sunsingerus commented 5 years ago

What for?

Answer 1 · 2020-04-17T10:13:40.000Z

What for?

For route for live master if old is dead( classical pair orchestrator + proxysql)

Answer 2 · 2020-05-14T15:35:56.000Z

@sunsingerus Please explain what you don't understand ?

Answer 3 · 2020-05-14T15:54:07.000Z

What exact use case proposed approach is supposed to cover? I am not that familiar with proxysql and have no clear understanding on whether proxysql is capable to proxy mysql log replay from master to slave.

Answer 4 · 2020-05-15T14:01:11.000Z

The case that - need to automatically change to current master to prevent data loss.

Answer 5 · 2021-01-14T09:26:35.000Z

Possibly make each node slave of the remaining one and pump MySQL data to ClickHouse only from self? Interested in that kind of solutions, too.