Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th October 2006, 16:50
stormrider stormrider is offline
Junior Member
 
Join Date: Sep 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links
  #2  
Old 19th October 2006, 15:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 15th February 2007, 00:00
mrburnz mrburnz is offline
Junior Member
 
Join Date: Feb 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #4  
Old 15th February 2007, 19:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

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

Write operations are performed on the master only and will then be replicated to the slave.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 15th February 2007, 19:45
mrburnz mrburnz is offline
Junior Member
 
Join Date: Feb 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

you're not really using slaves in a master-master replication though, are you? isnt that why its a master to master replication?
Reply With Quote
  #6  
Old 16th February 2007, 18:18
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
MySQL Replication neil6179 Server Operation 1 12th September 2006 15:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mysql Replication alienation HOWTO-Related Questions 1 16th January 2006 08:34
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 13:29.


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