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.

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

Use MaxScale for read-write separation #18207

Closed
huye opened this issue Oct 23, 2021 · 5 comments
Closed

Use MaxScale for read-write separation #18207

huye opened this issue Oct 23, 2021 · 5 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@huye
Copy link

huye commented Oct 23, 2021

I use the MariaDB database and MaxScale 6.1.3 for read-write separation. However, matomo does not work properly, and SQL syntax errors will be reported. I don't know whether it's not supported or the maxscale setting problem. I hope to get help.

I have tried to use MariaDB directly without MaxScale.

Debian 11
Docker 20.10.5
MaxScale 6.1.3
MariaDB 10.5.10
PHP 8.0
@huye huye added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Oct 23, 2021
@sgiehl
Copy link
Member

sgiehl commented Oct 24, 2021

Hi @huye
Thanks for creating this issue. I'm not familiar with MaxScale, but maybe it limits the SQL syntax in any way so some of our queries don't work anymore.
Maybe you could provide some details about the syntax errors you recieves. Maybe that helps to identify the issue,

@tsteur
Copy link
Member

tsteur commented Oct 25, 2021

@huye MaxScale (or similar) is not supported unfortunately. However, you can configure a reader in Matomo directly and then it should work. See https://matomo.org/faq/how-to-install/faq_35746/

@tsteur tsteur closed this as completed Oct 25, 2021
@tsteur tsteur added answered For when a question was asked and we referred to forum or answered it. and removed Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. labels Oct 25, 2021
@huye
Copy link
Author

huye commented Nov 4, 2021 •
edited

@tsteur I now bypass MaxScale (which is a gateway or middleware) and directly connect to MariaDB. This is not very friendly. MaxScale supports automatic switching of the primary server. Now, when the server fails, I can only switch manually. I guess it's probably because MaxScale doesn't support functions like load file, but I didn't track and debug Matomo.

@tsteur
Copy link
Member

tsteur commented Nov 4, 2021

Maybe check if it can update the DNS automatically when it switches over then the problem would be solved. I don't know if it supports that.

@huye
Copy link
Author

huye commented Jan 30, 2022

I encountered this problem when using matomo. If you want to know the situation, you can install and test this statistical program. If you don't want to deal with it, take it as if I didn't mention it.

https://matomo.org/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tsteur @sgiehl @huye