Re: Need Help!!!

On Thu, Sep 29, 2005 at 09:38:04AM +0800, Geruel M. Casibu wrote:
> Hi All,
> 
> I'm just a newbie on clustering and I have a few question to confirm:
> 
> 1. If I have to cluster a database, mysql and postgres, what topology should I use?

Any topology should work fine, it depends what effect you are after.

> 2. Can I use it with both the mysql and postgres running?

Yes, that should be possible.

> 3. I have tried running Topology 1: High availability in CentOS 4.1 by following the installation guide but it seems I can't get it to work even in http services.

> Here are my configurations;
> 
> --------------------------------------------------------------------------------
> 
> Ifconfig without heartbeat running;

Should this be "with heartbeat running" ?

> Node1:
> 
> eth0      Link encap:Ethernet  HWaddr 00:80:AD:71:56:52
>           inet addr:172.16.10.66  Bcast:172.16.10.255  Mask:255.255.255.0
>           inet6 addr: fe80::280:adff:fe71:5652/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:185573 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:73561 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:23514476 (22.4 MiB)  TX bytes:14478329 (13.8 MiB)
>           Interrupt:12 Base address:0xd800
> 
> eth0:0    Link encap:Ethernet  HWaddr 00:80:AD:71:56:52
>           inet addr:172.16.10.68  Bcast:172.16.10.255  Mask:255.255.255.0
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           Interrupt:12 Base address:0xd800
> 
> lo        Link encap:Local Loopback
>           inet addr:127.0.0.1  Mask:255.0.0.0
>           inet6 addr: ::1/128 Scope:Host
>           UP LOOPBACK RUNNING  MTU:16436  Metric:1
>           RX packets:74318 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:74318 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:0
>           RX bytes:10403647 (9.9 MiB)  TX bytes:10403647 (9.9 MiB)
> 
> Node2:
> 
> eth0      Link encap:Ethernet  HWaddr 00:08:A1:3D:CD:BB
>           inet addr:172.16.10.67  Bcast:172.16.10.255  Mask:255.255.255.0
>           inet6 addr: fe80::208:a1ff:fe3d:cdbb/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:230824 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:111891 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:30557368 (29.1 MiB)  TX bytes:20609230 (19.6 MiB)
>           Interrupt:10 Base address:0x2000
> 
> lo        Link encap:Local Loopback
>           inet addr:127.0.0.1  Mask:255.0.0.0
>           inet6 addr: ::1/128 Scope:Host
>           UP LOOPBACK RUNNING  MTU:16436  Metric:1
>           RX packets:24448 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:24448 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:0
>           RX bytes:3422160 (3.2 MiB)  TX bytes:3422160 (3.2 MiB)
> 
> Ifconfig without heartbeat running;
> 
> Node1:
> eth0      Link encap:Ethernet  HWaddr 00:80:AD:71:56:52
>           inet addr:172.16.10.66  Bcast:172.16.10.255  Mask:255.255.255.0
>           inet6 addr: fe80::280:adff:fe71:5652/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:186089 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:73864 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:23572307 (22.4 MiB)  TX bytes:14529257 (13.8 MiB)
>           Interrupt:12 Base address:0xd800
> 
> lo        Link encap:Local Loopback
>           inet addr:127.0.0.1  Mask:255.0.0.0
>           inet6 addr: ::1/128 Scope:Host
>           UP LOOPBACK RUNNING  MTU:16436  Metric:1
>           RX packets:74428 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:74428 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:0
>           RX bytes:10419047 (9.9 MiB)  TX bytes:10419047 (9.9 MiB)
> 
> Note: The eth0:0 was gone!!!
> 
> Node2: (As is)
> 
> Heartbeat Configurations (The same configuration was done on both node1 and node 2)
> 
> */etc/ha.d/ha.cf
> debugfile /var/log/ha-debug
> logfile /var/log/ha-log
> logfacility     local0
> keepalive 2
> deadtime 10
> udpport 694
> baud    19200
> udp     eth0            # Linux
> mcast eth0 225.0.0.1 694 1 0
> auto_failback off
> node    real1.midnight.com
> node    real2.midnight.com
> ping 172.16.10.68
> respawn hacluster /usr/lib/heartbeat/ipfail
> apiauth ipfail gid=haclient uid=hacluster
> 
> 
> */etc/ha.d/haresources
> real1.midnight.com     \
>        IPaddr2::172.16.10.68/24/eth0/172.16.10.255 \
>        IPaddr2::172.16.10.68/24/eth0/172.16.10.255

The IPaddr2::172.16.10.68/24/eth0/172.16.10.255 seems to be repeated,
this probably isn't what you want.

> */etc/ha.d/authkeys
> auth 2
> 2 sha1 midnight!
> 
> --------------------------------------------------------------------------------
> 
> 
> DNS entry was pointed to 172.16.10.68 (www.midnight.com)
> 
> So when heatbeart runs and eth0:0 was gone. I can browse my site.
> 
> I have read and reread and install and reinstall everything with the same results.
> 
> Please forgive my ignorance but I think I need help on this one.

-- 
Horms


-- 
Ultra Monkey - http://www.ultramonkey.org/
To UNSUBSCRIBE, email to [email protected], with a body:
unsubscribe ultramonkey-users [email protected]
where "[email protected]" is YOUR email address.