Mysql Master Master replication

Discussion in 'HOWTO-Related Questions' started by stormrider, Oct 18, 2006.

  1. stormrider

    stormrider New Member

    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?
     
  2. falko

    falko Super Moderator

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

    No, I don't think there are problems.
     
  3. mrburnz

    mrburnz New Member

    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?
     
  4. falko

    falko Super Moderator

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

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

    mrburnz New Member

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

    falko Super Moderator

Share This Page