[SOLVED] Can I use mysql server as Master as well as Slave.

[ynilesh]

Hello experts,

I have some 2 tier situation where i want to make my existing mysql slave server as a mysql master. Can I configure my mysql server like this ?

I know there is a concept of server-id which should be unique across servers, but is there any other way i can set mysql server as master as well as slave. ?

[blade4383]

Hi Nilesh,

That is possible....

u can do the following configurations for mysql..
1. the normal master slave
2. the master master config

the first one u are familiar with..
the second one is used in on the fly replication and high availability...

[ynilesh]

Thanks for the reply....
I found a good documents which has explained it with examples.

MySql Master Master Replication « Frequent incoherent cogitation
Setting Up Master-Master Replication With MySQL 5 On Debian Etch | HowtoForge - Linux Howtos and Tutorials