Mysql Master Master replication

[stormrider]

Hello,

I have some questions about this tutorial http://howtoforge.org/mysql_master_master_replication

1) Does this tutorial assume you have just installed mysql and doesn't have any tables or databases? What about if i have a running mysql with databases and tables, should i follow this tutorial?

2) Are there any problems with InnoDB? And what about MEMORY databases?

[falko]

Originally Posted by stormrider

1) Does this tutorial assume you have just installed mysql and doesn't have any tables or databases? What about if i have a running mysql with databases and tables, should i follow this tutorial?

Of course you can have databases and tables, otherwise replication wouldn't make much sense.

Originally Posted by stormrider

2) Are there any problems with InnoDB? And what about MEMORY databases?

No, I don't think there are problems.

[mrburnz]

does some sort of offset need to be included in this walkthrough? what if a record is added to both servers at the same time, won't there be a collision during replication?

[falko]

Originally Posted by mrburnz

what if a record is added to both servers at the same time, won't there be a collision during replication?

The slave server must be readable only, you must not write to it (or your data will be inconsitent)!

Write operations are performed on the master only and will then be replicated to the slave.

[mrburnz]

you're not really using slaves in a master-master replication though, are you? isnt that why its a master to master replication?

[falko]

I'm sorry, I was thinking you were referring to http://www.howtoforge.com/mysql_database_replication instead of http://howtoforge.org/mysql_master_master_replication .

I haven't worked with master-master replication, so I'm afraid I can't help here.