Can a MySQL slave be a master at the same time?
Solution 1:
The binlog on DB2
wasn't updating the slave updates. To daisy chain the replication, one must set log-slave-updates
in my.conf.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates
Solution 2:
Yes, it is possible :) This is called "Master with Relay Slave" replication and there a lot of documents about it on the net.
I'd recommend you to take a look at the official documentation here.
Btw, also take a look at these slides. They've some hints about replication topologies.
Hope this helps.
Solution 3:
yes - you can daisy-chain mysql servers, you can even make a circular replication with two or more machines in it. just remember to enable binloging on slave that also acts as master.