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 : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Craig Small Envoyé : vendredi 10 novembre 2006 05:43 À : jffnms-users@lists.sourceforge.net Objet : Re: [jffnms-users] 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 _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users ______________________________________________________________________ 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. Si vous avez recu cet email par erreur, merci de prendre contact avec l'emetteur. Les opinions exprimees dans cet e-mail sont celles de l'emetteur et ne refletent pas necessairement celles de l'entreprise. Ce e-mail peut contenir des pieces jointes dont certaines pourraient contenir des virus qui pourraient endommager votre systeme informatique. La compagnie a pris toutes dispositions afin de minimiser ce risque et decline toute responsabilite pour toute perte ou dommage resultant directement ou indirectement de l'utilisation de cet email ou de son contenu. Il vous appartient d'effectuer vos propres controles anti-virus avant d'ouvrir la ou les pieces jointes. ______________________________________________________________________ ------------------------------------------------------------------------- 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 _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
