[Linux-HA] mysql with Drbd and Heartbeat.

Manish Gajbhiye debashu06 at dataone.in
Thu Oct 18 06:30:29 MDT 2007


Thanks for your reply . I know this site . i was configured my cluster with 
the help of this site . But my concern is to monitor mysqld service . In 
case mysqld service will down the ip address and mysqld database need to 
shift on node-2 .

Pls suggest .

-regards
Manish


----- Original Message ----- 
From: "Néstor" <rotsen at gmail.com>
To: "General Linux-HA mailing list" <linux-ha at lists.linux-ha.org>
Sent: Thursday, October 18, 2007 9:24 PM
Subject: Re: [Linux-HA] mysql with Drbd and Heartbeat.


> Here is a link of  a person that set up Heartbeat and DRBD with mysql
> http://marksitblog.blogspot.com/2007/07/mysql-5-high-availability-with-drbd-8.html
>
> I hope it can help you.
>
> Nestor :-)
>
> On 10/18/07, Dejan Muhamedagic <dejanmm at fastmail.fm> wrote:
>>
>> Hi,
>>
>> On Wed, Oct 17, 2007 at 06:06:31PM +0530, Manish Gajbhiye wrote:
>> > Hi,
>> >
>> > Sorry for reply . I was on tour hence not able to update the status. 
>> > Now
>> my
>> > mysql service is woking on node1 . But if i down the mysqld service of
>> > node-1 the ip address and mysql database is not shifted to node-2 .
>> Evenif
>> > i try to down  the heartbeat service of node-1 its take lots of time 
>> > and
>> > finaliy we need to shutdown node-1  manualy by power off the switch .
>> > Could you suggest what is the problem.. mY main concern to monitor the
>> > mysql serice of node-1 .
>>
>> Perhaps you could post the logs and config.
>>
>> Thanks,
>>
>> Dejan
>>
>> >
>> >
>> > ----- Original Message -----
>> > From: "Dejan Muhamedagic" <dejanmm at fastmail.fm>
>> > To: "General Linux-HA mailing list" <linux-ha at lists.linux-ha.org>
>> > Sent: Monday, October 01, 2007 3:25 PM
>> > Subject: Re: [Linux-HA] mysql with Drbd and Heartbeat.
>> >
>> >
>> > >Hi,
>> > >
>> > >On Sat, Sep 29, 2007 at 05:38:20PM +0530, Manish Gajbhiye wrote:
>> > >>Hi,
>> > >>
>> > >>
>> > >> I want to configured the two node cluster  for monitoring my mysql
>> > >>server. My prime requirement is if i down mysqld service of node1 the
>> > >>virtual ip and mysql database need to shift on node-2 .  I know this
>> will
>> > >>be done only with  heartbeat R2 . Now as per guide by Mr. Alan . i
>> have
>> > >>configured the both the node. The virtual ip is working on node-1 but
>> the
>> > >>mysqld service in not up on node-1 . the output is attached below.
>> > >
>> > >This is the first time somebody posted an image of the terminal.
>> > >Yes, it does show what you already said above.
>> > >
>> > >>if i shutdown the node-1 the virtula ip and mysql database is shifted
>> to
>> > >>node-2 and mysqld service is alos running .  Could you suggets why i
>> am
>> > >>not able to run the mysqld service on node-1 automatic.
>> > >
>> > >Only the logs could say. If the service runs fine on one node,
>> > >but not on the other, then there must be some problem on that
>> > >node. Check the logs for errors.
>> > >
>> > >Thanks,
>> > >
>> > >Dejan
>> > >
>> > >>Pls suggest .
>> > >>
>> > >>
>> > >>
>> > >>-regards
>> > >>Manish
>> > >
>> > >
>> > >
>> > >>_______________________________________________
>> > >>Linux-HA mailing list
>> > >>Linux-HA at lists.linux-ha.org
>> > >>http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> > >>See also: http://linux-ha.org/ReportingProblems
>> > >_______________________________________________
>> > >Linux-HA mailing list
>> > >Linux-HA at lists.linux-ha.org
>> > >http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> > >See also: http://linux-ha.org/ReportingProblems
>> >
>> > _______________________________________________
>> > Linux-HA mailing list
>> > Linux-HA at lists.linux-ha.org
>> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> > See also: http://linux-ha.org/ReportingProblems
>> _______________________________________________
>> Linux-HA mailing list
>> Linux-HA at lists.linux-ha.org
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> See also: http://linux-ha.org/ReportingProblems
>>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems 




More information about the Linux-HA mailing list