MySQL replikace Master <-> Master

[Filip Krejčí]

A mate nastaveno sync_binlog=1 ?

Pokud ne pri vypadku mastera se muze stat ze odesle slavovi pozici v 
binlogu ale nestihne to jeste flushnout u sebe na disk.

Pak by se to vysvetlovalo.

Filip Krejci

Jan Jelinek napsal(a):
> Filip Krejčí wrote:
>> U ktere verze ?
>> Podarilo se lokalizovat co to zpusobuje ?
> 
> verze 4.1.20
> 
> 060807 13:07:14 [Note] Slave SQL thread initialized, starting 
> replication in log 'mysql-bin.000024' at position 449593045, relay log 
> './apollon-relay-bin.000019' position: 4
> 060807 13:07:14 [Note] Slave I/O thread: connected to master 
> 'replikator na 192.168.1.1:3306',  replication started in log 
> 'mysql-bin.000024' at position 449593045
> 060807 13:07:14 [ERROR] Error reading packet from server: Client 
> requested master to start replication from impossible position 
> (server_errno=1236)
> 060807 13:07:14 [ERROR] Got fatal error 1236: 'Client requested master 
> to start replication from impossible position' from master when reading 
> data from binary log
> 060807 13:07:14 [ERROR] Slave I/O thread exiting, read up to log 
> 'mysql-bin.000024', position 449593045
> 
> ls -l mysql-bin.000024
> -rw-rw----  1 mysql mysql 449592929 Jun 22 10:14 mysql-bin.000024
> 
> Je mi zahodou proc se rozhodl cist nekde kde nema.
> 
>> Jan Jelinek napsal(a):
>>> Petr Klima wrote:
>>>> Nejsem si jist, jestli je to v dokumentaci nekde napsano, ale VIM, 
>>>> ze to
>>>> nefunguje. Tedy, ve verzich 5.x by to fungovat melo, aspon dle
>>>> dokumentace, ale to nemam vyzkouseno. Ve verzi 4.x mi to nefungovalo a
>>>> nebyl jsem sam...
>>>
>>> Provozuji dva stroje s mysql a jedou replikace master <> master.
>>> Funguje to, ale jen na dobre slovo. Neustale se mi rozpadaji 
>>> replikace a musim to rucne premlouvat k funkci.
> 
>