OK after a while I got brave and changed the ldirectord.cf file myself. I included the two services (MYSQL & Apache) like so:
receive="Elvis has left the building!"
# Global Directives
virtual = 192.168.0.105:3306
service = mysql
real = 192.168.0.101:3306 gate
real = 192.168.0.102:3306 gate
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr
I then rebooted the two load balancers and issued the following command:
bubba:/home/pete# ipvsadm -L -n
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.0.105:80 rr
-> 192.168.0.101:80 Route 1 0 0
-> 192.168.0.102:80 Route 1 0 0
TCP 192.168.0.105:3306 wrr
-> 192.168.0.101:3306 Route 1 0 0
-> 192.168.0.102:3306 Route 1 0 0
Seeing this was what I wanted. I was able to access both services via the virtual address 192.168.0.105. I added rsync for Apache using this How To:
This gave me all the functionality I was looking for:
1. Replicated MYSQL databases
2. Mirrored Apapche Servers
3. Loadbalancing of services
4. Fault-tolerence of services
My next question would be how can I take advantage of this technology for my mail server which really is the most important service I have.
Thanks again to anyone who can help,