I need to end up with several MySQL servers replicating into a single instance Tungsten Replicator appears to be the only solution for this. To test this out I am using tungsten-sandbox (http://code.google.com/p/tungsten-toolbox/wiki/TungstenSandbox).
The machine needs to have MySQL Sandbox 3.0.24 running (https://launchpad.net/mysql-sandbox/+download)
Create the directory to host the sandboxes
mkdir $HOME/tsb2
Get the Mysql binaries (I’m using 5.5.19 on a 64bit ubuntu box)
mkdir -p $HOME/opt/mysql
cd $HOME/opt/mysql
tar -xvf mysql-5.5.19-linux2.6-x86_64.tar.gz
mv mysql-5.5.19-linux2.6-x86_64 5.5.19
Download and untar the latest version of Tungsten Replicator and Tungsten Sandbox
From within the tungsten replication dir run
../tungsten-sandbox -n 3 –topology=fan-in –hub=3 -m 5.5.19 -p 7300 -l 12300 -r 10300
where -n is the number of nodes to create and –hub is the node to fan into
Once it has installed
cd $HOME/tsb2
./test_topology
Testing topology fan-in with 3 nodes.
Master nodes: [1 2] – Slave nodes: [3]
# node 3
1 inserted by node #1
2 inserted by node #2
appliedLastSeqno: 7
serviceName : alpha
state : ONLINE
appliedLastSeqno: 7
serviceName : bravo
state : ONLINE
appliedLastSeqno: 57
serviceName : charlie
state : ONLINE
More info
http://code.google.com/p/tungsten-toolbox/wiki/TungstenSandbox
Update:
It looks like in more recent versions of tungsten-sandbox the option –hub has been replaced by –fan-in so the command line is now
../tungsten-sandbox -n 3 –topology=fan-in –fan-in=3 -m 5.5.19 -p 7300 -l 12300 -r 10300