[Linux-HA] mysql with Drbd and Heartbeat.

[Néstor]

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
>