Replication

[Juergen H]

I'v read about mysql-proxy and think thats a resolution for a big problem...

a cricluar replicationi works like

A->B->C->D->A

if anny goes wrong the replikation is broken and it's hard to sync all server.
it's posible to lose data.

mysql-proxy can listen to replication and so it's look like the resulution for the problem. this my idea:

A <- proxy <- B,C,D
B <- proxy <- A,C,D
C <- proxy <- A,B,D
D <- proxy <- A,B,C

every server have one proxy. the master of server is connected to proxy. the proxy get the replication-stream of all other server and send this mixed to master. (yes mysql 5.0 and auto_increment_increment and auto_increment_offset is set vor every server).

if one server fails the whole data are in the other servers. the proken server don't break the other replication. if i reconnect the broken server the replication starts at this point.

is this posibele with mysql-proxy? and how?