|
I am trying to setup load balanced mysql servers. The ldirectord and
heartbeat are installed on the same servers I am trying to load balance
to. I am not sure if this is my problem or not. here are my configs.
my 1st sql server is 192.168.0.225 2nd is 192.168.0.226 my load
balanced IP is supposed to be 192.168.0.229
-authkeys- (yes its 600)
#########################################
auth 1
1 sha1 thisismysecretepassword
#########################################
-ha.cf-
#########################################
use_logd yes
bcast eth0
mcast eth0 225.0.0.1 694 1 0
auto_failback off
node mysql-api-1 mysql-api-2
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster
initdead 120
udpport 694
keepalive 2
crm on
#########################################
-haresources-
#########################################
mysql-api-1 \
ldirectord::--debug::ldirectord.cf \
LVSSyncDaemonSwap::master \
IPaddr2::192.168.0.229/24/eth0/192.168.0.255
-ldirectord.cf-
# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="local0"
quiescent=yes
virtual = 192.168.0.229:3306
service = mysql
real = 192.168.0.225:3306 gate
real = 192.168.0.226:3306 gate
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr
#########################################
more /etc/network/interfaces
#########################################
# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).
# The loopback network interface
auto lo
iface lo inet loopback
auto lo:0
iface lo:0 inet static
address 192.168.0.229
netmask 255.255.255.255
pre-up sysctl -p > /dev/null
# The primary network interface
auto eth0
iface eth0 inet static
address 192.168.0.225
netmask 255.255.255.0
network 192.168.0.0
broadcast 192.168.0.255
gateway 192.168.0.1
# dns-* options are implemented by the resolvconf package, if
installed
dns-nameservers 192.168.0.1
#########################################
/etc/sysctl.conf
#########################################
# the following stops low-level messages on console
kernel.printk = 4 4 1 7
# enable /proc/$pid/maps privacy so that memory relocations are not
# visible to other users.
kernel.maps_protect = 1
##############################################################3
# Functions previously found in netbase
#
# Uncomment the next line to enable Spoof protection (reverse-path filter)
#net.ipv4.conf.default.rp_filter=1
# Uncomment the next line to enable TCP/IP SYN cookies
#net.ipv4.tcp_syncookies=1
# Uncomment the next line to enable packet forwarding for IPv4
net.ipv4.conf.default.forwarding=1
# Enable configuration of arp_ignore option
net.ipv4.conf.all.arp_ignore = 1
# When an arp request is received on eth0, only respond if that address is
# configured on eth0. In particular, do not respond if the address is
# configured on lo
net.ipv4.conf.eth0.arp_ignore = 1
# Ditto for eth1, add for all ARPing interfaces
#net.ipv4.conf.eth1.arp_ignore = 1
# Enable configuration of arp_announce option
net.ipv4.conf.all.arp_announce = 2
#########################################
syslog says this after a restart of /etc/init.d/hearbeat
Oct 18 14:00:33 MYSQL-API-1 attrd: [4341]: info: main: Starting mainloop...
Oct 18 14:00:34 MYSQL-API-1 crmd: [4342]: info: update_dc: Set DC to
mysql-api-2
(1 .0.9)
Oct 18 14:00:35 MYSQL-API-1 cib: [4338]: info: cib_replace_notify:
Replaced:
0.0.0
-> 0.0.10 from <null>
Oct 18 14:00:35 MYSQL-API-1 crmd: [4342]: info: populate_cib_nodes:
Requesting
the
list of configured nodes
Oct 18 14:00:36 MYSQL-API-1 crmd: [4342]: notice: populate_cib_nodes:
Node:
mysql-a
pi-2 (uuid: ec734cdf-a3d5-4a6f-aeed-6499ecbb6420)
Oct 18 14:00:36 MYSQL-API-1 crmd: [4342]: notice: populate_cib_nodes:
Node:
mysql-a
pi-1 (uuid: dd75e923-3bed-4826-87c1-50d7aa855c1b)
Oct 18 14:00:36 MYSQL-API-1 crmd: [4342]: info: update_dc: Set DC to
mysql-api-2
(1 .0.9)
Oct 18 14:00:36 MYSQL-API-1 crmd: [4342]: info: do_state_transition:
State
transiti
on S_PENDING -> S_NOT_DC [ input=I_NOT_DC cause=C_HA_MESSAGE
origin=do_cl_join_fina
lize_respond ]
after running /sbin/ldirectord -d start I get this. looping
DEBUG2: Checking 192.168.0.229 server=192.168.0.226 port=3306
Use of uninitialized value in split at /usr/sbin/ldirectord line 2642.
DEBUG2: Disabled real
server=negotiate:mysql:tcp:192.168.0.226:3306:::1:gate:\/SELECT\ \*\
FROM\ connectioncheck: (virtual=tcp:192.168.0.229:3306)
DEBUG2: Checking negotiate: real
server=negotiate:mysql:tcp:192.168.0.225:3306:::1:gate:\/SELECT\ \*\
FROM\ connectioncheck: (virtual=tcp:192.168.0.229:3306)
DEBUG2: Checking 192.168.0.229 server=192.168.0.225 port=3306
Use of uninitialized value in split at /usr/sbin/ldirectord line 2642.
DEBUG2: Disabled real
server=negotiate:mysql:tcp:192.168.0.225:3306:::1:gate:\/SELECT\ \*\
FROM\ connectioncheck: (virtual=tcp:192.168.0.229:3306)
DEBUG2: Checking negotiate: real
server=negotiate:mysql:tcp:192.168.0.226:3306:::1:gate:\/SELECT\ \*\
FROM\ connectioncheck: (virtual=tcp:192.168.0.229:3306)
DEBUG2: Checking 192.168.0.229 server=192.168.0.226 port=3306
Use of uninitialized value in split at /usr/sbin/ldirectord line 2642.
DEBUG2: Disabled real
server=negotiate:mysql:tcp:192.168.0.226:3306:::1:gate:\/SELECT\ \*\
FROM\ connectioncheck: (virtual=tcp:192.168.0.229:3306)
And last.. crm_mon says this
Refresh in 13s...
============
Last updated: Thu Oct 18 14:03:22 2007
Current DC: mysql-api-2 (ec734cdf-a3d5-4a6f-aeed-6499ecbb6420)
2 Nodes configured.
0 Resources configured.
============
Node: mysql-api-2 (ec734cdf-a3d5-4a6f-aeed-6499ecbb6420): online
Node: mysql-api-1 (dd75e923-3bed-4826-87c1-50d7aa855c1b): online
Any ideas? I have been working on this for hours now.
Thanks
Bill
--
Bill Locke
AYALOGIC
Systems administrator
Personal Q 330-247-2182
Support Q 330-247-2188
|
