Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Connection via proxysql #179

Open
shafiev opened this issue Apr 17, 2020 · 6 comments
Open

Connection via proxysql #179

shafiev opened this issue Apr 17, 2020 · 6 comments
Labels
question unclear Issue does not contain any clear explanation of the situation or somethins like this

Comments

@shafiev
Copy link

shafiev commented Apr 17, 2020

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

clickhouse ---> proxysql ---> mysql master 1
@sunsingerus
Copy link
Collaborator

sunsingerus commented Apr 17, 2020 •
edited
Loading

What for?

@sunsingerus sunsingerus added question unclear Issue does not contain any clear explanation of the situation or somethins like this labels Apr 17, 2020
@shafiev
Copy link
Author

shafiev commented Apr 17, 2020 •
edited
Loading

What for?

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

@shafiev
Copy link
Author

shafiev commented May 14, 2020

@sunsingerus Please explain what you don't understand ?

@sunsingerus
Copy link
Collaborator

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
Copy link
Author

shafiev commented May 15, 2020

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

@sv3t0sl4v
Copy link

sv3t0sl4v commented Jan 14, 2021 •
edited
Loading

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question unclear Issue does not contain any clear explanation of the situation or somethins like this
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@shafiev @sunsingerus @sv3t0sl4v