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
