List:Replication« Previous MessageNext Message »
From:Hartleigh Burton Date:November 12 2007 5:43am
Subject:Re: Doble entry in mysql salve status.
View as plain text  
I am running 5.0.45-community in FreeBSD x86_64 for both master and  
slave.



On 12/11/2007, at 3:31 PM, Joseph Job wrote:

> Hi,
>
> What about running replciation with
> 5.0.21 as Master as
> Master and 5.0.45-community-log MySQL Community Edition (GPL) as  
> Slave,
> any update regarding that...
> Thanks,Joseph
>
>
> At 10:34 AM 11/12/2007, Hartleigh Burton wrote:
>
>> Mine does that also... never understood exactly why it happens but  
>> does not appear to cause any issues. I have been running  
>> replication like that for 6 months now.
>>
>>
>>
>> On 12/11/2007, at 2:59 PM, Joseph Job wrote:
>>
>>> Hi,
>>>
>>> I have one mysql replication setup with mysql
>>> 5.0.21 as Master
>>> and  5.0.45-community-log MySQL Community Edition (GPL) as Slave.
>>>
>>>
>>> In my /etc/my.cnf at Slave machine, I have mentioned the  
>>> replication settings in the following way...
>>>
>>> replicate-do-table  = usdb.processing_jobs
>>> replicate-do-table  = usdb.node_file_xfer
>>>
>>> It is working properly, but in the Slave machine, I can see two  
>>> replication entries for easch table.
>>>
>>> Slave_IO_State: Waiting for master to send event
>>>                 Master_Host: 192.168.12.202
>>>                 Master_User: replcl
>>>                 Master_Port: 8842
>>>               Connect_Retry: 60
>>>             Master_Log_File: efusprog-bin.000001
>>>         Read_Master_Log_Pos: 3313079
>>>              Relay_Log_File: db3-cok-relay-bin.000325
>>>               Relay_Log_Pos: 238
>>>       Relay_Master_Log_File: efusprog-bin.000001
>>>            Slave_IO_Running: Yes
>>>           Slave_SQL_Running: Yes
>>>             Replicate_Do_DB:
>>>         Replicate_Ignore_DB:
>>>          Replicate_Do_Table:  
>>> usdb.processing_jobs,usdb.processing_jobs,usdb.node_file_xfer,usdb.n 
>>> ode_file_xfer
>>>      Replicate_Ignore_Table:
>>>     Replicate_Wild_Do_Table:
>>> Replicate_Wild_Ignore_Table:
>>>                  Last_Errno: 0
>>>                  Last_Error:
>>>                Skip_Counter: 0
>>>         Exec_Master_Log_Pos: 3313079
>>>             Relay_Log_Space: 238
>>>             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
>>>
>>>
>>> See the Replicate_Do_Table :, the tables are repeating twice.
>>>
>>> Is it a bug in Mysql ?
>>>
>>> I have tried the same in different machines, every time, I am  
>>> getting the same message.
>>>
>>> Joseph
>>>
>>>
>>> JOSEPH JOB
>>> Spectrum Softtˆ,¨l³ÿÿÿÿlZb ech
> Solutions(P)Ltd.
>>> MahaKavi G Road,
>>> Karikkamuri Cross Road
>>> Kochi-682011
>>> 0484-4082000
>>> joseph@stripped
>>> Visit at www.spectrum.net.in
>>>
>>>
>>> -- 
>>> MySQL Replication Mailing List
>>> For list archives: http://lists.mysql.com/replication
>>> To unsubscribe:    http://lists.mysql.com/replication? 
>>> unsub=hburton@stripped


Thread
Doble entry in mysql salve status.Joseph Job12 Nov
Re: Doble entry in mysql salve status.Joseph Job12 Nov
Re: Doble entry in mysql salve status.Hartleigh Burton12 Nov