Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2008, 12:10
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default Database Replication In MySQL just doesn't work.

Hello all,

After following the tutorial how to setup the MySQL replacation.(here)
For some reason it doesn't seem to replicate.
I can't find any logs (or offcourse i am not looking correctly).
Can somebody help me troubleshoot this issue and resolve it?

Many thanks in advance.

kind regards,

Jottie
Reply With Quote
Sponsored Links
  #2  
Old 9th September 2008, 13:21
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default

Anyone? I just cant seem to find the issue.
Reply With Quote
  #3  
Old 9th September 2008, 18:31
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Any errors in /var/log/syslog?
__________________
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:
HooGLaNDeR (10th September 2008)
  #4  
Old 10th September 2008, 16:56
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default

I've checked the logs on my master and on my slave.
I don't find any logs regarding the replication in my master servers log.
I do however see this in my slave servers log :

Sep 10 14:42:05 ns2 mysqld[2329]: 080910 14:42:05 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000246' at position 2012, relay log './ns2-relay-bin.000725' position: 4
Sep 10 14:42:05 ns2 mysqld[2329]: 080910 14:42:05 [Note] Slave I/O thread: connected to master '<replicateuser>@x.x.x.x:3306', replication started in log 'mysql-bin.000248' at position 98

This should make me believe its working as designed.

However, when i update the the master sql DB, it doesn't replicate to the slave.

Any other idea's where i could check ?
Reply With Quote
  #5  
Old 10th September 2008, 17:08
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default

Never mind. For some reason all seems to work now. I guess i should open up topics just to resolve issues

Thanks anyway!
Reply With Quote
  #6  
Old 12th September 2008, 09:56
Reptile Reptile is offline
Member
 
Join Date: Apr 2007
Posts: 62
Thanks: 6
Thanked 1 Time in 1 Post
Default

You wait when the dbs end up out of sync again then you'll be back here claiming it doesn't work properly

I gave up with the replication server, it's borderlines useless.
Reply With Quote
  #7  
Old 13th September 2008, 11:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

It's working for me without problems (on production systems).
__________________
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
  #8  
Old 24th December 2008, 17:31
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
 
Default

Well, so far it still seems to work. I don't know why however.
I'm still happy.
__________________
A computer is almost human - except that it does not blame its mistakes on another computer.
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
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
How can I check the How To Set Up Database Replication In MySQL cruz HOWTO-Related Questions 1 31st October 2007 14:45
Mail System doesnt work! crichton Installation/Configuration 3 18th September 2007 00:49
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


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


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