Connection via proxysql

[shafiev]

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

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

[sunsingerus]

What for?

[shafiev]

What for?

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

[shafiev]

@sunsingerus Please explain what you don't understand ?

[sunsingerus]

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.

[shafiev]

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

[sv3t0sl4v]

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.