I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of understanding on the matter but my ultimate goal is to setup another slave feeding off the current slave to then point the two together for a master-master relationship.
My problem is that although on the slave I can insert a record and the master replication position (on the slave) will change, it will not change as a result of slave activity on the same database. Will the slave not dump activity into both logs? If i point the secondary slave to relay logs what are my options down the line?
Hope that makes sense.
my my.ini setup on the slave is as such, a unique server id and hostname are also set:
binlog-do-db=our_database binlog-ignore-db=mysql binlog-ignore-db=test replicate-do-db=our_database