[MXS-1197] ERROR 1045 even if a master is running Created: 2017-03-21 Updated: 2017-04-03 Resolved: 2017-04-03 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | 2.1.0 |
| Fix Version/s: | 2.1.1 |
| Type: | Bug | Priority: | Major |
| Reporter: | Fabrizio | Assignee: | markus makela |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
ubuntu 16.04 with mariadb 10.0.29 |
||
| Sprint: | 2017-31 |
| Description |
|
I have two server in master-slave replication. In this situation I have no high-availability. |
| Comments |
| Comment by markus makela [ 2017-03-27 ] |
|
Did the output of maxadmin list servers show any server as the master or does the log file have a state change from slave to master? |
| Comment by Fabrizio [ 2017-03-27 ] |
|
I had a switch from slave to master: |
| Comment by markus makela [ 2017-03-27 ] |
|
It seems the replication between the two servers is broken and MaxScale only sees two standalone servers. Does the correct server get the master status once replication is working again? |
| Comment by Fabrizio [ 2017-03-27 ] |
|
Yes, the replication was broken but the replication-manager elected a master and it worked correctly. |
| Comment by markus makela [ 2017-03-27 ] |
|
In this case, you want to enable the new features added in the 2.1.1 version of MaxScale that handle this situation. Add detect_standalone_master=true to the mysqlmon configuration to enable the new features described here: https://mariadb.com/kb/en/mariadb-enterprise/6324/#detect_standalone_master This should allow MaxScale to detect that replication-manager has performed a failover. |
| Comment by Fabrizio [ 2017-03-27 ] |
|
Thank you, I was not aware about this feature. |
| Comment by markus makela [ 2017-04-03 ] |
|
As this is normal behavior with the default settings, I'll close this as Not a Bug. If you find any problems with the new features, please open a different issue for those. |