HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Mysql Master Master replication (http://www.howtoforge.com/forums/showthread.php?t=7547)

stormrider 18th October 2006 16:50

Mysql Master Master replication
 
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 19th October 2006 15:12

Quote:

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. ;)

Quote:

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 15th February 2007 00:00

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 15th February 2007 19:35

Quote:

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)! :eek:

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

mrburnz 15th February 2007 19:45

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

falko 16th February 2007 18:18

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.


All times are GMT +2. The time now is 14:04.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.