MySQL replikace Master <-> Master

[Jan Jelinek]

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.


-- 
S pozdravem / With best regards
Jan Jelinek
Tel: +420 608 313 618
mailto:jan.jelinek na jeje.cz
ICQ:335-952-353