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 mysql are not set in rc.conf (Otherwise it would be started at startup), it isn't starting at all. So my question: How to set those rc.conf-variables in order to start services in such an setup? Or is there a better solution? cu! Richard
On Wed, 17 Jan 2007 13:47:37 +0100 Richard <lists@leewelle.de> 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 start' statement is issued. BUT since > the variables for mysql are not set in rc.conf (Otherwise it would be > started at startup), it isn't starting at all. > > So my question: How to set those rc.conf-variables in order to start > services in such an setup? Or is there a better solution?Why have the backup MySQL server stopped at all? Dom
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 > 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 in rc.conf (Otherwise it would be > started at startup), it isn't starting at all. > > So my question: How to set those rc.conf-variables in order to start > services in such an setup? Or is there a better solution? > > > cu! > > Richard > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >
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. BUT since > > the variables for mysql are not set in rc.conf (Otherwise it would be > > started at startup), it isn't starting at all.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 clustered IP and then starts services by issuing the corresponding scripts in [/usr/local|]/etc/rc.d with the argument start... So your solution will not really work.... With best regards Richard
Try '/usr/local/etc/rc.d/mysql-server forcestart' On 1/17/07, Richard <lists@leewelle.de> 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 start' statement is issued. BUT since > the variables for mysql are not set in rc.conf (Otherwise it would be > started at startup), it isn't starting at all. > > So my question: How to set those rc.conf-variables in order to start > services in such an setup? Or is there a better solution? > > > cu! > > Richard > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >
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 aWhy you ignore carp(4) and ports/net/ifstated?> '/usr/local/etc/rc.d/mysql-server start' statement is issued. BUT since > the variables for mysql are not set in rc.conf (Otherwise it would be > started at startup), it isn't starting at all.You can use in /etc/rc.conf: [ -r /usr/local/etc/rc.mysql.conf ] && . /usr/local/etc/rc.mysql.conf and using this include for manipulate with mysql start variables. Your shared IP address moving with script, I think. This script can modify /usr/local/etc/rc.mysql.conf also. WBR. Dmitriy
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 start' statement is issued. BUT since > the variables for mysql are not set in rc.conf (Otherwise it would be > started at startup), it isn't starting at all. > > So my question: How to set those rc.conf-variables in order to start > services in such an setup? Or is there a better solution?Which service is highly available in this setup? MySQL? How do you sync the data? ggate? 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. Nikos
> Date: Wed, 17 Jan 2007 13:47:37 +0100 > From: Richard <lists@leewelle.de> > Subject: Failover-HA-Setup > To: freebsd-stable@freebsd.org > Message-ID: <1169038057.23831.24.camel@richard02> > Content-Type: text/plain > > 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 mysql are not set in rc.conf (Otherwise it would be > started at startup), it isn't starting at all. > > So my question: How to set those rc.conf-variables in order to start > services in such an setup? Or is there a better solution? > > > cu! > > Richardexport mysql_enable="YES" && /usr/local/etc/rc.d/mysql-server start
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 Andrew Morton?) and IBM. With Coda you can figure out an Network-Filesystem- server with replication and local caching, so you can get the required filesystem for mysql mounted rw at boot-time and you have only to start mysql-server with the suggestet commands and configurations. For coda look in the ports or at: http://www.coda.cs.cmu.edu/ i have planned out some tests with it in the near future, but no practices at this time. My knowledge is only based on the documentation. greetings michael -- michael-schuh.net Michael Schuh Preu?enstr. 13 66111 Saarbr?cken phone: 0681/8319664 mobil: 0177/9738644 @: michael.schuh@gmail.com