headers
LIMA David | 9 Nov 2006 11:38

General discussion: JFFNMS cluster

Hi list,

I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices. 

I don't know exactly how to achieve the mysql replication for the NMS, because the database are not exactly
the same for each member of the cluster (trigger and profil tables differs: alerts are sent through two
different GSM modem that have different providers and each trigger on the second member starts with
something like "if host NMS1 is down then ...." so each alarm/event is only sent once).

I would like to know your advices regarding the best way to replicate the databases:  mysql replication
features? Clustering the DB inside the file system (DRB), scripts that copies tables, ...?

The best solution for me will be the one that ask the less manual actions when something is broken (rebuild
host after hardware failure for example ...). 

TIA

_______________
David LIMA
Professional Services
www.scc.com
 
 

______________________________________________________________________
Ce message contient des informations dont le contenu est susceptible d'etre confidentiel.
Il est destine au(x) destinataire(s) indique(s) exclusivement.

A moins que vous ne fassiez partie de la liste des destinataires, ou que vous soyez habilite a recevoir le
mail a leur place, il vous est interdit de le copier, de l'utiliser ou de devoiler son contenu a un tiers.
(Continue reading)

Permalink | Reply |
headers
wireless | 10 Nov 2006 17:38
Picon

Re: General discussion: JFFNMS cluster

LIMA David wrote:
> Hi list,
> 
> I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices.
I had looked at openmosix for this purpose, I thinkt he rpm beta is a
good choice for experimentation.
http://openmosix.sourceforge.net/
http://sourceforge.net/project/showfiles.php?group_id=46729&package_id=177868

> I don't know exactly how to achieve the mysql replication for the NMS, because the database 

are not exactly the same for each member of the cluster (trigger and
profil tables differs:

alerts are sent through two different GSM modem that have different
providers and each trigger

on the second member starts with something like "if host NMS1 is down
then ...." so each

alarm/event is only sent once).

With open mosix, I'm not sure  of all of the issues related to database
replication. The primary thrust of openmosix is that all procesess
are distributed transparently over the cluster.
> I would like to know your advices regarding the best way to replicate the databases:  

mysql replication features? Clustering the DB inside the file system
(DRB), scripts that
(Continue reading)

Permalink | Reply |
headers
LIMA David | 10 Nov 2006 10:39

Re: General discussion: JFFNMS cluster


Thanks Craig, 

We have the same approach; I use SJA to replicate (with cron) selected tables and columns. Each host has his
own polling cycle. The only difference between them is that the second only send alert if the first one is
down, the user profiles are not the same as we send SMS with another GSM provider. The goal of replication is
only to replicate changes on the first host to the second one when we add devices (SLA, hosts, zones etc
...). 

To restore things I use the excellent tool from Craig BARRAT Backuppc, I do cross backup (nms1 backups nms1
and nms2, nms2 backups nms2 and nms1). When my crashed host becomes up, the only thing that I must do is to
restore the rdd folder (Backuppc has a wonderfull CGI that permits to restore with only 1 click of mouse). I
use backuppc with rsync protocol to backup/restore to speed things.

Cheers, 

_______________
David LIMA
Professional Services
www.scc.com

 
-----Message d'origine-----
De : jffnms-users-bounces@...
[mailto:jffnms-users-bounces@...] De la part de
Craig Small
Envoyé : vendredi 10 novembre 2006 05:43
À : jffnms-users@...
Objet : Re: [jffnms-users] General discussion: JFFNMS cluster
(Continue reading)

Permalink | Reply |
headers
LIMA David | 9 Nov 2006 16:54

Re: General discussion: JFFNMS cluster


We can manage replication using sja from SQLyog (, it available under linux and can be run in cli mode.

I'm testing it now. 

I attach a sample config file for my config (juste replace ip, user and password), it is possible to use sja
over ssh, for the moment my config is not secure but it is for test purpose only.

Cheers. 

  _______________
David LIMA
Professional Services
www.scc.com

-----Message d'origine-----
De : jffnms-users-bounces@...
[mailto:jffnms-users-bounces@...] De la part de falz
Envoyé : jeudi 9 novembre 2006 16:00
À : jffnms-users@...
Objet : Re: [jffnms-users] General discussion: JFFNMS cluster

> >Hi list,
> >
> >I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices.
>
> Hi!
>
> I think you can use virtuozzo and vps, this way is easy than using cluster.
>
(Continue reading)

Permalink | Reply |
headers
Craig Small | 10 Nov 2006 05:43
Picon
Gravatar

Re: General discussion: JFFNMS cluster

On Thu, Nov 09, 2006 at 11:38:20AM +0100, LIMA David wrote:
> I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices. 
> 
> I don't know exactly how to achieve the mysql replication for the NMS, because the database are not exactly
the same for each member of the cluster (trigger and profil tables differs: alerts are sent through two
different GSM modem that have different providers and each trigger on the second member starts with
something like "if host NMS1 is down then ...." so each alarm/event is only sent once).
Are you doing this for redundancy?  If so perhaps this may work:
  * replicate selected tables, eg host and interface. from one DB to the
    other, it makes sure both are monitoring the same stuff.
  * Run the two JFFNMS polling hosts independently
  * Fiddle with the action *plugins* on the secondary device so the
    plugin checks for the primary host. That way the DBs are the same.

> The best solution for me will be the one that ask the less manual actions when something is broken (rebuild
host after hardware failure for example ...). 
rsync is wonderful for backing up stuff and putting it back.

 - Craig
--

-- 
Craig Small      GnuPG:1C1B D893 1418 2AF4 45EE  95CB C76C E5AC 12CA DFA5
Eye-Net Consulting http://www.enc.com.au/   MIEE         Debian developer
csmall at : enc.com.au                      ieee.org           debian.org

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
(Continue reading)

Permalink | Reply |
headers
Sergey Babichev | 9 Nov 2006 15:40
Picon
Favicon

Re: General discussion: JFFNMS cluster

Hi!

I think you can use virtuozzo and vps, this way is easy than using cluster.

>Hi list,
>
>I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices. 
>
>I don't know exactly how to achieve the mysql replication for the NMS, because the database are not exactly
the same for each member of the cluster (trigger and profil tables differs: alerts are sent through two
different GSM modem that have different providers and each trigger on the second member starts with
something like "if host NMS1 is down then ...." so each alarm/event is only sent once).
>
>I would like to know your advices regarding the best way to replicate the databases:  mysql replication
features? Clustering the DB inside the file system (DRB), scripts that copies tables, ...?
>
>The best solution for me will be the one that ask the less manual actions when something is broken (rebuild
host after hardware failure for example ...). 
>
>
>TIA
>
>
>_______________
>David LIMA
>Professional Services
>www.scc.com
>═
>═
>
(Continue reading)

Permalink | Reply |
headers
falz | 9 Nov 2006 15:59

Re: General discussion: JFFNMS cluster

> >Hi list,
> >
> >I would like to implement a JFFNMS cluster based on 2 servers to continuously monitor devices.
>
> Hi!
>
> I think you can use virtuozzo and vps, this way is easy than using cluster.
>

I'm not sure how implementing virtual servers gives him automatic SQL
replication. I'm not sure if what he's trying to do can be scriptable,
other than with the built in MySQL replication techniques.

However, it sounds to me that the remote JFFNMS server thing, that
apparently doesn't work 100% yet, is the answer.

--falz

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
Permalink | Reply |

Gmane