after master recovery the host don't get his reader role

[jfdusar]

This is happening with mysql-mmm 2.0.5

We have a 4 node config (master-master-slave-slave). When we shutdown the active master by stopping mysql for about 10 seconds. The writer role is switched to the other master and the reader role to any other node. When mysql is getting back, it recover the writer role, but the reader role don't come back.

Since the reader role is balanced I expected that the role are distributed equaly on each node. I think that was OK on MMM1.

If needed I can provide logs.

[Pascal Hofmann (pascalhofmann)]

You are using the "preferred host" feature, right?

[jfdusar (jfdusar)]

no since the reader role is in "balanced" mode. It's really the reader role that is our problem here ... We really want it to be balanced among all the available hosts.

[Pascal Hofmann (pascalhofmann)]

Why did MMM switch the writer role back to master1? It should only do this if master1 is specified as preferred host in the config.

[Pascal Hofmann (pascalhofmann)]

Should be fixed in 2.0.6. See http://mysql-mmm.org/

[jfdusar (jfdusar)]

My problem is not the writer, but the reader role that don't comeback to master1. And yes in my config master1 is prefered for writer role.
The fact is that I need to be sure that the reader roles are well balanced among the online nodes. Can you point me the fix that you did to fix this.

Thanks

[Pascal Hofmann (pascalhofmann)]

See http://bazaar.launchpad.net/~mysql-mmm-core/mysql-mmm/trunk-2.x/revision/84
( released MMM 2.0.6 which contains this fix http://mysql-mmm.org/downloads)