MySQL replication, master->slave->slave

Bill Campbell linux-sxs at celestial.com
Thu Dec 27 18:09:51 PST 2007


I am trying to do a system in which our internal MySQL server
replicates to another server that's publically accessible, then
that server in turn replicates to another customer's machine.

I have the replication going between my machines.  I have
configured our external machine to replicate with the binary
logging, a different server-id (2 with the internal 1), and have
done the appropriate command to GRANT replication to the
customer's machine, the same as was used on our internal master,
with only the host name and passwords changed.

The main problem is that the mysql instance on the slave machine
isn't updating its binary file as updates come into it, so its
slave machine isn't getting any changes.  I haven't been able to
figure out why this machine creates the first binary log file on
startup, but never updates it.

	mysql-4.1.18 (OpenPKG version)

The slave server is running SLES9.

Bill
--
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

Those who profess to favor freedom, and yet depreciate agitation, are
men who want rain without thunder and lightning.  They want the ocean
without the roar of its many waters.  -- Frederick Douglass



More information about the Linux-users mailing list