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

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

Failover-HA-Setup

2007-01-19 Thread Michael Schuh
Hi Richard, if you are searching a "native" Cluster filesystem, so your chances are not really good. But if you would setup a really HA-Solution w/o SPOF so you can use CODA-FS. (but hold in mind this has its own price - performance - ) Coda is an successor/fork of the legendary AFS (think from

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

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

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. >

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 sma

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). > >

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 th

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 sta

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 devic

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. T

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 normal

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! > >

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 http://lists.fre

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 mys

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 c

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 ports/net

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-

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:

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 fo

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 sinc

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 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

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/m

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

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-adress

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

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 > '/usr/l

Failover-HA-Setup

2007-01-17 Thread Richard
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 start' statement is issued. BUT since the variables for my