Replication in MySQL

[ksankaram]

Hi,

I have a question on the replication in MySQL. From the manual I understand that only one-way replication is possible in MySQL i.e. the updates on the master server alone can be propagated to one or more slave servers.

Is there anyway that you could suggest so that the updates to the tables on the slave servers can also be propagated to the master server. My application requirement demands this. The master data will be updated only on the master server and this needs to be propagated to all the slave servers. But, the application demands that the transaction data can be updated either on the master server or on the slave server and at a given point of time this data should be in synch on the master as well as the slave servers. How can I achieve this with MySQL. Please suggest.

Thanks in advance!!!