Re: Failover-HA-Setup

2007-01-21 Thread Doug Barton
Ulrich Spoerlein wrote: Only two options remain: modify existing mysql-server script (bad idea, will be overwritten on update) or go through a proxy script which transforms start|stop - onestart|onestop You could also alter the environment of heartbeat (it's really just a bunch of poorly

Re: Failover-HA-Setup

2007-01-19 Thread Ulrich Spoerlein
Richard wrote: There is no need to make any changes to the script. Put whatever other options you want for mysql in rc.conf, and set the _enable variable to no. Then you can run /usr/local/etc/rc.d/mysql-server onestart and it will start normally just one time. Yes, and mysql will be

Re: Failover-HA-Setup

2007-01-18 Thread Richard
On Wed, 2007-01-17 at 19:48 +0100, Ivan Voras wrote: Richard wrote: Am Mittwoch, den 17.01.2007, 16:08 +0200 schrieb Nikos Vassiliadis: I remember that heartbeat can call any script you it tell to. So, you have to let heartbeat start MySQL. rc will just start heartbeat. Yes, you are

Re: Failover-HA-Setup

2007-01-18 Thread Richard
On Wed, 2007-01-17 at 10:20 -0800, Doug Barton wrote: Bill Milford wrote: You can modify the keyword section of the /usr/local/etc/rc.d/mysql-server(.sh) and add nostart This allows you to start it manually with /usr/local/etc/rc.d/mysql-server start, but it will not start at boot

Re: Failover-HA-Setup

2007-01-18 Thread Ivan Voras
Richard wrote: If the variable mysql_enable is set in '/etc/rc.conf', mysql is started on both nodes at startup, it it is not there (and the passive node won't work due to the lack of mounted diskspace), heartbeat call '/usr/local/etc/rc.d/mysql-server start' and nothing happens. rc.conf is

Re: Failover-HA-Setup

2007-01-17 Thread Dominic Marks
On Wed, 17 Jan 2007 13:47:37 +0100 Richard [EMAIL PROTECTED] wrote: Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a

Re: Failover-HA-Setup

2007-01-17 Thread Vladimir Botka
Hello, just modify the /usr/local/etc/rc.d/mysql-server script. Cheers, -vlado Richard píše v st 17. 01. 2007 v 13:47 +0100: Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am running heartbeat on a STABLE-system, the failover works fine for

Re: Failover-HA-Setup

2007-01-17 Thread Bill Moran
In response to Vladimir Botka [EMAIL PROTECTED]: Richard píše v st 17. 01. 2007 v 13:47 +0100: Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am

Re: Failover-HA-Setup

2007-01-17 Thread Richard
Am Mittwoch, den 17.01.2007, 13:16 + schrieb Dominic Marks: setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a '/usr/local/etc/rc.d/mysql-server start' statement is issued. BUT since the variables for mysql are not set

Re: Failover-HA-Setup

2007-01-17 Thread Dominic Marks
On Wed, 17 Jan 2007 14:47:43 +0100 Richard [EMAIL PROTECTED] wrote: Am Mittwoch, den 17.01.2007, 13:16 + schrieb Dominic Marks: setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a '/usr/local/etc/rc.d/mysql-server

Re: Failover-HA-Setup

2007-01-17 Thread Richard
Am Mittwoch, den 17.01.2007, 17:47 +0400 schrieb Rauf Kuliyev: Try '/usr/local/etc/rc.d/mysql-server forcestart' . I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a '/usr/local/etc/rc.d/mysql-server start' statement is issued.

Re: Failover-HA-Setup

2007-01-17 Thread Rauf Kuliyev
Try '/usr/local/etc/rc.d/mysql-server forcestart' On 1/17/07, Richard [EMAIL PROTECTED] wrote: Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see

Re: Failover-HA-Setup

2007-01-17 Thread Dmitriy Kirhlarov
Hi! On Wed, Jan 17, 2007 at 01:47:37PM +0100, Richard wrote: I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a Why you ignore carp(4) and ports/net/ifstated? '/usr/local/etc/rc.d/mysql-server start' statement is issued. BUT since

Re: Failover-HA-Setup

2007-01-17 Thread Richard Verwayen
Am Mittwoch, den 17.01.2007, 14:04 + schrieb Dominic Marks: On Wed, 17 Jan 2007 14:47:43 +0100 Richard [EMAIL PROTECTED] wrote: Am Mittwoch, den 17.01.2007, 13:16 + schrieb Dominic Marks: setup. I am running heartbeat on a STABLE-system, the failover works fine for

Re: Failover-HA-Setup

2007-01-17 Thread Dominic Marks
On Wed, 17 Jan 2007 15:20:32 +0100 Richard Verwayen [EMAIL PROTECTED] wrote: Am Mittwoch, den 17.01.2007, 14:04 + schrieb Dominic Marks: On Wed, 17 Jan 2007 14:47:43 +0100 Richard [EMAIL PROTECTED] wrote: Am Mittwoch, den 17.01.2007, 13:16 + schrieb Dominic Marks: setup.

Re: Failover-HA-Setup

2007-01-17 Thread Nikos Vassiliadis
On Wednesday 17 January 2007 14:47, Richard wrote: Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a '/usr/local/etc/rc.d/mysql-server

Re: Failover-HA-Setup

2007-01-17 Thread Richard
Am Mittwoch, den 17.01.2007, 17:25 +0300 schrieb Dmitriy Kirhlarov: Hi! On Wed, Jan 17, 2007 at 01:47:37PM +0100, Richard wrote: I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a Why you ignore carp(4) and

Re: Failover-HA-Setup

2007-01-17 Thread Eugene Grosbein
On Wed, Jan 17, 2007 at 03:10:29PM +0100, Richard wrote: Try '/usr/local/etc/rc.d/mysql-server forcestart' Hm, that's only a temporary solution. As a background: Heartbeat monitors the HA nodes via a UDP ping (or other method) and if one of the nodes goes down, it takes over a

Re: Failover-HA-Setup

2007-01-17 Thread Richard
Hi Nikos! Am Mittwoch, den 17.01.2007, 16:08 +0200 schrieb Nikos Vassiliadis: I am running heartbeat on a STABLE-system, the failover works fine for IP-adresses and I am able to see that a '/usr/local/etc/rc.d/mysql-server start' statement is issued. BUT since the variables for mysql are

Re: Failover-HA-Setup

2007-01-17 Thread Dmitriy Kirhlarov
On Wed, Jan 17, 2007 at 03:20:32PM +0100, Richard Verwayen wrote: Oh, should I have mentioned that it is a shared SCSI-Storage in between? You can use gmirror(8) with ggated(8). By. Dmitriy ___ freebsd-stable@freebsd.org mailing list

RE: Failover-HA-Setup

2007-01-17 Thread Bill Milford
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sent: Wednesday, January 17, 2007 8:37 AM To: freebsd-stable@freebsd.org Subject: Re: Failover-HA-Setup Am Mittwoch, den 17.01.2007, 17:25 +0300 schrieb Dmitriy Kirhlarov: Hi! On Wed, Jan 17, 2007 at 01:47:37PM

Re: Failover-HA-Setup

2007-01-17 Thread Doug Barton
Please don't post replies to messages on the freebsd lists above the message. While that's common in other circles (especially the business world) it's not how we do things here. Rauf Kuliyev wrote: Try '/usr/local/etc/rc.d/mysql-server forcestart' If your intention is to start a service

Re: Failover-HA-Setup

2007-01-17 Thread Doug Barton
Bill Milford wrote: You can modify the keyword section of the /usr/local/etc/rc.d/mysql-server(.sh) and add nostart This allows you to start it manually with /usr/local/etc/rc.d/mysql-server start, but it will not start at boot time as rcorder skips files with the nostart keyword. The

Re: Failover-HA-Setup

2007-01-17 Thread Ivan Voras
Dmitriy Kirhlarov wrote: On Wed, Jan 17, 2007 at 03:20:32PM +0100, Richard Verwayen wrote: Oh, should I have mentioned that it is a shared SCSI-Storage in between? You can use gmirror(8) with ggated(8). I think his problem is that you can't have two machines RW mounting the same device

Re: Failover-HA-Setup

2007-01-17 Thread Ivan Voras
Richard wrote: Am Mittwoch, den 17.01.2007, 16:08 +0200 schrieb Nikos Vassiliadis: I remember that heartbeat can call any script you it tell to. So, you have to let heartbeat start MySQL. rc will just start heartbeat. Yes, you are right, and exactly that was my problem. It didn't start.

Re: Failover-HA-Setup

2007-01-17 Thread Mark Saad
Ivan Voras wrote: Dmitriy Kirhlarov wrote: On Wed, Jan 17, 2007 at 03:20:32PM +0100, Richard Verwayen wrote: Oh, should I have mentioned that it is a shared SCSI-Storage in between? You can use gmirror(8) with ggated(8). I think his problem is that you can't have two machines RW mounting

Re: Failover-HA-Setup

2007-01-17 Thread Tom Samplonius
- Mark Saad [EMAIL PROTECTED] wrote: Ivan Voras wrote: Dmitriy Kirhlarov wrote: On Wed, Jan 17, 2007 at 03:20:32PM +0100, Richard Verwayen wrote: Oh, should I have mentioned that it is a shared SCSI-Storage in between? You can use gmirror(8) with ggated(8). I think his

Re: Failover-HA-Setup

2007-01-17 Thread James Long
Date: Wed, 17 Jan 2007 13:47:37 +0100 From: Richard [EMAIL PROTECTED] Subject: Failover-HA-Setup To: freebsd-stable@freebsd.org Message-ID: [EMAIL PROTECTED] Content-Type: text/plain Hi there! I am looking for a solution for a small problem regarding a high availability setup. I am