Open sharad-jha opened 6 years ago
Topology discovered fine by 2.1.15 :
Binlog servers are- 10.41.191.61 10.41.191.62
In 3.1.12 , Orch displays a disjointed set. Seems its unable to discover the linkage between Binlog-server and Master:
Orch didnt discover the other remaining (10.41.191.62) binlog server at all. When trying to discover it through CLI, we get following debug messages:
[root@orch-app-1 orchestrator-fix-analysis-query]# bin/orchestrator -c discover -i 10.41.191.62:3306 --debug
2018-09-30 05:38:03 INFO starting orchestrator, version: 3.0.12
2018-09-30 05:38:03 DEBUG Hostname unresolved yet: 10.41.191.62
2018-09-30 05:38:03 DEBUG Cache hostname resolve 10.41.191.62 as 10.41.191.62
2018-09-30 05:38:03 ERROR Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
2018-09-30 05:38:03 ERROR Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR ContinuousRegistration: RegisterNode failed: Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 INFO verifyCert requested, client certificates will be verified
2018-09-30 05:38:03 ERROR TLS requested but server does not support TLS
2018-09-30 05:38:03 ERROR ReadTopologyInstance(10.41.191.62:3306) show variables like 'maxscale%': TLS requested but server does not support TLS
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 ERROR Error 1046: No database selected
2018-09-30 05:38:03 FATAL TLS requested but server does not support TLS
I'm merely curious: which version of MaxScale are you using?
I have not touched MaxScale binlog servers in almost three years, and my ability to continue supporting them is almost nonexistent. At the time, MaxScale BLS was extremely sensitive to queries it was not familiar with, to the point of whitespace.
Moreover, I'm considering dropping support for MaxScale binlog servers altogether. See https://github.com/github/orchestrator/issues/552
Friendly ping.
My genuine apologies for this extremely late reply.
At the time of posting this issue, i wasn't aware of orch's discontinuity in supporting binlog server. However i do realize it now and it (#552) makes sense :)
I tried with this poc with Maxscale version 2.2 and flipping between : Orch 2.1.15 & 3.1.12
Tried to play around with maxscale 1.4.x aswell, but got hit with other burning issues related to VIP & network challenges.
Although i do see it picking up pace again in next few days.
Thank you for getting back!
Cluster topology : 1 Master having a number of direct slaves , including 2 binlog servers.
Binlog servers are not being discovered by orchestrator. Hence, cluster becomes disjointed when these binlog servers are made to be intermediate masters for slaves.
This is being observed in the branch: tree/fix-analysis-query (#632 ). Although seems working fine on version 2.1.5.
On orch version 2.1.5: Maxscale binlog-sever- 10.41.191.61
tree/fix-analysis-query (#632 ) :