Prev Previous Post   Next Post Next
  #1  
Old 3rd September 2008, 14:55
hello1 hello1 is offline
Junior Member
 
Join Date: Sep 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql clustering

Hi All

I am trying to setup a mysql cluster with 2 data nodes and two load balancers. I have followed the same instrauctions given http://www.howtoforge.com/setting-up...th-mysql5.1-p3 .

Issues

1. On both load balancers

/usr/sbin/ldirectord ldirectord.cf status
ldirectord stale pid file /var/run/ldirectord.ldirectord.cf.pid for /etc/ha.d/ldirectord.cf
ldirectord is stopped for /etc/ha.d/ldirectord.cf

AND

ipvsadm -L -n
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 10.10.10.15:3306 wrr
-> 10.10.10.3:3306 Route 0 0 0
-> 10.10.10.2:3306 Route 0 0 0

Also, getting the following error while starting heartbeat

ldirectord stale pid file /var/run/ldirectord.ldirectord.cf.pid for /etc/ha.d/ldirectord.cf
[ OK ]

What may be the reason? BTW i have verified that failover is happening
when i stop heartbeat on active node.



~Vincent

Last edited by hello1; 3rd September 2008 at 15:08.
Reply With Quote
Sponsored Links
 

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
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 01:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 14:38.


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