#1  
Old 28th July 2006, 11:32
Jamesk5 Jamesk5 is offline
Junior Member
 
Join Date: Apr 2006
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql replication issues

I've got replication working on two machines, both running Debian (etch) and the latest version of mySQL-server-5.0, but I've got an issue with the slave.
If the machine goes down, the slave 'feature' of mysql doesn't seem to automatically turn its self on - not sure why. I've followed the mySQL docs on replication.
Also, when I run the 'start slave' command on the slave, it doesn't go and automatically carry out any changes that have been done on the master since the slave went down.

Any suggestions will be appreciated,
James
Reply With Quote
Sponsored Links
  #2  
Old 29th July 2006, 12:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Did you take a look at this tutorial? http://www.howtoforge.com/mysql_database_replication
__________________
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 29th July 2006, 17:45
Jamesk5 Jamesk5 is offline
Junior Member
 
Join Date: Apr 2006
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes I did, but in your tutorial you only cover how to replicate a single database, where as I need the whole MySQL DB replicated for data redundancy and a hotswap incase my main machine goes down.
Your tutorial barely differs from the docs on the MySQL site - which is why I posted the question.
Thanks for the how-to anyway, but I've basically used parts of your tute and the rest of the stuff from the mysql docs.
Reply With Quote
  #4  
Old 30th July 2006, 16:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Quote:
Originally Posted by Jamesk5
where as I need the whole MySQL DB replicated for data redundancy and a hotswap incase my main machine goes down.
Basically you must list all databases in my.cnf on the master and slave.

Master:

Code:
binlog-do-db=db1
binlog-do-db=db2
binlog-do-db=db3
binlog-do-db=db4
binlog-do-db=db5
binlog-do-db=db6
binlog-do-db=db7
...
Slave:

Code:
replicate-do-db=db1
replicate-do-db=db2
replicate-do-db=db3
replicate-do-db=db4
replicate-do-db=db5
replicate-do-db=db6
replicate-do-db=db7
...
__________________
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
The Following User Says Thank You to falko For This Useful Post:
feeninuoumn (16th January 2014)
  #5  
Old 2nd August 2006, 02:49
Jamesk5 Jamesk5 is offline
Junior Member
 
Join Date: Apr 2006
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ahhh ok, so every time I add a DB to the master I need to add it to the list in both my.cnf files. It just seems a bit silly too me - considering that it works to some degree without all the lines that you mentioned above.
Reply With Quote
  #6  
Old 3rd August 2006, 14:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Yes, maybe a little bit silly, but it's working.
__________________
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
how to make php to work with mysql (php installed with apt-get, (no mysql support) grafik Installation/Configuration 3 15th May 2006 23:18
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
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


All times are GMT +2. The time now is 11:24.


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