clickhouse-mysql-data-reader icon indicating copy to clipboard operation
clickhouse-mysql-data-reader copied to clipboard
verified publisher icon Altinity

Connection via proxysql

Open shafiev opened this issue 5 years ago • 6 comments

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

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

shafiev avatar Apr 17 '20 09:04 shafiev

What for?

sunsingerus avatar Apr 17 '20 10:04 sunsingerus

What for?

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

shafiev avatar Apr 17 '20 10:04 shafiev

@sunsingerus Please explain what you don't understand ?

shafiev avatar May 14 '20 15:05 shafiev

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.

sunsingerus avatar May 14 '20 15:05 sunsingerus

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

shafiev avatar May 15 '20 14:05 shafiev

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.

sv3t0sl4v avatar Jan 14 '21 09:01 sv3t0sl4v