master/slave replication error

[Miguel Angel Nieto]

Hello,

I have mmm 2.0.10 with this configuration:

Using Exclusive (10.100.1.10)
Master (db1 10.100.1.1) - Master 2 (db2 10.100.1.2)

Using Balanced (10.100.1.11 10.100.1.12)
Slave 1 (db3 10.100.1.3) - Slave 2 (db4 10.100.1.4)

Slave 1:

*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.100.1.1
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000009
Read_Master_Log_Pos: 98
Relay_Log_File: mysqld-relay-bin.000005
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000009
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 98
Relay_Log_Space: 235
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)

If I shutdown Master 1, the writer role goes to Master 2. But slaves
gets down with this message:

2009/12/03 12:19:13 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:18 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:22 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:26 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:48 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:50 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:54 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:19:59 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status
2009/12/03 12:20:02 FATAL Failed to change master to 'db2': ERROR:
Invalid master host in show slave status

How can I solve this to get auto balanced slaves?

Thank you.

[Pascal Hofmann]

Hi Miguel,

could you send the configuration files for mmm from one of the slaves (don't forget to remove passwords ;-))

Regards

Pascal

[Miguel Angel Nieto]

Hi Pasca,

I solved the problem:

MMM:/etc/mysql-mmm# mmm_control show
db1(10.100.1.1 ) master/ONLINE. Roles:
db2(10.100.1.2) master/ONLINE. Roles: writer(10.100.1.10)
db3(10.100.1.3) slave/REPLICATION_FAIL. Roles:
db4(10.100.1.4) slave/ONLINE. Roles: reader(10.100.1.11)

In mmm_common.conf, the ip 10.100.1.1 had a lot of blank spaces at the
end of the line :/

I removed them and now it works perfect :)

Thank you.

2009/12/3 Pascal Hofmann <ma...@pascalhofmann.de>:

> --
>
> You received this message because you are subscribed to the Google Groups "MySQL Multi Master Manager Development" group.
> To post to this group, send email to mmm-...@googlegroups.com.
> To unsubscribe from this group, send email to mmm-devel+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/mmm-devel?hl=en.
>
>
>



--
Lo que haría sería hacerme pasar por sordomudo y así no tendría que
hablar. Si querían decirme algo, tendrían que escribirlo en un
papelito y enseñármelo. Al final se hartarían y ya no tendría que
hablar el resto de mi vida.

[Arjen Lentz]

Hi Miguel, Pascal

On 03/12/2009, at 10:11 PM, Miguel Angel Nieto wrote:
> I solved the problem:
>
> MMM:/etc/mysql-mmm# mmm_control show
> db1(10.100.1.1 ) master/ONLINE. Roles:
>

> In mmm_common.conf, the ip 10.100.1.1 had a lot of blank spaces at the
> end of the line :/
>
> I removed them and now it works perfect :)

Well that'd be a config file parsing bug.


Cheers,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org