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 11th March 2007, 06:38
tfunky tfunky is offline
Member
 
Join Date: Jan 2007
Posts: 85
Thanks: 4
Thanked 2 Times in 2 Posts
Default MySQL Cluster Howto-Lo0 problem

Hello,

I've followed the Mysql cluster on Debian Sarge howto and I have a problem that I can't seem to get past.

When I reboot the mysql servers, lo:0 doesn't come back up. I have to do a ifup lo:0

This is what I have in the /etc/network/interfaces on both boxes

<code>
# The loopback network interface
auto lo
iface lo inet loopback

auto lo:0
iface lo:0 inet static
address 192.168.1.107
netmask 255.255.255.255
pre-up sysctl -p > /dev/null

</code>

With the exception of the changed IP address, that's what's in the howto. Also, if I'm thinking it through correctly, the "auto lo:0" line should fire the interface up at boot, right?

Can someone point out what I'm missing here?

Thanks!

Tfunky
Reply With Quote
Sponsored Links
  #2  
Old 11th March 2007, 12:31
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

It's probably not lo:0 but eth:0 for the interface name.
Reply With Quote
  #3  
Old 11th March 2007, 19:03
tfunky tfunky is offline
Member
 
Join Date: Jan 2007
Posts: 85
Thanks: 4
Thanked 2 Times in 2 Posts
Default

I probably should have given more info.

The clustered database systems are using lo:0 as the to listen to the virtual IP address for the database cluster, so I'm pretty sure that it is supposed to be set up on lo:0. (eth0 is used for the box's real ip address)

That all being said. Shouldn't that commands listed bring up the loopback subinterface (lo:0) at boot?

Thanks!

Tfunky
Reply With Quote
  #4  
Old 11th March 2007, 21:07
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Sorry I meant eth0:0.
The lo entry is for 127.0.0.x.

You can have / should have multiple IP's on the eth0 interface. That's where the systems communicate on. localhost is ONLY used inside a system. Thus it's not possible to talk to an external system over lo interfaces.
Reply With Quote
  #5  
Old 12th March 2007, 01:26
tfunky tfunky is offline
Member
 
Join Date: Jan 2007
Posts: 85
Thanks: 4
Thanked 2 Times in 2 Posts
Default

hmmmm....

What you're saying makes sense. Maybe there's just an error in the howto?

I'll move it over and to eht0:0 and see if it still works and report back.

Do I still need the dev/null, etc?

Thanks!

Tfunky
Reply With Quote
  #6  
Old 12th March 2007, 09:07
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Code:
>/dev/null
just means to discard output. Any response/output of the command in front of the '>' sign is lost. It's sometimes useful to remove the > /dev/null to see the actual output and if oke, add it again. It can hide too much
Reply With Quote
The Following User Says Thank You to martinfst For This Useful Post:
tfunky (4th April 2007)
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 18:58
MySQL Cluster HOWTO - Cannot load Virtual IP address samu HOWTO-Related Questions 6 11th January 2007 11:19
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 18:37
problem with load-balanced mysql cluster MvdB HOWTO-Related Questions 4 16th October 2006 12:15
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 03:53


All times are GMT +2. The time now is 00:49.


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