Need Help!!!

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?
2. Can I use it with both the mysql and postgres running?
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;

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

*/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.

TIA,


Geruel