i have two laptops which both need to synchronise bidirectionally with a central server. all three are running mysql 5.0.
in a two device environment i had both machines configured as master and slave to each other. this works well. However I cannot find a way to make the central server the slave of two masters. Is there any way? conceptually I thought it might be possible to create two different config files with different master-host info in the [mysqld] section and then creating two separate instances of mysql. would this work? perhaps on different ports? or am i completely missing the point and there is an easier solution?
btw I cannot create a chain as i cannot be certain that both laptops are on the lan sufficiently often to make it workable.
thanks for any assistance!
in a two device environment i had both machines configured as master and slave to each other. this works well. However I cannot find a way to make the central server the slave of two masters. Is there any way? conceptually I thought it might be possible to create two different config files with different master-host info in the [mysqld] section and then creating two separate instances of mysql. would this work? perhaps on different ports? or am i completely missing the point and there is an easier solution?
btw I cannot create a chain as i cannot be certain that both laptops are on the lan sufficiently often to make it workable.
thanks for any assistance!