percona-discussion team mailing list archive

[mysqldavid <mysqldavid@xxxxxxxxx>]

Hi Vadim,

Thanks for pointing me to this document!  This is very good
documentation.  I was able to successfully test this on 5.0.75-b12-hp.


-David

On Tue, Feb 17, 2009 at 3:57 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
> David,
>
> I think you did not fully clean up slave before setup mirroring.
>
> Please check procedure here
> http://www.percona.com/docs/wiki/howto:mirror_binlog
>
> If bug still exists - please create new bug report and I'll take look.
>
> mysqldavid wrote:
>> Hello Vadim,
>>
>> I got the configure parameter by running mysqlbug.  I am not quite
>> sure how the DBA before me selected the parameters for the configure
>> script.  So I took your advice and removed those 2 parameters (I read
>> the doc, I dont think we need it anyways).   I was able to
>> successfully build this for version 5.0.67 hp and 5.0.75 hp.
>> However, the replication broke as soon as I shutdown the slave and
>> restarted it.  Here is the log:
>>
>>
>> 090217 22:50:15 [Note] Slave SQL thread initialized, starting
>> replication in log 'mysql-bin.000008' at position 98, relay log
>> '/var/lib/mysql/mysql5.000001' position: 4
>> 090217 22:50:15 [Note] Slave I/O thread: connected to master
>> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
>> 'mysql-bin.000008' at position 98
>> 090217 22:50:15 [Note] createReplicationMule
>> 090217 22:50:15 [Note] Binglog size 98
>> 090217 22:50:15 [Note] ReplicationMule: RELAY_MATCH_MULE.
>> 090217 22:50:15 [Note]  RELAY_MATCH_MULE event 15
>> 090217 22:50:36 [Note] Slave I/O thread killed while reading event
>> 090217 22:50:36 [Note] Slave I/O thread exiting, read up to log
>> 'mysql-bin.000008', position 98
>> 090217 22:50:36 [Note] Error reading relay log event: slave SQL thread
>> was killed
>> 090217 22:50:38 [Note] Slave SQL thread initialized, starting
>> replication in log 'mysql-bin.000008' at position 98, relay log
>> '/var/lib/mysql/mysql5.000002' position: 235
>> 090217 22:50:38 [Note] Slave I/O thread: connected to master
>> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
>> 'mysql-bin.000008' at position 98
>> 090217 22:50:38 [Note] createReplicationMule
>> 090217 22:50:38 [Note] Binglog size 98
>> 090217 22:50:38 [Note] ReplicationMule: RELAY_MATCH_MULE.
>> 090217 22:50:38 [Note]  RELAY_MATCH_MULE event 15
>> 090217 22:54:42 [Note] Slave I/O thread killed while reading event
>> 090217 22:54:42 [Note] Slave I/O thread exiting, read up to log
>> 'mysql-bin.000013', position 85431178
>> 090217 22:54:42 [Note] Error reading relay log event: slave SQL thread
>> was killed
>> 090217 22:54:46 [Note] Slave SQL thread initialized, starting
>> replication in log 'mysql-bin.000013' at position 85431178, relay log
>> '/var/lib/mysql/mysql5.000018' position: 85431315
>> 090217 22:54:46 [Note] Slave I/O thread: connected to master
>> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
>> 'mysql-bin.000013' at position 85431178
>> 090217 22:54:46 [Note] createReplicationMule
>> 090217 22:54:46 [Note] Binglog size 85431178
>> 090217 22:54:46 [Note] ReplicationMule: RELAY_MATCH_MULE.
>> 090217 22:54:46 [Note]  RELAY_MATCH_MULE event 15
>> 090217 23:06:10 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Normal shutdown
>>
>> 090217 23:06:10 [Note] Slave I/O thread killed while reading event
>> 090217 23:06:10 [Note] Slave I/O thread exiting, read up to log
>> 'mysql-bin.000013', position 85431178
>> 090217 23:06:10 [Note] Error reading relay log event: slave SQL thread
>> was killed
>> 090217 23:06:10  InnoDB: Starting shutdown...
>> 090217 23:06:12  InnoDB: Shutdown completed; log sequence number 0 2646942385
>> 090217 23:06:12 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Shutdown complete
>>
>> 090217 23:06:15  InnoDB: Started; log sequence number 0 2646942385
>> 090217 23:06:15 [Note] /opt/mysql-5.0.75.5/lib/mysqld: ready for connections.
>> Version: '5.0.75-percona-b12-hp-log'  socket:
>> '/var/run/mysqld/mysqld.sock'  port: 3306  with_mirror_binlog
>> 090217 23:08:12 [Note] Slave SQL thread initialized, starting
>> replication in log 'mysql-bin.000013' at position 85431178, relay log
>> '/var/lib/mysql/mysql5.000019' position: 235
>> 090217 23:08:12 [Note] Slave I/O thread: connected to master
>> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
>> 'mysql-bin.000013' at position 85431178
>> 090217 23:08:12 [Note] createReplicationMule
>> 090217 23:08:12 [ERROR] Mule
>> binlog(/var/lib/mysql/mysql5/mysql-bin.000014) does not match new
>> relay-binlog(mysql-bin.000013)
>> 090217 23:08:12 [Note] Slave I/O thread exiting, read up to log
>> 'mysql-bin.000013', position 85431178
>>
>>
>> -David
>>
>>
>> On Fri, Feb 13, 2009 at 10:14 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>>> David,
>>>
>>> Ok, I am not sure, but it may not work with
>>> '--with-embedded-server'
>>> '--with-embedded-privilege-control'.
>>>
>>> where did you take that configure line ?
>>>
>>>
>>> mysqldavid wrote:
>>>
>>> --
>>> Vadim Tkachenko, CTO
>>> Percona Inc.
>>> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
>>> MySQL Performance Blog - http://www.mysqlperformanceblog.com
>>> MySQL Consulting http://www.percona.com/
>>>
>>>  Attend the 2009 Percona Performance Conference
>>>  April 22-23 - http://conferences.percona.com/
>>>
>>> --
>>> Incorrect mirrored binary log
>>> https://bugs.launchpad.net/bugs/304296
>>> You received this bug notification because you are a direct subscriber
>>> of the bug.
>>>
>>> Status in Patches for MySQL by Percona: Fix Committed
>>>
>>> Bug description:
>>> I have incorrect mirrored binlog when slave between restarts has no new events
>>>
>>
>
>
> --
> Vadim Tkachenko, CTO
> Percona Inc.
> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
> MySQL Performance Blog - http://www.mysqlperformanceblog.com
> MySQL Consulting http://www.percona.com/
>
>  Attend the 2009 Percona Performance Conference
>  April 22-23 - http://conferences.percona.com/
>
> --
> Incorrect mirrored binary log
> https://bugs.launchpad.net/bugs/304296
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Patches for MySQL by Percona: Fix Committed
>
> Bug description:
> I have incorrect mirrored binlog when slave between restarts has no new events
>

-- 
Incorrect mirrored binary log
https://bugs.launchpad.net/bugs/304296
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Fix Committed

Bug description:
I have incorrect mirrored binlog when slave between restarts has no new events